APPS.OKL_ITI_PVT dependencies on OKX_PARTY_SITE_USES_V

Line 331: -- Description : Validate against OKX_PARTY_SITE_USES_V

327: ----------------------------------5----------------------------------------------
328: -- Start of Commnets
329: -- Badrinath Kuchibholta
330: -- Procedure Name : Validate_object_id1_new
331: -- Description : Validate against OKX_PARTY_SITE_USES_V
332: -- Business Rules :
333: -- Parameters : OUT Return Status, IN Rec Info
334: -- Version : 1.0
335: -- End of Commnets

Line 344: FROM OKX_PARTY_SITE_USES_V

340: CURSOR c_object_id1_new_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE) is
341: SELECT 1
342: FROM DUAL
343: WHERE EXISTS (SELECT '1'
344: FROM OKX_PARTY_SITE_USES_V
345: WHERE id1 = p_id1);
346: -- FROM OKX_CUST_SITE_USES_V
347: BEGIN
348: -- initialize return status

Line 424: FROM OKX_PARTY_SITE_USES_V

420: p_id2 OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE) is
421: SELECT 1
422: FROM DUAL
423: WHERE EXISTS (SELECT '1'
424: FROM OKX_PARTY_SITE_USES_V
425: WHERE id2 = p_id2
426: AND id1 = p_id1);
427: -- FROM OKX_CUST_SITE_USES_V
428: BEGIN

Line 584: FROM OKX_PARTY_SITE_USES_V

580: CURSOR c_object_id1_old_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE) is
581: SELECT 1
582: FROM DUAL
583: WHERE EXISTS (SELECT '1'
584: FROM OKX_PARTY_SITE_USES_V
585: WHERE id1 = p_id1);
586: -- FROM OKX_CUST_SITE_USES_V
587:
588: BEGIN

Line 659: FROM OKX_PARTY_SITE_USES_V

655: p_id2 OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE) is
656: SELECT 1
657: FROM DUAL
658: WHERE EXISTS (SELECT '1'
659: FROM OKX_PARTY_SITE_USES_V
660: WHERE id2 = p_id2
661: AND id1 = p_id1);
662: -- FROM OKX_CUST_SITE_USES_V
663: