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,
330:
331: SELECT
332: 'Y'
333: INTO l_temp
334: FROM DUAL
335: WHERE
336: NOT EXISTS
337: (
338: SELECT
389:
390: SELECT
391: 'Y'
392: INTO l_temp
393: FROM DUAL
394: WHERE
395: EXISTS
396: (
397: SELECT
444:
445: SELECT
446: 'Y'
447: INTO l_temp
448: FROM DUAL
449: WHERE EXISTS
450: (
451: SELECT
452: 1
593:
594: SELECT
595: 'Y'
596: INTO l_temp
597: FROM DUAL
598: WHERE EXISTS
599: (
600: SELECT
601: 1
741:
742: SELECT
743: 'Y'
744: INTO l_temp
745: FROM DUAL
746: WHERE EXISTS
747: (
748: SELECT
749: 1
827:
828: SELECT
829: 'Y'
830: INTO l_temp
831: FROM DUAL
832: WHERE EXISTS
833: (
834: SELECT
835: 1
832: WHERE EXISTS
833: (
834: SELECT
835: 1
836: FROM DUAL
837: WHERE EXISTS
838: (
839: SELECT
840: 1
886:
887: SELECT
888: 'Y'
889: INTO l_temp
890: FROM DUAL
891: WHERE EXISTS
892: (
893: SELECT
894: 1
891: WHERE EXISTS
892: (
893: SELECT
894: 1
895: FROM DUAL
896: WHERE EXISTS
897: (
898: SELECT
899: 1
1061:
1062: SELECT
1063: 'Y'
1064: INTO l_temp
1065: FROM DUAL
1066: WHERE NOT EXISTS
1067: (
1068: SELECT
1069: 1
1100:
1101: SELECT
1102: 'Y'
1103: INTO l_temp
1104: FROM DUAL
1105: WHERE EXISTS
1106: (
1107: SELECT
1108: 1
1136:
1137: SELECT
1138: 'Y'
1139: INTO l_temp
1140: FROM DUAL
1141: WHERE EXISTS
1142: (
1143: SELECT
1144: 1
1196:
1197: SELECT
1198: 'Y'
1199: INTO l_temp
1200: FROM DUAL
1201: WHERE EXISTS
1202: (
1203: SELECT
1204: 1
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
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,
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
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