DBA Data[Home] [Help]

APPS.EGO_TA_BULKLOAD_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 120: SET transaction_id = mtl_system_items_interface_s.nextval,

116:
117:
118: /*Sets the Transaction_id and upper case the transaction_type*/
119: UPDATE EGO_TRANS_ATTRS_VERS_INTF
120: SET transaction_id = mtl_system_items_interface_s.nextval,
121: transaction_type = Upper(transaction_type),
122: created_by = Nvl(created_by,g_user_id),
123: creation_date = Nvl(creation_date,SYSDATE),
124: last_updated_by = G_USER_ID,

Line 177: mtl_system_items_interface_s.nextval,

173: program_application_id,
174: program_id,
175: program_update_date)
176: SELECT transaction_id,
177: mtl_system_items_interface_s.nextval,
178: NULL,
179: NULL,
180: 'EGO_TRANS_ATTRS_VERS_INTF',
181: G_MESSAGE_NAME,

Line 242: mtl_system_items_interface_s.nextval,

238: program_application_id,
239: program_id,
240: program_update_date)
241: SELECT transaction_id,
242: mtl_system_items_interface_s.nextval,
243: NULL,
244: NULL,
245: 'EGO_TRANS_ATTRS_VERS_INTF',
246: G_MESSAGE_NAME,

Line 301: mtl_system_items_interface_s.nextval,

297: program_application_id,
298: program_id,
299: program_update_date)
300: SELECT transaction_id,
301: mtl_system_items_interface_s.nextval,
302: NULL,
303: NULL,
304: 'EGO_TRANS_ATTRS_VERS_INTF',
305: G_MESSAGE_NAME,

Line 365: mtl_system_items_interface_s.nextval,

361: program_application_id,
362: program_id,
363: program_update_date)
364: SELECT transaction_id,
365: mtl_system_items_interface_s.nextval,
366: NULL,
367: NULL,
368: 'EGO_TRANS_ATTRS_VERS_INTF',
369: G_MESSAGE_NAME,

Line 426: mtl_system_items_interface_s.nextval,

422: program_application_id,
423: program_id,
424: program_update_date)
425: SELECT transaction_id,
426: mtl_system_items_interface_s.nextval,
427: NULL,
428: NULL,
429: 'EGO_TRANS_ATTRS_VERS_INTF',
430: G_MESSAGE_NAME,

Line 489: mtl_system_items_interface_s.nextval,

485: program_application_id,
486: program_id,
487: program_update_date)
488: SELECT transaction_id,
489: mtl_system_items_interface_s.nextval,
490: NULL,
491: NULL,
492: 'EGO_TRANS_ATTRS_VERS_INTF',
493: G_MESSAGE_NAME,

Line 557: mtl_system_items_interface_s.nextval,

553: program_application_id,
554: program_id,
555: program_update_date)
556: SELECT transaction_id,
557: mtl_system_items_interface_s.nextval,
558: NULL,
559: NULL,
560: 'EGO_TRANS_ATTRS_VERS_INTF',
561: G_MESSAGE_NAME,

Line 622: mtl_system_items_interface_s.nextval,

618: program_application_id,
619: program_id,
620: program_update_date)
621: SELECT transaction_id,
622: mtl_system_items_interface_s.nextval,
623: NULL,
624: NULL,
625: 'EGO_TRANS_ATTRS_VERS_INTF',
626: G_MESSAGE_NAME,

Line 693: mtl_system_items_interface_s.nextval,

689: program_application_id,
690: program_id,
691: program_update_date)
692: SELECT transaction_id,
693: mtl_system_items_interface_s.nextval,
694: NULL,
695: NULL,
696: 'EGO_TRANS_ATTRS_VERS_INTF',
697: G_MESSAGE_NAME,

Line 772: mtl_system_items_interface_s.nextval,

768: program_application_id,
769: program_id,
770: program_update_date)
771: SELECT transaction_id,
772: mtl_system_items_interface_s.nextval,
773: NULL,
774: NULL,
775: 'EGO_TRANS_ATTRS_VERS_INTF',
776: G_MESSAGE_NAME,

Line 919: mtl_system_items_interface_s.nextval,

915: program_application_id,
916: program_id,
917: program_update_date)
918: SELECT transaction_id,
919: mtl_system_items_interface_s.nextval,
920: NULL,
921: NULL,
922: 'EGO_TRANS_ATTRS_VERS_INTF',
923: G_MESSAGE_NAME,

Line 1019: mtl_system_items_interface_s.nextval,

1015: program_application_id,
1016: program_id,
1017: program_update_date)
1018: SELECT transaction_id,
1019: mtl_system_items_interface_s.nextval,
1020: NULL,
1021: NULL,
1022: 'EGO_TRANS_ATTRS_VERS_INTF',
1023: G_MESSAGE_NAME,

Line 1086: mtl_system_items_interface_s.nextval,

1082: program_application_id,
1083: program_id,
1084: program_update_date)
1085: SELECT transaction_id,
1086: mtl_system_items_interface_s.nextval,
1087: NULL,
1088: NULL,
1089: 'EGO_TRANS_ATTRS_VERS_INTF',
1090: G_MESSAGE_NAME,

Line 1166: mtl_system_items_interface_s.nextval,

1162: program_application_id,
1163: program_id,
1164: program_update_date)
1165: SELECT transaction_id,
1166: mtl_system_items_interface_s.nextval,
1167: NULL,
1168: NULL,
1169: 'EGO_TRANS_ATTRS_VERS_INTF',
1170: G_MESSAGE_NAME,

Line 1239: mtl_system_items_interface_s.nextval,

1235: program_application_id,
1236: program_id,
1237: program_update_date)
1238: SELECT transaction_id,
1239: mtl_system_items_interface_s.nextval,
1240: NULL,
1241: NULL,
1242: 'EGO_TRANS_ATTRS_VERS_INTF',
1243: G_MESSAGE_NAME,

Line 1305: mtl_system_items_interface_s.nextval,

1301: program_application_id,
1302: program_id,
1303: program_update_date)
1304: SELECT transaction_id,
1305: mtl_system_items_interface_s.nextval,
1306: NULL,
1307: NULL,
1308: 'EGO_TRANS_ATTRS_VERS_INTF',
1309: G_MESSAGE_NAME,

Line 1368: mtl_system_items_interface_s.nextval,

1364: program_application_id,
1365: program_id,
1366: program_update_date)
1367: SELECT transaction_id,
1368: mtl_system_items_interface_s.nextval,
1369: NULL,
1370: NULL,
1371: 'EGO_TRANS_ATTRS_VERS_INTF',
1372: G_MESSAGE_NAME,

Line 1431: mtl_system_items_interface_s.nextval,

1427: program_application_id,
1428: program_id,
1429: program_update_date)
1430: SELECT transaction_id,
1431: mtl_system_items_interface_s.nextval,
1432: NULL,
1433: NULL,
1434: 'EGO_TRANS_ATTRS_VERS_INTF',
1435: G_MESSAGE_NAME,

Line 1534: mtl_system_items_interface_s.nextval,

1530: program_application_id,
1531: program_id,
1532: program_update_date)
1533: SELECT transaction_id,
1534: mtl_system_items_interface_s.nextval,
1535: NULL,
1536: NULL,
1537: 'EGO_TRANS_ATTRS_VERS_INTF',
1538: G_MESSAGE_NAME,

Line 1597: mtl_system_items_interface_s.nextval,

1593: program_application_id,
1594: program_id,
1595: program_update_date)
1596: SELECT transaction_id,
1597: mtl_system_items_interface_s.nextval,
1598: NULL,
1599: NULL,
1600: 'EGO_TRANS_ATTRS_VERS_INTF',
1601: G_MESSAGE_NAME,

Line 2005: SELECT mtl_system_items_interface_s.NEXTVAL,Upper(p_ta_intf_tbl(i).transaction_type)

2001: FROM fnd_application
2002: WHERE application_short_name=G_APP_NAME;
2003:
2004: /*Sets the transaction_id*/
2005: SELECT mtl_system_items_interface_s.NEXTVAL,Upper(p_ta_intf_tbl(i).transaction_type)
2006: INTO p_ta_intf_tbl(i).transaction_id,p_ta_intf_tbl(i).transaction_type
2007: FROM dual;
2008:
2009: /* if not a valid transaction type*/