eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_TA_BULKLOAD_PVT dependencies on EGO_TRANS_ATTRS_VERS_INTF

Line 42: FROM EGO_TRANS_ATTRS_VERS_INTF

38: --*/
39: BEGIN
40: -- if any of the TA errored out during bulk,throw error
41: SELECT 1 INTO l_err_rec
42: FROM EGO_TRANS_ATTRS_VERS_INTF
43: WHERE item_catalog_group_id= p_item_catalog_group_id
44: AND icc_version_number = p_icc_version_number_intf
45: AND process_status=G_ERROR_RECORD --3
46: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id))

Line 59: FROM EGO_TRANS_ATTRS_VERS_INTF

55: RETURN ;
56: ELSE
57: -- checking if records are there to process or not
58: SELECT Count(1) INTO l_rec_exists
59: FROM EGO_TRANS_ATTRS_VERS_INTF
60: WHERE item_catalog_group_id= p_item_catalog_group_id
61: AND icc_version_number= p_icc_version_number_intf
62: AND process_status=G_PROCESS_RECORD
63: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id))

Line 119: UPDATE EGO_TRANS_ATTRS_VERS_INTF

115: WHERE application_short_name = G_APP_NAME;
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),

Line 180: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
182: G_MESSAGE_TEXT,
183: G_BO_IDENTIFIER,
184: G_ENTITY_IDENTIFIER,

Line 194: FROM EGO_TRANS_ATTRS_VERS_INTF

190: G_REQUEST_ID,
191: NVL(program_application_id,G_PROG_APPL_ID),
192: NVL(program_id,G_PROGRAM_ID),
193: NVL(program_update_date,SYSDATE)
194: FROM EGO_TRANS_ATTRS_VERS_INTF
195: WHERE ((transaction_type is NULL) or (transaction_type NOT IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC)))
196: AND transaction_id IS NOT NULL
197: AND process_status = G_PROCESS_RECORD
198: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));

Line 201: UPDATE EGO_TRANS_ATTRS_VERS_INTF

197: AND process_status = G_PROCESS_RECORD
198: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
199:
200: /* Invalid Transaction type */
201: UPDATE EGO_TRANS_ATTRS_VERS_INTF
202: SET process_status =G_ERROR_RECORD,
203: last_updated_by = G_USER_ID,
204: last_update_date = SYSDATE,
205: last_update_login = G_LOGIN_ID

Line 245: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
247: G_MESSAGE_TEXT,
248: G_BO_IDENTIFIER,
249: G_ENTITY_IDENTIFIER,

Line 259: FROM EGO_TRANS_ATTRS_VERS_INTF

255: G_REQUEST_ID,
256: NVL(program_application_id,G_PROG_APPL_ID),
257: NVL(program_id,G_PROGRAM_ID),
258: NVL(program_update_date,SYSDATE)
259: FROM EGO_TRANS_ATTRS_VERS_INTF
260: WHERE transaction_type IN (G_UPDATE,G_DELETE,G_SYNC)
261: AND transaction_id IS NOT NULL
262: AND process_status = G_PROCESS_RECORD
263: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));

Line 266: UPDATE EGO_TRANS_ATTRS_VERS_INTF

262: AND process_status = G_PROCESS_RECORD
263: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
264:
265: /* not supporting now */
266: UPDATE EGO_TRANS_ATTRS_VERS_INTF
267: SET process_status =G_ERROR_RECORD,
268: last_updated_by = G_USER_ID,
269: last_update_date = SYSDATE,
270: last_update_login = G_LOGIN_ID

Line 304: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
306: G_MESSAGE_TEXT,
307: G_BO_IDENTIFIER,
308: G_ENTITY_IDENTIFIER,

Line 318: FROM EGO_TRANS_ATTRS_VERS_INTF

314: G_REQUEST_ID,
315: NVL(program_application_id,G_PROG_APPL_ID),
316: NVL(program_id,G_PROGRAM_ID),
317: NVL(program_update_date,SYSDATE)
318: FROM EGO_TRANS_ATTRS_VERS_INTF
319: WHERE transaction_type IN (G_CREATE)
320: AND transaction_id IS NOT NULL
321: AND icc_version_number=0
322: AND process_status = G_PROCESS_RECORD

Line 326: UPDATE EGO_TRANS_ATTRS_VERS_INTF

322: AND process_status = G_PROCESS_RECORD
323: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
324:
325: /* not supporting now */
326: UPDATE EGO_TRANS_ATTRS_VERS_INTF
327: SET process_status =G_ERROR_RECORD,
328: last_updated_by = G_USER_ID,
329: last_update_date = SYSDATE,
330: last_update_login = G_LOGIN_ID

Line 368: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
370: G_MESSAGE_TEXT,
371: G_BO_IDENTIFIER,
372: G_ENTITY_IDENTIFIER,

Line 382: FROM EGO_TRANS_ATTRS_VERS_INTF

378: G_REQUEST_ID,
379: NVL(program_application_id,G_PROG_APPL_ID),
380: NVL(program_id,G_PROGRAM_ID),
381: NVL(program_update_date,SYSDATE)
382: FROM EGO_TRANS_ATTRS_VERS_INTF
383: WHERE item_catalog_group_id IS NULL
384: AND item_catalog_group_name IS NOT NULL
385: AND transaction_id IS NOT NULL
386: AND process_status = G_PROCESS_RECORD

Line 389: UPDATE EGO_TRANS_ATTRS_VERS_INTF

385: AND transaction_id IS NOT NULL
386: AND process_status = G_PROCESS_RECORD
387: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
388:
389: UPDATE EGO_TRANS_ATTRS_VERS_INTF
390: SET process_status = G_ERROR_RECORD,
391: last_updated_by = G_USER_ID,
392: last_update_date = SYSDATE,
393: last_update_login = G_LOGIN_ID

Line 429: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
431: G_MESSAGE_TEXT,
432: G_BO_IDENTIFIER,
433: G_ENTITY_IDENTIFIER,

Line 443: FROM EGO_TRANS_ATTRS_VERS_INTF

439: G_REQUEST_ID,
440: NVL(program_application_id,G_PROG_APPL_ID),
441: NVL(program_id,G_PROGRAM_ID),
442: NVL(program_update_date,SYSDATE)
443: FROM EGO_TRANS_ATTRS_VERS_INTF
444: WHERE item_catalog_group_id IS NULL
445: AND item_catalog_group_name IS NULL
446: AND transaction_id IS NOT NULL
447: AND process_status = G_PROCESS_RECORD

Line 451: UPDATE EGO_TRANS_ATTRS_VERS_INTF

447: AND process_status = G_PROCESS_RECORD
448: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
449:
450: /* if both icc_id and icc_name are null*/
451: UPDATE EGO_TRANS_ATTRS_VERS_INTF
452: SET process_status = G_ERROR_RECORD,
453: last_updated_by = G_USER_ID,
454: last_update_date = SYSDATE,
455: last_update_login = G_LOGIN_ID

Line 492: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
494: G_MESSAGE_TEXT,
495: G_BO_IDENTIFIER,
496: G_ENTITY_IDENTIFIER,

Line 506: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVI

502: G_REQUEST_ID,
503: NVL(program_application_id,G_PROG_APPL_ID),
504: NVL(program_id,G_PROGRAM_ID),
505: NVL(program_update_date,SYSDATE)
506: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVI
507: WHERE ETAVI.item_catalog_group_id IS NOT NULL
508: AND NOT EXISTS (
509: SELECT 1
510: FROM mtl_item_catalog_groups micg

Line 517: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVI

513: AND ETAVI.process_status = G_PROCESS_RECORD
514: AND ((p_set_process_id IS NULL) OR (ETAVI.set_process_id=p_set_process_id));
515:
516: /* If passed icc_id dosent exists*/
517: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVI
518: SET ETAVI.process_status = G_ERROR_RECORD,
519: ETAVI.last_updated_by = G_USER_ID,
520: ETAVI.last_update_date = SYSDATE,
521: ETAVI.last_update_login = G_LOGIN_ID

Line 560: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
562: G_MESSAGE_TEXT,
563: G_BO_IDENTIFIER,
564: G_ENTITY_IDENTIFIER,

Line 574: FROM EGO_TRANS_ATTRS_VERS_INTF

570: G_REQUEST_ID,
571: NVL(program_application_id,G_PROG_APPL_ID),
572: NVL(program_id,G_PROGRAM_ID),
573: NVL(program_update_date,SYSDATE)
574: FROM EGO_TRANS_ATTRS_VERS_INTF
575: WHERE value_set_id IS NULL
576: AND Value_set_name IS NOT NULL
577: AND transaction_type IN (G_CREATE,G_UPDATE,G_SYNC)
578: AND transaction_id IS NOT NULL

Line 584: UPDATE EGO_TRANS_ATTRS_VERS_INTF

580: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
581:
582:
583: /*if value set name provided doesnt exists in table */
584: UPDATE EGO_TRANS_ATTRS_VERS_INTF
585: SET process_status = G_ERROR_RECORD,
586: last_updated_by = G_USER_ID,
587: last_update_date = SYSDATE,
588: last_update_login = G_LOGIN_ID

Line 625: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
627: G_MESSAGE_TEXT,
628: G_BO_IDENTIFIER,
629: G_ENTITY_IDENTIFIER,

Line 639: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVT

635: G_REQUEST_ID,
636: NVL(program_application_id,G_PROG_APPL_ID),
637: NVL(program_id,G_PROGRAM_ID),
638: NVL(program_update_date,SYSDATE)
639: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVT
640: WHERE value_set_id IS NOT NULL
641: AND NOT EXISTS (
642: SELECT 1
643: FROM fnd_flex_value_sets ffvs

Line 651: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

647: AND ETAVT.process_status = G_PROCESS_RECORD
648: AND ((p_set_process_id IS NULL) OR (ETAVT.set_process_id=p_set_process_id));
649:
650: /*given value set id is valid or not*/
651: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
652: SET ETAVT.process_status =G_ERROR_RECORD,
653: ETAVT.last_updated_by = G_USER_ID,
654: ETAVT.last_update_date = SYSDATE,
655: ETAVT.last_update_login = G_LOGIN_ID

Line 696: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
698: G_MESSAGE_TEXT,
699: G_BO_IDENTIFIER,
700: G_ENTITY_IDENTIFIER,

Line 710: FROM EGO_TRANS_ATTRS_VERS_INTF

706: G_REQUEST_ID,
707: NVL(program_application_id,G_PROG_APPL_ID),
708: NVL(program_id,G_PROGRAM_ID),
709: NVL(program_update_date,SYSDATE)
710: FROM EGO_TRANS_ATTRS_VERS_INTF
711: WHERE attr_id IS NULL
712: AND attr_name IS NOT NULL
713: AND transaction_type IN (G_UPDATE,G_DELETE)
714: AND transaction_id IS NOT NULL

Line 719: UPDATE EGO_TRANS_ATTRS_VERS_INTF

715: AND process_status = G_PROCESS_RECORD
716: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
717:
718: /*if attr name provided doesnt exists in table */
719: UPDATE EGO_TRANS_ATTRS_VERS_INTF
720: SET process_status = G_ERROR_RECORD,
721: last_updated_by = G_USER_ID,
722: last_update_date = SYSDATE,
723: last_update_login = G_LOGIN_ID

Line 734: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

730:
731: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'if attr_name is given with sync and not exists- convert to Create');
732: /* converting sync to create or update */
733: /* if attr_name is given with sync and not exists */
734: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
735: SET transaction_type = G_CREATE,
736: last_updated_by = G_USER_ID,
737: last_update_date = SYSDATE,
738: last_update_login = G_LOGIN_ID

Line 775: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
777: G_MESSAGE_TEXT,
778: G_BO_IDENTIFIER,
779: G_ENTITY_IDENTIFIER,

Line 789: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVT

785: G_REQUEST_ID,
786: NVL(program_application_id,G_PROG_APPL_ID),
787: NVL(program_id,G_PROGRAM_ID),
788: NVL(program_update_date,SYSDATE)
789: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVT
790: WHERE attr_id IS NOT NULL
791: AND NOT EXISTS (
792: SELECT 1
793: FROM EGO_TRANS_ATTR_VERS_B ETAVB

Line 803: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

799: AND ETAVT.process_status = G_PROCESS_RECORD
800: AND ((p_set_process_id IS NULL) OR (ETAVT.set_process_id=p_set_process_id));
801:
802: /*given attr id is valid or not*/
803: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
804: SET ETAVT.process_status = G_ERROR_RECORD,
805: ETAVT.last_updated_by = G_USER_ID,
806: ETAVT.last_update_date = SYSDATE,
807: ETAVT.last_update_login = G_LOGIN_ID

Line 822: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

818: AND ((p_set_process_id IS NULL) OR (ETAVT.set_process_id=p_set_process_id));
819:
820: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if attr_name given with sync - convert to Update');
821: /* if attr_name is given with sync and exists */
822: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
823: SET transaction_type = G_UPDATE,
824: last_updated_by = G_USER_ID,
825: last_update_date = SYSDATE,
826: last_update_login = G_LOGIN_ID

Line 844: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

840: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting attr_name if only display_name is given');
841: /* if attr_display name and sync given and it got converted into
842: update as here we are sure we got the attr_id so populating attr_name
843: if not given*/
844: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
845: SET attr_name= (SELECT attr_name
846: FROM ego_attrs_v EAV
847: WHERE EAV.attr_id= ETAVT.attr_id
848: )

Line 857: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

853: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
854:
855: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting other metadata from main table if not provided by user to complete the record');
856: /* to copy rest of the meta data for same attr_id,icc_id and version */
857: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
858: SET (uom_class,
859: default_value,
860: rejected_value,
861: required_flag,

Line 880: FROM EGO_TRANS_ATTRS_VERS_INTF a,EGO_TRANS_ATTR_VERS_B b

876: nvl(a.check_eligibility,b.check_eligibility),
877: nvl(a.value_set_id,b.value_set_id),
878: nvl(a.attr_display_name,b.attr_display_name),
879: b.sequence
880: FROM EGO_TRANS_ATTRS_VERS_INTF a,EGO_TRANS_ATTR_VERS_B b
881: WHERE a.attr_id=b.attr_id
882: AND a.item_catalog_group_id=b.item_catalog_group_id
883: AND b.icc_version_number=0
884: AND a.attr_id=ETAVT.attr_id)

Line 922: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
924: G_MESSAGE_TEXT,
925: G_BO_IDENTIFIER,
926: G_ENTITY_IDENTIFIER,

Line 936: FROM EGO_TRANS_ATTRS_VERS_INTF

932: G_REQUEST_ID,
933: NVL(program_application_id,G_PROG_APPL_ID),
934: NVL(program_id,G_PROGRAM_ID),
935: NVL(program_update_date,SYSDATE)
936: FROM EGO_TRANS_ATTRS_VERS_INTF
937: WHERE attr_id IS NULL
938: AND attr_display_name IS NOT NULL
939: AND transaction_type IN (G_UPDATE,G_DELETE)
940: AND transaction_id IS NOT NULL

Line 946: UPDATE EGO_TRANS_ATTRS_VERS_INTF

942: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
943:
944:
945: /*if attr disp name provided doesnt exists in table */
946: UPDATE EGO_TRANS_ATTRS_VERS_INTF
947: SET process_status = G_ERROR_RECORD,
948: last_updated_by = G_USER_ID,
949: last_update_date = SYSDATE,
950: last_update_login = G_LOGIN_ID

Line 961: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

957:
958: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'If attr_display_name is given with sync and not exists- convert to Create .');
959: /* converting sync to create or update */
960: /* if attr_display_name is given with sync and not exists */
961: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
962: SET transaction_type = G_CREATE,
963: last_updated_by = G_USER_ID,
964: last_update_date = SYSDATE,
965: last_update_login = G_LOGIN_ID

Line 977: UPDATE EGO_TRANS_ATTRS_VERS_INTF

973: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if All Attr_name, Attr_Display_Name,Attr_id are NULL For Upd,Del,Sync');
974: /* if attr_name is null,attr_display_name is null and attr_id is null
975: with sync then error out */
976:
977: UPDATE EGO_TRANS_ATTRS_VERS_INTF
978: SET process_status =G_ERROR_RECORD,
979: last_updated_by = G_USER_ID,
980: last_update_date = SYSDATE,
981: last_update_login = G_LOGIN_ID

Line 1022: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
1024: G_MESSAGE_TEXT,
1025: G_BO_IDENTIFIER,
1026: G_ENTITY_IDENTIFIER,

Line 1036: FROM EGO_TRANS_ATTRS_VERS_INTF

1032: G_REQUEST_ID,
1033: NVL(program_application_id,G_PROG_APPL_ID),
1034: NVL(program_id,G_PROGRAM_ID),
1035: NVL(program_update_date,SYSDATE)
1036: FROM EGO_TRANS_ATTRS_VERS_INTF
1037: WHERE attr_id IS NOT NULL
1038: AND item_catalog_group_id IS NOT NULL
1039: AND association_id IS NULL
1040: AND transaction_type IN (G_UPDATE,G_DELETE,G_SYNC)

Line 1048: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1044:
1045:
1046: /*if not able to convert association id from given attr_id and icc_id
1047: in case of upd,del,sync */
1048: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1049: SET process_status =G_ERROR_RECORD,
1050: last_updated_by = G_USER_ID,
1051: last_update_date = SYSDATE,
1052: last_update_login = G_LOGIN_ID

Line 1089: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
1091: G_MESSAGE_TEXT,
1092: G_BO_IDENTIFIER,
1093: G_ENTITY_IDENTIFIER,

Line 1103: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVT

1099: G_REQUEST_ID,
1100: NVL(program_application_id,G_PROG_APPL_ID),
1101: NVL(program_id,G_PROGRAM_ID),
1102: NVL(program_update_date,SYSDATE)
1103: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVT
1104: WHERE attr_id IS NOT NULL
1105: AND item_catalog_group_id IS NOT NULL
1106: AND association_id IS NOT NULL
1107: AND NOT EXISTS (

Line 1119: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

1115: AND ETAVT.process_status = G_PROCESS_RECORD
1116: AND ((p_set_process_id IS NULL) OR (ETAVT.set_process_id=p_set_process_id));
1117:
1118: /*if association provided and it is not valid*/
1119: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1120: SET process_status =G_ERROR_RECORD,
1121: last_updated_by = G_USER_ID,
1122: last_update_date = SYSDATE,
1123: last_update_login = G_LOGIN_ID

Line 1169: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
1171: G_MESSAGE_TEXT,
1172: G_BO_IDENTIFIER,
1173: G_ENTITY_IDENTIFIER,

Line 1183: FROM EGO_TRANS_ATTRS_VERS_INTF

1179: G_REQUEST_ID,
1180: NVL(program_application_id,G_PROG_APPL_ID),
1181: NVL(program_id,G_PROGRAM_ID),
1182: NVL(program_update_date,SYSDATE)
1183: FROM EGO_TRANS_ATTRS_VERS_INTF
1184: WHERE transaction_type IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC)
1185: AND transaction_id IS NOT NULL
1186: AND ((required_flag IS NOT NULL) OR (readonly_flag IS NOT NULL)
1187: OR (hidden_flag IS NOT NULL) OR (searchable_flag IS NOT NULL)

Line 1195: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

1191: AND process_status = G_PROCESS_RECORD
1192: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
1193:
1194: /*IF any of the flag has value other than 'Y' or 'N'*/
1195: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1196: SET process_status = G_ERROR_RECORD,
1197: last_updated_by = G_USER_ID,
1198: last_update_date = SYSDATE,
1199: last_update_login = G_LOGIN_ID

Line 1242: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
1244: G_MESSAGE_TEXT,
1245: G_BO_IDENTIFIER,
1246: G_ENTITY_IDENTIFIER,

Line 1256: FROM EGO_TRANS_ATTRS_VERS_INTF

1252: G_REQUEST_ID,
1253: NVL(program_application_id,G_PROG_APPL_ID),
1254: NVL(program_id,G_PROGRAM_ID),
1255: NVL(program_update_date,SYSDATE)
1256: FROM EGO_TRANS_ATTRS_VERS_INTF
1257: WHERE transaction_type IN (G_CREATE)
1258: AND transaction_id IS NOT NULL
1259: AND data_type IS NOT NULL
1260: AND Upper(data_type) NOT IN ('C','A','N','X','Y')

Line 1265: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

1261: AND process_status = G_PROCESS_RECORD
1262: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
1263:
1264: /*if association provided and it is not valid*/
1265: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1266: SET process_status = G_ERROR_RECORD,
1267: last_updated_by = G_USER_ID,
1268: last_update_date = SYSDATE,
1269: last_update_login = G_LOGIN_ID

Line 1308: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
1310: G_MESSAGE_TEXT,
1311: G_BO_IDENTIFIER,
1312: G_ENTITY_IDENTIFIER,

Line 1322: FROM EGO_TRANS_ATTRS_VERS_INTF

1318: G_REQUEST_ID,
1319: NVL(program_application_id,G_PROG_APPL_ID),
1320: NVL(program_id,G_PROGRAM_ID),
1321: NVL(program_update_date,SYSDATE)
1322: FROM EGO_TRANS_ATTRS_VERS_INTF
1323: WHERE transaction_type IN (G_CREATE)
1324: AND transaction_id IS NOT NULL
1325: AND process_status = G_PROCESS_RECORD
1326: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))

Line 1330: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1326: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))
1327: AND ((Association_id IS NOT NULL) OR (Attr_id IS NOT NULL));
1328:
1329: /* Association_id and Attr_id should be NULL if CREATING TA */
1330: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1331: SET process_status = G_ERROR_RECORD,
1332: last_updated_by = G_USER_ID,
1333: last_update_date = SYSDATE,
1334: last_update_login = G_LOGIN_ID

Line 1371: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
1373: G_MESSAGE_TEXT,
1374: G_BO_IDENTIFIER,
1375: G_ENTITY_IDENTIFIER,

Line 1385: FROM EGO_TRANS_ATTRS_VERS_INTF

1381: G_REQUEST_ID,
1382: NVL(program_application_id,G_PROG_APPL_ID),
1383: NVL(program_id,G_PROGRAM_ID),
1384: NVL(program_update_date,SYSDATE)
1385: FROM EGO_TRANS_ATTRS_VERS_INTF
1386: WHERE transaction_type IN (G_CREATE)
1387: AND transaction_id IS NOT NULL
1388: AND process_status = G_PROCESS_RECORD
1389: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))

Line 1393: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1389: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))
1390: AND ((attr_name IS NULL) OR (attr_display_name IS NULL) OR (SEQUENCE IS NULL)) ;
1391:
1392: /* ATTR_NAME,ATTR_DISPLAY_NAME,SEQUENCE Should not be null if CREATE*/
1393: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1394: SET process_status = G_ERROR_RECORD,
1395: last_updated_by = G_USER_ID,
1396: last_update_date = SYSDATE,
1397: last_update_login = G_LOGIN_ID

Line 1434: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
1436: G_MESSAGE_TEXT,
1437: G_BO_IDENTIFIER,
1438: G_ENTITY_IDENTIFIER,

Line 1448: FROM EGO_TRANS_ATTRS_VERS_INTF

1444: G_REQUEST_ID,
1445: NVL(program_application_id,G_PROG_APPL_ID),
1446: NVL(program_id,G_PROGRAM_ID),
1447: NVL(program_update_date,SYSDATE)
1448: FROM EGO_TRANS_ATTRS_VERS_INTF
1449: WHERE transaction_type IN (G_CREATE)
1450: AND transaction_id IS NOT NULL
1451: AND process_status = G_PROCESS_RECORD
1452: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))

Line 1457: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1453: AND icc_version_number IS NULL;
1454: --AND item_catalog_group_id IS NOT NULL;/* bug 9752139 */
1455:
1456: /* ICC_VERSION NUMBER should not be NULL in CREATE flow */
1457: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1458: SET process_status = G_ERROR_RECORD,
1459: last_updated_by = G_USER_ID,
1460: last_update_date = SYSDATE,
1461: last_update_login = G_LOGIN_ID

Line 1473: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1469: -------------------------------------------------
1470: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Defaulting Data Type and Display Flag while CREATE');
1471:
1472: /*Defaulting data_type to'C' if not passed*/
1473: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1474: SET data_type = G_CHAR_DATA_TYPE
1475: WHERE transaction_type=G_CREATE
1476: AND transaction_id IS NOT NULL
1477: AND process_status = G_PROCESS_RECORD

Line 1482: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1478: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id))
1479: AND data_type IS NULL;
1480:
1481: /*Sets the display_flag as 'T'*/
1482: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1483: SET display_flag = 'T'
1484: WHERE transaction_type=G_CREATE
1485: AND transaction_id IS NOT NULL
1486: AND process_status = G_PROCESS_RECORD

Line 1490: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1486: AND process_status = G_PROCESS_RECORD
1487: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
1488:
1489: /*Sets the Metadata_level as 'ICC'*/
1490: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1491: SET Metadata_level = 'ICC'
1492: WHERE transaction_type=G_CREATE
1493: AND transaction_id IS NOT NULL
1494: AND process_status = G_PROCESS_RECORD

Line 1498: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1494: AND process_status = G_PROCESS_RECORD
1495: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
1496:
1497: /*Assigning icc_version_no as 0 if not provided in update and delete*/
1498: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1499: SET icc_version_number = 0
1500: WHERE transaction_type IN (G_UPDATE,G_DELETE)
1501: AND transaction_id IS NOT NULL
1502: AND process_status = G_PROCESS_RECORD

Line 1537: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
1539: G_MESSAGE_TEXT,
1540: G_BO_IDENTIFIER,
1541: G_ENTITY_IDENTIFIER,

Line 1551: FROM EGO_TRANS_ATTRS_VERS_INTF

1547: G_REQUEST_ID,
1548: NVL(program_application_id,G_PROG_APPL_ID),
1549: NVL(program_id,G_PROGRAM_ID),
1550: NVL(program_update_date,SYSDATE)
1551: FROM EGO_TRANS_ATTRS_VERS_INTF
1552: WHERE transaction_type IN (G_UPDATE,G_DELETE)
1553: AND transaction_id IS NOT NULL
1554: AND process_status = G_PROCESS_RECORD
1555: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))

Line 1559: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1555: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))
1556: AND icc_version_number>0;
1557:
1558: /* Icc_Version_Number greater than zero not allowed while UPDATE and DELETE*/
1559: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1560: SET process_status = G_ERROR_RECORD,
1561: last_updated_by = G_USER_ID,
1562: last_update_date = SYSDATE,
1563: last_update_login = G_LOGIN_ID

Line 1600: 'EGO_TRANS_ATTRS_VERS_INTF',

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,
1602: G_MESSAGE_TEXT,
1603: G_BO_IDENTIFIER,
1604: G_ENTITY_IDENTIFIER,

Line 1614: FROM EGO_TRANS_ATTRS_VERS_INTF

1610: G_REQUEST_ID,
1611: NVL(program_application_id,G_PROG_APPL_ID),
1612: NVL(program_id,G_PROGRAM_ID),
1613: NVL(program_update_date,SYSDATE)
1614: FROM EGO_TRANS_ATTRS_VERS_INTF
1615: WHERE transaction_type IN (G_DELETE)
1616: AND transaction_id IS NOT NULL
1617: AND process_status = G_PROCESS_RECORD
1618: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))

Line 1622: UPDATE EGO_TRANS_ATTRS_VERS_INTF

1618: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))
1619: AND ((association_id IS NULL) OR (attr_id IS NULL));
1620:
1621: /*Association_id and attr_id should not be null for DELETE */
1622: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1623: SET process_status = G_ERROR_RECORD,
1624: last_updated_by = G_USER_ID,
1625: last_update_date = SYSDATE,
1626: last_update_login = G_LOGIN_ID

Line 1652: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

1648:
1649: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Bulk_Validate_Trans_Attrs_ICC');
1650: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Updating ICC name from ICC id');
1651: /* ICC name to ICC id conversion */
1652: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1653: SET item_catalog_group_id = p_item_catalog_group_id
1654: WHERE ETAVT.item_catalog_group_name IS NOT NULL
1655: AND ETAVT.item_catalog_group_id IS NULL
1656: AND ETAVT.process_status = G_PROCESS_RECORD

Line 1680: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

1676: --ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting ICC name to ICC id');
1677: /* ICC name to ICC id conversion */
1678: /* NOt Req now are we are doing this in Bulk_Validate_Trans_Attrs_ICC */
1679: /*
1680: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1681: SET item_catalog_group_id = (SELECt icc_kfv.item_catalog_group_id
1682: FROM mtl_item_catalog_groups_kfv icc_kfv
1683: where Upper(icc_kfv.concatenated_segments) = Upper(ETAVT.item_catalog_group_name)
1684: )

Line 1693: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

1689: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));*/
1690:
1691: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting Value set name to value set id');
1692: /*Value set name to value set id conversion*/
1693: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1694: SET value_set_id = ( SELECT flex_value_set_id
1695: FROM fnd_flex_value_sets
1696: WHERE Upper(flex_value_set_name) = Upper(ETAVT.value_set_name)
1697: )

Line 1706: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

1702: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
1703:
1704: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting Attr_Name to Attr_id');
1705: /* Attr_Name to Attr_id conversion */
1706: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1707: SET (attr_id/*,attr_display_name,sequence*/) = ( SELECT attr_id/*,attr_display_name,sequence*/
1708: FROM ego_trans_attr_vers_b
1709: WHERE attr_id IN ( SELECT efdcue.attr_id
1710: FROM fnd_descr_flex_column_usages fdfcu,

Line 1739: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

1735:
1736:
1737: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting attr display name to attr_id ');
1738: /*attr display name to attr_id conversion*/
1739: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1740: SET attr_id = ( SELECT attr_id
1741: FROM EGO_TRANS_ATTR_VERS_B
1742: WHERE Upper(attr_display_name) = Upper(ETAVT.attr_display_name)
1743: AND item_catalog_group_id=ETAVT.item_catalog_group_id

Line 1754: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

1750: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
1751:
1752: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting associaton_id from icc_id,attr_id ');
1753: /* associaton_id from icc_id */
1754: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1755: SET association_id = ( SELECT association_id
1756: FROM EGO_TRANS_ATTR_VERS_B
1757: WHERE attr_id= ETAVT.attr_id
1758: AND item_catalog_group_id=ETAVT.item_catalog_group_id

Line 1788: FROM ego_trans_attrs_vers_intf

1784: x_return_msg OUT NOCOPY VARCHAR2)
1785: IS
1786: CURSOR c_ta IS
1787: SELECT *
1788: FROM ego_trans_attrs_vers_intf
1789: WHERE ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id))
1790: AND transaction_id IS NOT NULL
1791: AND process_status=G_PROCESS_RECORD
1792: AND item_catalog_group_id=p_item_catalog_group_id /* for integration with version*/

Line 1880: l_ta_intf_rec ego_trans_attrs_vers_intf%ROWTYPE;

1876: p_icc_version_number_act IN NUMBER,
1877: x_return_status OUT NOCOPY VARCHAR2,
1878: x_return_msg OUT NOCOPY VARCHAR2)
1879: IS
1880: l_ta_intf_rec ego_trans_attrs_vers_intf%ROWTYPE;
1881: l_ta_intf_tbl TA_Intf_Tbl;
1882: l_return_status VARCHAR2(1);
1883: l_proc_name VARCHAR2(200):= 'Process_Trans_Attrs';
1884: BEGIN

Line 2672: p_ta_intf_rec IN OUT NOCOPY ego_trans_attrs_vers_intf%ROWTYPE,

2668: --=================Transact_Trans_Attrs ========
2669:
2670: PROCEDURE Transact_Trans_Attrs(
2671: p_api_version IN NUMBER,
2672: p_ta_intf_rec IN OUT NOCOPY ego_trans_attrs_vers_intf%ROWTYPE,
2673: x_return_status OUT NOCOPY VARCHAR2,
2674: x_return_msg OUT NOCOPY VARCHAR2)
2675: IS
2676: l_ego_ta_tbl EGO_TRAN_ATTR_TBL;

Line 2992: UPDATE EGO_TRANS_ATTRS_VERS_INTF

2988: END LOOP;
2989:
2990:
2991: FORALL I IN p_ta_intf_tbl.first..p_ta_intf_tbl.last -- LOOP
2992: UPDATE EGO_TRANS_ATTRS_VERS_INTF
2993: SET ROW= p_ta_intf_tbl(i) -- bug 9701271
2994: WHERE
2995: transaction_id = trans_id(i);
2996:

Line 3022: UPDATE EGO_TRANS_ATTRS_VERS_INTF

3018: BEGIN
3019: x_return_status:=G_RET_STS_SUCCESS;
3020: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Update_Intf_Err_Trans_Attrs');
3021:
3022: UPDATE EGO_TRANS_ATTRS_VERS_INTF
3023: SET process_status= G_ERROR_RECORD
3024: WHERE item_catalog_group_id = p_item_catalog_group_id
3025: AND icc_version_number = p_icc_version_number_intf
3026: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));

Line 3052: DELETE FROM EGO_TRANS_ATTRS_VERS_INTF

3048: BEGIN
3049: x_return_status:=G_RET_STS_SUCCESS;
3050: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Delete_Processed_Trans_Attrs');
3051:
3052: DELETE FROM EGO_TRANS_ATTRS_VERS_INTF
3053: WHERE process_status = G_SUCCESS_RECORD
3054: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
3055:
3056: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Delete_Processed_Trans_Attrs');