APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on DUAL

Line 148: FROM dual;

144: l_bundle_collection_id = -1)
145: THEN
146: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
147: INTO l_bundle_collection_id
148: FROM dual;
149: END IF;
150:
151:
152: x_new_bundle_col_id := l_bundle_collection_id;

Line 421: FROM DUAL

417:
418: CURSOR c_is_enabled_for_gdsn(l_batch_id NUMBER)
419: IS
420: SELECT 1
421: FROM DUAL
422: WHERE EXISTS (SELECT NULL
423: FROM EGO_IMPORT_OPTION_SETS
424: WHERE BATCH_ID = l_batch_id
425: AND ENABLED_FOR_DATA_POOL = 'Y'

Line 833: FROM dual;

829: l_id NUMBER;
830: BEGIN
831: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
832: INTO l_id
833: FROM dual;
834:
835: RETURN l_id;
836: END;
837:

Line 1045: FROM DUAL;

1041: IF l_is_trans = TRUE
1042: THEN
1043: SELECT XMLELEMENT("TL", l_xml_Attrs.attributes.extract('/Attribute/ValueText'))
1044: INTO l_xml_trans
1045: FROM DUAL;
1046:
1047: IF l_xml_trans IS NOT NULL
1048: THEN
1049: PROCESS_TL_ROWS(p_table_name => 'EGO_ITM_USR_ATTR_INTRFC',

Line 1305: dual_uom_control,

1301: serial_status_enabled,
1302: lot_status_enabled,
1303: service_item_flag,
1304: --type_code
1305: dual_uom_control,
1306: primary_uom_code,
1307: --storage_uom_code,
1308: --shipping_uom_code,
1309: --UOM_conversion_usage_code

Line 1405: Decode(l_xml_ItemEBO.items.extract('/Item/ItemBase/DualUOMTrackingIndicator/text()').getStringVal(), 'true', 1, 'false', 0, null),

1401: Decode(l_xml_ItemEBO.items.extract('/Item/ItemBase/SerialControlIndicator/text()').getStringVal(), 'true', 'Y', 'false', 'N', null),
1402: Decode(l_xml_ItemEBO.items.extract('/Item/ItemBase/LotControlIndicator/text()').getStringVal(), 'true', 'Y', 'false', 'N', null),
1403: Decode(l_xml_ItemEBO.items.extract('/Item/ItemBase/ServiceIndicator/text()').getStringVal(), 'true', 'Y', 'false', 'N', null),
1404: --l_xml_ItemEBO.items.extract('/Item/ItemBase/TypeCode/text()').getStringVal(),
1405: Decode(l_xml_ItemEBO.items.extract('/Item/ItemBase/DualUOMTrackingIndicator/text()').getStringVal(), 'true', 1, 'false', 0, null),
1406: -- UOM to be set during import
1407: null,--l_xml_ItemEBO.items.extract('/Item/ItemBase/BaseUOMCode/text()').getStringVal(),
1408: --l_xml_ItemEBO.items.extract('/Item/ItemBase/StorageUOMCode/text()').getStringVal(),
1409: --l_xml_ItemEBO.items.extract('/Item/ItemBase/ShippingUOMCode/text()').getStringVal(),

Line 1497: FROM DUAL;

1493: -- Step 5: Insert Data for translatable entries for MTL_SYSTEM_ITEMS_INTERFACE
1494:
1495: SELECT XMLELEMENT("TL", l_xml_ItemEBO.items.extract('/Item/ItemIdentification/Name'))
1496: INTO l_xml_trans
1497: FROM DUAL;
1498:
1499: IF l_xml_trans IS NOT NULL
1500: THEN
1501: PROCESS_TL_ROWS(p_table_name => 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1512: FROM DUAL;

1508: END IF;
1509:
1510: SELECT XMLELEMENT("TL", l_xml_ItemEBO.items.extract('/Item/ItemBase/Description'))
1511: INTO l_xml_trans
1512: FROM DUAL;
1513:
1514: IF l_xml_trans IS NOT NULL
1515: THEN
1516: PROCESS_TL_ROWS(p_table_name => 'MTL_SYSTEM_ITEMS_INTERFACE',