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.PON_VALIDATE_SHIPMENTS_INT dependencies on FND_GLOBAL

Line 43: l_user_id := fnd_global.user_id;

39:
40:
41: BEGIN
42:
43: l_user_id := fnd_global.user_id;
44: l_login_id := fnd_global.login_id;
45: l_exp_date := SYSDATE + 7;
46: l_interface_type := 'NEGSHIPMTUPLOAD';
47: p_request_id := 0;

Line 44: l_login_id := fnd_global.login_id;

40:
41: BEGIN
42:
43: l_user_id := fnd_global.user_id;
44: l_login_id := fnd_global.login_id;
45: l_exp_date := SYSDATE + 7;
46: l_interface_type := 'NEGSHIPMTUPLOAD';
47: p_request_id := 0;
48:

Line 262: sl.last_updated_by = fnd_global.user_id,

258: sl.org_id = ship.org_id,
259: sl.effective_start_date = decode(ship.price_break_type, 'NON-CUMULATIVE',ship.effective_start_date,null),
260: sl.effective_end_date = decode(ship.price_break_type, 'NON-CUMULATIVE',ship.effective_end_date,null),
261: sl.last_update_date = sysdate,
262: sl.last_updated_by = fnd_global.user_id,
263: sl.last_update_login = fnd_global.login_id
264: WHEN NOT MATCHED THEN
265: INSERT (
266: AUCTION_HEADER_ID,

Line 263: sl.last_update_login = fnd_global.login_id

259: sl.effective_start_date = decode(ship.price_break_type, 'NON-CUMULATIVE',ship.effective_start_date,null),
260: sl.effective_end_date = decode(ship.price_break_type, 'NON-CUMULATIVE',ship.effective_end_date,null),
261: sl.last_update_date = sysdate,
262: sl.last_updated_by = fnd_global.user_id,
263: sl.last_update_login = fnd_global.login_id
264: WHEN NOT MATCHED THEN
265: INSERT (
266: AUCTION_HEADER_ID,
267: LINE_NUMBER,

Line 300: fnd_global.user_id ,

296: decode(ship.price_break_type, 'NON-CUMULATIVE',ship.effective_end_date,null),
297: decode(ship.price_tiers_indicator, 'QUANTITY_BASED',ship.max_quantity,null),
298: 'N',
299: SYSDATE ,
300: fnd_global.user_id ,
301: SYSDATE ,
302: fnd_global.user_id ,
303: fnd_global.login_id
304: ) ;

Line 302: fnd_global.user_id ,

298: 'N',
299: SYSDATE ,
300: fnd_global.user_id ,
301: SYSDATE ,
302: fnd_global.user_id ,
303: fnd_global.login_id
304: ) ;
305:
306: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 303: fnd_global.login_id

299: SYSDATE ,
300: fnd_global.user_id ,
301: SYSDATE ,
302: fnd_global.user_id ,
303: fnd_global.login_id
304: ) ;
305:
306: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
307: l_progress := 'Merge into pon_auction_shipments is successful for batch_id = '||p_batch_id;

Line 361: l_user_id := fnd_global.user_id;

357:
358:
359: BEGIN
360:
361: l_user_id := fnd_global.user_id;
362: l_login_id := fnd_global.login_id;
363: l_exp_date := SYSDATE + 7;
364: l_interface_type := 'NEGSHIPMTUPLOAD';
365: p_request_id := 0;

Line 362: l_login_id := fnd_global.login_id;

358:
359: BEGIN
360:
361: l_user_id := fnd_global.user_id;
362: l_login_id := fnd_global.login_id;
363: l_exp_date := SYSDATE + 7;
364: l_interface_type := 'NEGSHIPMTUPLOAD';
365: p_request_id := 0;
366:

Line 383: /* bug#16839410 user will not be able to enter tab in the ship_to_location value so replacing the tab using fnd_global.local_chr */

379: WHERE organization_code = pb_int.SHIP_TO_ORGANIZATION
380: )
381: WHERE batch_id = p_batch_id
382: AND SHIP_TO_ORGANIZATION IS NOT NULL;
383: /* bug#16839410 user will not be able to enter tab in the ship_to_location value so replacing the tab using fnd_global.local_chr */
384: UPDATE pon_auc_price_breaks_interface pb_int
385: SET ship_to_location_id =
386: (SELECT MAX(location_id)
387: FROM po_ship_to_loc_org_v po_v

Line 388: WHERE replace(po_v.location_code,fnd_global.local_chr(9),'') = pb_int.ship_to_location

384: UPDATE pon_auc_price_breaks_interface pb_int
385: SET ship_to_location_id =
386: (SELECT MAX(location_id)
387: FROM po_ship_to_loc_org_v po_v
388: WHERE replace(po_v.location_code,fnd_global.local_chr(9),'') = pb_int.ship_to_location
389: )
390: WHERE batch_id = p_batch_id
391: AND ship_to_location IS NOT null;
392:

Line 1309: l_user_id := fnd_global.user_id;

1305:
1306:
1307: BEGIN
1308:
1309: l_user_id := fnd_global.user_id;
1310: l_login_id := fnd_global.login_id;
1311: l_exp_date := SYSDATE + 7;
1312: l_interface_type := 'NEGSHIPMTUPLOAD';
1313: p_request_id := 0;

Line 1310: l_login_id := fnd_global.login_id;

1306:
1307: BEGIN
1308:
1309: l_user_id := fnd_global.user_id;
1310: l_login_id := fnd_global.login_id;
1311: l_exp_date := SYSDATE + 7;
1312: l_interface_type := 'NEGSHIPMTUPLOAD';
1313: p_request_id := 0;
1314: