DBA Data[Home] [Help]

APPS.MSD_ITEM_RELATIONSHIPS_PKG dependencies on FND_GLOBAL

Line 56: FND_GLOBAL.USER_ID || ', ' ||

52: 'related_item_id, '||
53: 'related_item, '||
54: 'relationship_type_id, '||
55: 'sysdate, ' ||
56: FND_GLOBAL.USER_ID || ', ' ||
57: 'sysdate, ' ||
58: FND_GLOBAL.USER_ID || ', ' ||
59: FND_GLOBAL.USER_ID || ' ,' ||
60: 'start_date, '|| /*--Bug#4707819--*/

Line 58: FND_GLOBAL.USER_ID || ', ' ||

54: 'relationship_type_id, '||
55: 'sysdate, ' ||
56: FND_GLOBAL.USER_ID || ', ' ||
57: 'sysdate, ' ||
58: FND_GLOBAL.USER_ID || ', ' ||
59: FND_GLOBAL.USER_ID || ' ,' ||
60: 'start_date, '|| /*--Bug#4707819--*/
61: 'end_date '|| /*--Bug#4707819--*/
62: 'FROM ' ||

Line 59: FND_GLOBAL.USER_ID || ' ,' ||

55: 'sysdate, ' ||
56: FND_GLOBAL.USER_ID || ', ' ||
57: 'sysdate, ' ||
58: FND_GLOBAL.USER_ID || ', ' ||
59: FND_GLOBAL.USER_ID || ' ,' ||
60: 'start_date, '|| /*--Bug#4707819--*/
61: 'end_date '|| /*--Bug#4707819--*/
62: 'FROM ' ||
63: 'msd_sr_item_supersession_v' || x_dblink;

Line 137: FND_GLOBAL.USER_ID,

133: related_item_id,
134: related_item,
135: relationship_type_id,
136: sysdate,
137: FND_GLOBAL.USER_ID,
138: sysdate,
139: FND_GLOBAL.USER_ID,
140: FND_GLOBAL.USER_ID,
141: start_date, /*--Bug#4707819--*/

Line 139: FND_GLOBAL.USER_ID,

135: relationship_type_id,
136: sysdate,
137: FND_GLOBAL.USER_ID,
138: sysdate,
139: FND_GLOBAL.USER_ID,
140: FND_GLOBAL.USER_ID,
141: start_date, /*--Bug#4707819--*/
142: end_date /*--Bug#4707819--*/
143: FROM msd_st_item_relationships

Line 140: FND_GLOBAL.USER_ID,

136: sysdate,
137: FND_GLOBAL.USER_ID,
138: sysdate,
139: FND_GLOBAL.USER_ID,
140: FND_GLOBAL.USER_ID,
141: start_date, /*--Bug#4707819--*/
142: end_date /*--Bug#4707819--*/
143: FROM msd_st_item_relationships
144: WHERE instance_id = l_instance_id;

Line 259: FND_GLOBAL.USER_ID,

255: l_inventory_item_id,
256: l_start_time, /*--Bug#4707819--*/
257: l_end_time, /*--Bug#4707819--*/
258: sysdate,
259: FND_GLOBAL.USER_ID,
260: sysdate,
261: FND_GLOBAL.USER_ID,
262: FND_GLOBAL.USER_ID );
263:

Line 261: FND_GLOBAL.USER_ID,

257: l_end_time, /*--Bug#4707819--*/
258: sysdate,
259: FND_GLOBAL.USER_ID,
260: sysdate,
261: FND_GLOBAL.USER_ID,
262: FND_GLOBAL.USER_ID );
263:
264: -- commit;
265:

Line 262: FND_GLOBAL.USER_ID );

258: sysdate,
259: FND_GLOBAL.USER_ID,
260: sysdate,
261: FND_GLOBAL.USER_ID,
262: FND_GLOBAL.USER_ID );
263:
264: -- commit;
265:
266: EXCEPTION

Line 329: FND_GLOBAL.USER_ID,

325: l_npi_prd_relshp,
326: l_start_time, /*--Bug#4707819--*/
327: l_end_time, /*--Bug#4707819--*/
328: sysdate,
329: FND_GLOBAL.USER_ID,
330: sysdate,
331: FND_GLOBAL.USER_ID,
332: FND_GLOBAL.USER_ID );
333:

Line 331: FND_GLOBAL.USER_ID,

327: l_end_time, /*--Bug#4707819--*/
328: sysdate,
329: FND_GLOBAL.USER_ID,
330: sysdate,
331: FND_GLOBAL.USER_ID,
332: FND_GLOBAL.USER_ID );
333:
334: -- commit;
335:

Line 332: FND_GLOBAL.USER_ID );

328: sysdate,
329: FND_GLOBAL.USER_ID,
330: sysdate,
331: FND_GLOBAL.USER_ID,
332: FND_GLOBAL.USER_ID );
333:
334: -- commit;
335:
336: EXCEPTION

Line 396: FND_GLOBAL.USER_ID,

392: sysdate,
393: l_qty_mod_type,
394: l_qty_mod_factor,
395: sysdate,
396: FND_GLOBAL.USER_ID,
397: sysdate,
398: FND_GLOBAL.USER_ID,
399: FND_GLOBAL.USER_ID );
400:

Line 398: FND_GLOBAL.USER_ID,

394: l_qty_mod_factor,
395: sysdate,
396: FND_GLOBAL.USER_ID,
397: sysdate,
398: FND_GLOBAL.USER_ID,
399: FND_GLOBAL.USER_ID );
400:
401: -- commit;
402:

Line 399: FND_GLOBAL.USER_ID );

395: sysdate,
396: FND_GLOBAL.USER_ID,
397: sysdate,
398: FND_GLOBAL.USER_ID,
399: FND_GLOBAL.USER_ID );
400:
401: -- commit;
402:
403: EXCEPTION