DBA Data[Home] [Help]

APPS.OKL_ITI_PVT dependencies on CSI_ITEM_INSTANCES

Line 1079: -- Description : Validate against CSI_ITEM_INSTANCES

1075: --------------------------------------15----------------------------------------
1076: -- Start of Commnets
1077: -- avsingh
1078: -- Procedure Name : validate_instance_id
1079: -- Description : Validate against CSI_ITEM_INSTANCES
1080: -- Business Rules :
1081: -- Parameters : OUT Return Status, IN Rec Info
1082: -- Version : 1.0
1083: -- End of Commnets

Line 1092: FROM CSI_ITEM_INSTANCES

1088: CURSOR c_instance_id_validate(p_instance_id NUMBER) is
1089: SELECT 1
1090: FROM DUAL
1091: WHERE EXISTS (SELECT '1'
1092: FROM CSI_ITEM_INSTANCES
1093: WHERE instance_id = p_instance_id
1094: );
1095: BEGIN
1096: -- initialize return status