APPS.EGO_GTIN_PVT dependencies on DUAL

Line 59: FROM DUAL

55: IS
56: l_temp VARCHAR2(1);
57: BEGIN
58: SELECT 'X' INTO l_temp
59: FROM DUAL
60: WHERE EXISTS
61: (
62: SELECT 1
63: FROM MTL_CUSTOMER_ITEMS MCI,

Line 334: FROM DUAL

330:
331: SELECT
332: 'Y'
333: INTO l_temp
334: FROM DUAL
335: WHERE
336: NOT EXISTS
337: (
338: SELECT

Line 393: FROM DUAL

389:
390: SELECT
391: 'Y'
392: INTO l_temp
393: FROM DUAL
394: WHERE
395: EXISTS
396: (
397: SELECT

Line 448: FROM DUAL

444:
445: SELECT
446: 'Y'
447: INTO l_temp
448: FROM DUAL
449: WHERE EXISTS
450: (
451: SELECT
452: 1

Line 597: FROM DUAL

593:
594: SELECT
595: 'Y'
596: INTO l_temp
597: FROM DUAL
598: WHERE EXISTS
599: (
600: SELECT
601: 1

Line 745: FROM DUAL

741:
742: SELECT
743: 'Y'
744: INTO l_temp
745: FROM DUAL
746: WHERE EXISTS
747: (
748: SELECT
749: 1

Line 831: FROM DUAL

827:
828: SELECT
829: 'Y'
830: INTO l_temp
831: FROM DUAL
832: WHERE EXISTS
833: (
834: SELECT
835: 1

Line 836: FROM DUAL

832: WHERE EXISTS
833: (
834: SELECT
835: 1
836: FROM DUAL
837: WHERE EXISTS
838: (
839: SELECT
840: 1

Line 890: FROM DUAL

886:
887: SELECT
888: 'Y'
889: INTO l_temp
890: FROM DUAL
891: WHERE EXISTS
892: (
893: SELECT
894: 1

Line 895: FROM DUAL

891: WHERE EXISTS
892: (
893: SELECT
894: 1
895: FROM DUAL
896: WHERE EXISTS
897: (
898: SELECT
899: 1

Line 1065: FROM DUAL

1061:
1062: SELECT
1063: 'Y'
1064: INTO l_temp
1065: FROM DUAL
1066: WHERE NOT EXISTS
1067: (
1068: SELECT
1069: 1

Line 1104: FROM DUAL

1100:
1101: SELECT
1102: 'Y'
1103: INTO l_temp
1104: FROM DUAL
1105: WHERE EXISTS
1106: (
1107: SELECT
1108: 1

Line 1140: FROM DUAL

1136:
1137: SELECT
1138: 'Y'
1139: INTO l_temp
1140: FROM DUAL
1141: WHERE EXISTS
1142: (
1143: SELECT
1144: 1

Line 1200: FROM DUAL

1196:
1197: SELECT
1198: 'Y'
1199: INTO l_temp
1200: FROM DUAL
1201: WHERE EXISTS
1202: (
1203: SELECT
1204: 1

Line 1255: FROM DUAL

1251: l_temp VARCHAR2(1);
1252: BEGIN
1253:
1254: SELECT 'Y' into l_temp
1255: FROM DUAL
1256: WHERE EXISTS(
1257: SELECT 1 FROM EGO_UCCNET_EVENTS
1258: WHERE inventory_item_id = p_inventory_item_id
1259: AND organization_id = p_org_id

Line 1661: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_ext_seq_val FROM DUAL;

1657: END IF;
1658: write_debug_log('Value is not null l_extn_id= '||l_extn_id);
1659: EXCEPTION WHEN NO_DATA_FOUND THEN
1660: write_debug_log('No Data Found - inserting');
1661: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_ext_seq_val FROM DUAL;
1662:
1663: INSERT INTO EGO_ITEM_TP_ATTRS_EXT_B
1664: (
1665: EXTENSION_ID,

Line 3301: FROM DUAL

3297: ,l_current_user_id
3298: ,l_sysdate
3299: ,l_current_user_id
3300: ,L_current_login_id
3301: FROM DUAL
3302: WHERE NOT EXISTS (
3303: SELECT *
3304: FROM EGO_PAGES_V
3305: WHERE CLASSIFICATION_CODE = l_classification_code

Line 3527: FROM DUAL

3523: IS
3524: l_result VARCHAR2(1);
3525: BEGIN
3526: SELECT 'Y' INTO l_result
3527: FROM DUAL
3528: WHERE NOT EXISTS
3529: (
3530: SELECT
3531: 1