project BLF > class BSODCategory > business logic query SODCategoryPrim

Parameters

iiCategoryID	integer
icCategoryCode	character

query condition

each SODCategory where

SODCategory.SODCategory_ID = iiCategoryID AND
SODCategory.SODCategoryCode = icCategoryCode

query resultset tqSODCategoryPrim

field name	data type	db field	description
tiSODCategory_ID	integer	SODCategory.SODCategory_ID	record ID
tcSODCategoryCode	character	SODCategory.SODCategoryCode	SOD category code

Internal usage

BLF

method BSODCategoryExclusion.ApiGetMatrixData
method BSODCategoryExclusion.DataLoadByInput
read related business field(s) on tResources.SODcategory_ID
read related business field(s) on tSODExceptionLn.SODCategory1_ID
read related business field(s) on tSODExceptionLn.SODCategory2_ID
read related business field(s) on tSODExclusion.SODCategory1_ID
read related business field(s) on tSODExclusion.SODCategory2_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tResources.SODcategory_ID
validate related business field(s) on tSODExceptionLn.SODCategory1_ID
validate related business field(s) on tSODExceptionLn.SODCategory2_ID
validate related business field(s) on tSODExclusion.SODCategory1_ID
validate related business field(s) on tSODExclusion.SODCategory2_ID