APPS.OKL_ITI_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 851: -- Description : FK validation with OKX_SYSTEM_ITEMS_V

847: ------------------------------------------12--------------------------------------
848: -- Start of Commnets
849: -- Badrinath Kuchibholta
850: -- Procedure Name : Validate_inv_item_id
851: -- Description : FK validation with OKX_SYSTEM_ITEMS_V
852: -- Business Rules :
853: -- Parameters : OUT Return Status, IN Rec Info
854: -- Version : 1.0
855: -- End of Commnets

Line 865: FROM OKX_SYSTEM_ITEMS_V

861: CURSOR c_inv_item_id_validate(p_id number) is
862: SELECT 1
863: FROM DUAL
864: WHERE EXISTS (SELECT '1'
865: FROM OKX_SYSTEM_ITEMS_V
866: WHERE id1 = p_id);
867:
868: BEGIN
869: -- initialize return status

Line 931: -- Description : FK validation with OKX_SYSTEM_ITEMS_V

927: --------------------------------------------13------------------------------------
928: -- Start of Commnets
929: -- Badrinath Kuchibholta
930: -- Procedure Name : Validate_inv_master_org__id
931: -- Description : FK validation with OKX_SYSTEM_ITEMS_V
932: -- Business Rules :
933: -- Parameters : OUT Return Status, IN Rec Info
934: -- Version : 1.0
935: -- End of Commnets

Line 944: FROM OKX_SYSTEM_ITEMS_V

940: CURSOR c_inv_master_org_id_validate(p_id number) is
941: SELECT 1
942: FROM DUAL
943: WHERE EXISTS (SELECT '1'
944: FROM OKX_SYSTEM_ITEMS_V
945: WHERE id2 = p_id);
946:
947: BEGIN
948: -- initialize return status