APPS.OKL_ITI_PVT dependencies on DUAL

Line 50: FROM DUAL

46: p_itiv_rec IN itiv_rec_type) IS
47: ln_dummy number := 0;
48: CURSOR c_tas_id_validate(p_id number) is
49: SELECT 1
50: FROM DUAL
51: WHERE EXISTS (SELECT '1'
52: FROM OKL_TRX_ASSETS
53: WHERE id = p_id);
54:

Line 129: FROM DUAL

125: p_itiv_rec IN itiv_rec_type) IS
126: ln_dummy number := 0;
127: CURSOR c_tal_id_validate(p_id number) is
128: SELECT 1
129: FROM DUAL
130: WHERE EXISTS (SELECT '1'
131: FROM OKL_TXL_ASSETS_V
132: WHERE id = p_id);
133:

Line 202: FROM DUAL

198: p_itiv_rec IN itiv_rec_type) IS
199: ln_dummy number := 0;
200: CURSOR c_kle_id_validate(p_id number) is
201: SELECT 1
202: FROM DUAL
203: WHERE EXISTS (SELECT id
204: FROM OKL_K_LINES_V
205: WHERE id = p_id);
206:

Line 342: FROM DUAL

338: p_itiv_rec IN itiv_rec_type) IS
339: ln_dummy number := 0;
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

Line 422: FROM DUAL

418: ln_dummy number := 0;
419: CURSOR c_object_id2_new_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
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);

Line 504: FROM DUAL

500: ln_dummy number := 0;
501: CURSOR c_jtot_code_new_validate(
502: p_jtot_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE) is
503: SELECT 1
504: FROM DUAL
505: WHERE EXISTS (SELECT '1'
506: FROM JTF_OBJECTS_B
507: WHERE object_code = p_jtot_code_new);
508: BEGIN

Line 582: FROM DUAL

578: p_itiv_rec IN itiv_rec_type) IS
579: ln_dummy number := 0;
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

Line 657: FROM DUAL

653: ln_dummy number := 0;
654: CURSOR c_object_id2_old_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE,
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);

Line 734: FROM DUAL

730: ln_dummy number := 0;
731: CURSOR c_jtot_code_old_validate(
732: p_jtot_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE) is
733: SELECT 1
734: FROM DUAL
735: WHERE EXISTS (SELECT '1'
736: FROM JTF_OBJECTS_B
737: WHERE object_code = p_jtot_code_old);
738: BEGIN

Line 863: FROM DUAL

859: ln_dummy number := 0;
860:
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:

Line 942: FROM DUAL

938: p_itiv_rec IN itiv_rec_type) IS
939: ln_dummy number := 0;
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:

Line 1016: FROM DUAL

1012: p_itiv_rec IN itiv_rec_type) IS
1013: ln_dummy number := 0;
1014: CURSOR c_inventory_org_id_validate(p_id1 OKX_ORGANIZATION_DEFS_V.ID1%TYPE) is
1015: SELECT 1
1016: FROM DUAL
1017: WHERE EXISTS (SELECT '1'
1018: FROM OKX_ORGANIZATION_DEFS_V
1019: WHERE id2 = G_ID2
1020: AND organization_type = 'INV'

Line 1090: FROM DUAL

1086: p_itiv_rec IN itiv_rec_type) IS
1087: ln_dummy number := 0;
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: );

Line 1216: FROM DUAL

1212: p_itiv_rec IN itiv_rec_type) IS
1213: ln_dummy number := 0;
1214: CURSOR c_asd_id_validate(p_asd_id NUMBER) is
1215: SELECT 1
1216: FROM DUAL
1217: WHERE EXISTS (SELECT '1'
1218: FROM OKL_TXD_ASSETS_B
1219: WHERE id = p_asd_id
1220: );