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

Line 508: p_logging_entity_id => FND_GLOBAL.USER_ID,

504: wsh_xc_util.log_exception (
505: p_api_version => 1.0,
506: p_exception_name => 'WSH_IB_SF_LOCN_CODE_CHG',
507: p_logging_entity => 'SHIPPER',
508: p_logging_entity_id => FND_GLOBAL.USER_ID,
509: x_return_status => l_return_status,
510: x_exception_id => l_exception_id,
511: x_msg_data => l_xc_msg_data,
512: x_msg_count => l_xc_msg_count,

Line 767: p_logging_entity_id => FND_GLOBAL.USER_ID,

763: wsh_xc_util.log_exception (
764: p_api_version => 1.0,
765: p_exception_name => 'WSH_IB_SF_LOCN_CODE_CHG',
766: p_logging_entity => 'SHIPPER',
767: p_logging_entity_id => FND_GLOBAL.USER_ID,
768: x_return_status => l_return_status,
769: x_exception_id => l_exception_id,
770: x_msg_data => l_xc_msg_data,
771: x_msg_count => l_xc_msg_count,

Line 934: last_updated_by = fnd_global.user_id,

930: UPDATE wsh_new_deliveries
931: SET vendor_id = p_to_id,
932: party_id = p_to_party_id,
933: last_update_date = sysdate,
934: last_updated_by = fnd_global.user_id,
935: last_update_login = fnd_global.login_id
936: WHERE delivery_id = p_delivery_id
937: RETURNING name INTO l_dlvy_name;
938: IF l_debug_on THEN

Line 935: last_update_login = fnd_global.login_id

931: SET vendor_id = p_to_id,
932: party_id = p_to_party_id,
933: last_update_date = sysdate,
934: last_updated_by = fnd_global.user_id,
935: last_update_login = fnd_global.login_id
936: WHERE delivery_id = p_delivery_id
937: RETURNING name INTO l_dlvy_name;
938: IF l_debug_on THEN
939: --{

Line 950: last_updated_by = fnd_global.user_id,

946: UPDATE wsh_new_deliveries
947: SET vendor_id = p_to_id,
948: party_id = p_to_party_id,
949: last_update_date = sysdate,
950: last_updated_by = fnd_global.user_id,
951: last_update_login = fnd_global.login_id
952: WHERE delivery_id
953: IN ( SELECT delivery_id
954: FROM wsh_delivery_assignments

Line 951: last_update_login = fnd_global.login_id

947: SET vendor_id = p_to_id,
948: party_id = p_to_party_id,
949: last_update_date = sysdate,
950: last_updated_by = fnd_global.user_id,
951: last_update_login = fnd_global.login_id
952: WHERE delivery_id
953: IN ( SELECT delivery_id
954: FROM wsh_delivery_assignments
955: WHERE delivery_detail_id

Line 1229: last_updated_by = fnd_global.user_id,

1225: UPDATE wsh_carriers
1226: SET supplier_id = p_to_id,
1227: supplier_site_id = p_to_site_id,
1228: last_update_date = sysdate,
1229: last_updated_by = fnd_global.user_id,
1230: last_update_login = fnd_global.login_id
1231: WHERE supplier_id = p_from_id
1232: AND supplier_site_id = p_from_site_id;
1233: --

Line 1230: last_update_login = fnd_global.login_id

1226: SET supplier_id = p_to_id,
1227: supplier_site_id = p_to_site_id,
1228: last_update_date = sysdate,
1229: last_updated_by = fnd_global.user_id,
1230: last_update_login = fnd_global.login_id
1231: WHERE supplier_id = p_from_id
1232: AND supplier_site_id = p_from_site_id;
1233: --
1234: IF l_debug_on THEN

Line 1245: last_updated_by = fnd_global.user_id,

1241: --
1242: UPDATE wsh_carrier_sites
1243: SET supplier_site_id = p_to_site_id,
1244: last_update_date = sysdate,
1245: last_updated_by = fnd_global.user_id,
1246: last_update_login = fnd_global.login_id
1247: WHERE supplier_site_id = p_from_site_id;
1248: --
1249: IF l_debug_on THEN

Line 1246: last_update_login = fnd_global.login_id

1242: UPDATE wsh_carrier_sites
1243: SET supplier_site_id = p_to_site_id,
1244: last_update_date = sysdate,
1245: last_updated_by = fnd_global.user_id,
1246: last_update_login = fnd_global.login_id
1247: WHERE supplier_site_id = p_from_site_id;
1248: --
1249: IF l_debug_on THEN
1250: --{

Line 1306: last_updated_by = fnd_global.user_id,

1302: UPDATE wsh_calendar_assignments
1303: SET vendor_id = p_to_id,
1304: vendor_site_id = p_to_site_id,
1305: last_update_date = sysdate,
1306: last_updated_by = fnd_global.user_id,
1307: last_update_login = fnd_global.login_id
1308: WHERE calendar_assignment_id = check_site_calendar_rec.calendar_assignment_id;
1309: --
1310: IF l_debug_on THEN

Line 1307: last_update_login = fnd_global.login_id

1303: SET vendor_id = p_to_id,
1304: vendor_site_id = p_to_site_id,
1305: last_update_date = sysdate,
1306: last_updated_by = fnd_global.user_id,
1307: last_update_login = fnd_global.login_id
1308: WHERE calendar_assignment_id = check_site_calendar_rec.calendar_assignment_id;
1309: --
1310: IF l_debug_on THEN
1311: --{

Line 1872: last_updated_by = fnd_global.user_id,

1868: SET vendor_id = p_to_id,
1869: ship_from_site_id = p_to_site_id,
1870: party_id = p_to_party_id,
1871: last_update_date = sysdate,
1872: last_updated_by = fnd_global.user_id,
1873: last_update_login = fnd_global.login_id
1874: WHERE delivery_detail_id = l_dd_list(j);
1875: IF SQL%ROWCOUNT <> l_dd_list.count THEN
1876: --{

Line 1873: last_update_login = fnd_global.login_id

1869: ship_from_site_id = p_to_site_id,
1870: party_id = p_to_party_id,
1871: last_update_date = sysdate,
1872: last_updated_by = fnd_global.user_id,
1873: last_update_login = fnd_global.login_id
1874: WHERE delivery_detail_id = l_dd_list(j);
1875: IF SQL%ROWCOUNT <> l_dd_list.count THEN
1876: --{
1877: IF l_debug_on THEN

Line 2137: last_updated_by = fnd_global.user_id,

2133: --{
2134: UPDATE wsh_inbound_txn_history
2135: SET supplier_id = p_to_id,
2136: last_update_date = sysdate,
2137: last_updated_by = fnd_global.user_id,
2138: last_update_login = fnd_global.login_id
2139: WHERE transaction_type = 'ROUTING_RESPONSE'
2140: AND shipment_header_id = l_delivery_rec.delivery_id
2141: AND supplier_id = p_from_id;

Line 2138: last_update_login = fnd_global.login_id

2134: UPDATE wsh_inbound_txn_history
2135: SET supplier_id = p_to_id,
2136: last_update_date = sysdate,
2137: last_updated_by = fnd_global.user_id,
2138: last_update_login = fnd_global.login_id
2139: WHERE transaction_type = 'ROUTING_RESPONSE'
2140: AND shipment_header_id = l_delivery_rec.delivery_id
2141: AND supplier_id = p_from_id;
2142: IF l_debug_on THEN

Line 2163: last_updated_by = fnd_global.user_id,

2159: UPDATE wsh_delivery_details
2160: SET vendor_id = p_to_id,
2161: party_id = p_to_party_id,
2162: last_update_date = sysdate,
2163: last_updated_by = fnd_global.user_id,
2164: last_update_login = fnd_global.login_id
2165: WHERE container_flag = 'Y'
2166: AND vendor_id = p_from_id
2167: AND delivery_detail_id

Line 2164: last_update_login = fnd_global.login_id

2160: SET vendor_id = p_to_id,
2161: party_id = p_to_party_id,
2162: last_update_date = sysdate,
2163: last_updated_by = fnd_global.user_id,
2164: last_update_login = fnd_global.login_id
2165: WHERE container_flag = 'Y'
2166: AND vendor_id = p_from_id
2167: AND delivery_detail_id
2168: IN (

Line 2373: p_logging_entity_id => FND_GLOBAL.USER_ID,

2369: wsh_xc_util.log_exception (
2370: p_api_version => 1.0,
2371: p_exception_name => 'WSH_IB_RR_NUMBER_CHG',
2372: p_logging_entity => 'SHIPPER',
2373: p_logging_entity_id => FND_GLOBAL.USER_ID,
2374: x_return_status => l_return_status,
2375: x_exception_id => l_exception_id,
2376: x_msg_data => l_xc_msg_data,
2377: x_msg_count => l_xc_msg_count,

Line 2409: last_updated_by = fnd_global.user_id,

2405: --
2406: UPDATE wsh_delivery_details
2407: SET routing_req_Id = l_new_rr_id,
2408: last_update_date = sysdate,
2409: last_updated_by = fnd_global.user_id,
2410: last_update_login = fnd_global.login_id
2411: WHERE delivery_detail_id = l_dlvy_rr_rec.delivery_detail_id;
2412: --
2413: IF l_debug_on THEN

Line 2410: last_update_login = fnd_global.login_id

2406: UPDATE wsh_delivery_details
2407: SET routing_req_Id = l_new_rr_id,
2408: last_update_date = sysdate,
2409: last_updated_by = fnd_global.user_id,
2410: last_update_login = fnd_global.login_id
2411: WHERE delivery_detail_id = l_dlvy_rr_rec.delivery_detail_id;
2412: --
2413: IF l_debug_on THEN
2414: --{

Line 2438: last_updated_by = fnd_global.user_id,

2434: --
2435: UPDATE wsh_inbound_txn_history a
2436: SET supplier_id = p_to_id,
2437: last_update_date = sysdate,
2438: last_updated_by = fnd_global.user_id,
2439: last_update_login = fnd_global.login_id
2440: WHERE supplier_id = p_from_id
2441: AND transaction_type not in ('ROUTING_REQUEST','ROUTING_RESPONSE')
2442: AND exists (SELECT shipment_header_id

Line 2439: last_update_login = fnd_global.login_id

2435: UPDATE wsh_inbound_txn_history a
2436: SET supplier_id = p_to_id,
2437: last_update_date = sysdate,
2438: last_updated_by = fnd_global.user_id,
2439: last_update_login = fnd_global.login_id
2440: WHERE supplier_id = p_from_id
2441: AND transaction_type not in ('ROUTING_REQUEST','ROUTING_RESPONSE')
2442: AND exists (SELECT shipment_header_id
2443: FROM rcv_shipment_headers b

Line 2569: last_updated_by = fnd_global.user_id,

2565: FORALL I IN l_dlvy_tbl.first..l_dlvy_tbl.last
2566: UPDATE wsh_delivery_legs
2567: SET reprice_required = 'Y',
2568: last_update_date = sysdate,
2569: last_updated_by = fnd_global.user_id,
2570: last_update_login = fnd_global.login_id
2571: WHERE delivery_id = l_dlvy_tbl(i);
2572:
2573: ELSIF (l_option = 'B' or l_option = 'I') THEN

Line 2570: last_update_login = fnd_global.login_id

2566: UPDATE wsh_delivery_legs
2567: SET reprice_required = 'Y',
2568: last_update_date = sysdate,
2569: last_updated_by = fnd_global.user_id,
2570: last_update_login = fnd_global.login_id
2571: WHERE delivery_id = l_dlvy_tbl(i);
2572:
2573: ELSIF (l_option = 'B' or l_option = 'I') THEN
2574:

Line 2580: last_updated_by = fnd_global.user_id,

2576: UPDATE fte_invoice_headers a
2577: SET supplier_id = p_to_id,
2578: supplier_site_id = p_to_site_id,
2579: last_update_date = sysdate,
2580: last_updated_by = fnd_global.user_id,
2581: last_update_login = fnd_global.login_id
2582: WHERE supplier_id = p_from_id
2583: AND supplier_site_id = p_from_site_id
2584: AND exists (SELECT 1

Line 2581: last_update_login = fnd_global.login_id

2577: SET supplier_id = p_to_id,
2578: supplier_site_id = p_to_site_id,
2579: last_update_date = sysdate,
2580: last_updated_by = fnd_global.user_id,
2581: last_update_login = fnd_global.login_id
2582: WHERE supplier_id = p_from_id
2583: AND supplier_site_id = p_from_site_id
2584: AND exists (SELECT 1
2585: FROM ap_invoices_all

Line 3688: last_updated_by = fnd_global.user_id,

3684: ship_to_site_use_id = decode(container_flag,
3685: 'N', l_to_party_site_use_id,
3686: ship_to_site_use_id),
3687: last_update_date = SYSDATE,
3688: last_updated_by = fnd_global.user_id,
3689: last_update_login = fnd_global.conc_login_id,
3690: program_application_id = fnd_global.prog_appl_id,
3691: program_id = fnd_global.conc_program_id,
3692: program_update_date = SYSDATE

Line 3689: last_update_login = fnd_global.conc_login_id,

3685: 'N', l_to_party_site_use_id,
3686: ship_to_site_use_id),
3687: last_update_date = SYSDATE,
3688: last_updated_by = fnd_global.user_id,
3689: last_update_login = fnd_global.conc_login_id,
3690: program_application_id = fnd_global.prog_appl_id,
3691: program_id = fnd_global.conc_program_id,
3692: program_update_date = SYSDATE
3693: WHERE delivery_detail_id IN

Line 3690: program_application_id = fnd_global.prog_appl_id,

3686: ship_to_site_use_id),
3687: last_update_date = SYSDATE,
3688: last_updated_by = fnd_global.user_id,
3689: last_update_login = fnd_global.conc_login_id,
3690: program_application_id = fnd_global.prog_appl_id,
3691: program_id = fnd_global.conc_program_id,
3692: program_update_date = SYSDATE
3693: WHERE delivery_detail_id IN
3694: ( SELECT wda.delivery_detail_id

Line 3691: program_id = fnd_global.conc_program_id,

3687: last_update_date = SYSDATE,
3688: last_updated_by = fnd_global.user_id,
3689: last_update_login = fnd_global.conc_login_id,
3690: program_application_id = fnd_global.prog_appl_id,
3691: program_id = fnd_global.conc_program_id,
3692: program_update_date = SYSDATE
3693: WHERE delivery_detail_id IN
3694: ( SELECT wda.delivery_detail_id
3695: FROM wsh_delivery_assignments wda

Line 3738: last_updated_by = fnd_global.user_id,

3734: customer_id),
3735: ship_to_site_use_id = l_to_party_site_use_id,
3736: ship_to_location_id = l_to_location_id,
3737: last_update_date = SYSDATE,
3738: last_updated_by = fnd_global.user_id,
3739: last_update_login = fnd_global.conc_login_id,
3740: program_application_id = fnd_global.prog_appl_id,
3741: program_id = fnd_global.conc_program_id,
3742: program_update_date = SYSDATE

Line 3739: last_update_login = fnd_global.conc_login_id,

3735: ship_to_site_use_id = l_to_party_site_use_id,
3736: ship_to_location_id = l_to_location_id,
3737: last_update_date = SYSDATE,
3738: last_updated_by = fnd_global.user_id,
3739: last_update_login = fnd_global.conc_login_id,
3740: program_application_id = fnd_global.prog_appl_id,
3741: program_id = fnd_global.conc_program_id,
3742: program_update_date = SYSDATE
3743: WHERE ROWID = l_wdd_rowid(i);

Line 3740: program_application_id = fnd_global.prog_appl_id,

3736: ship_to_location_id = l_to_location_id,
3737: last_update_date = SYSDATE,
3738: last_updated_by = fnd_global.user_id,
3739: last_update_login = fnd_global.conc_login_id,
3740: program_application_id = fnd_global.prog_appl_id,
3741: program_id = fnd_global.conc_program_id,
3742: program_update_date = SYSDATE
3743: WHERE ROWID = l_wdd_rowid(i);
3744: l_sql_count := SQL%rowcount;

Line 3741: program_id = fnd_global.conc_program_id,

3737: last_update_date = SYSDATE,
3738: last_updated_by = fnd_global.user_id,
3739: last_update_login = fnd_global.conc_login_id,
3740: program_application_id = fnd_global.prog_appl_id,
3741: program_id = fnd_global.conc_program_id,
3742: program_update_date = SYSDATE
3743: WHERE ROWID = l_wdd_rowid(i);
3744: l_sql_count := SQL%rowcount;
3745: IF l_debug_on THEN

Line 3782: last_updated_by = fnd_global.user_id,

3778: FORALL I IN l_wda_rowid.first..l_wda_rowid.last
3779: UPDATE wsh_delivery_assignments
3780: SET parent_delivery_detail_id = NULL,
3781: last_update_date = SYSDATE,
3782: last_updated_by = fnd_global.user_id,
3783: last_update_login = fnd_global.conc_login_id,
3784: program_application_id = fnd_global.prog_appl_id,
3785: program_id = fnd_global.conc_program_id,
3786: program_update_date = SYSDATE

Line 3783: last_update_login = fnd_global.conc_login_id,

3779: UPDATE wsh_delivery_assignments
3780: SET parent_delivery_detail_id = NULL,
3781: last_update_date = SYSDATE,
3782: last_updated_by = fnd_global.user_id,
3783: last_update_login = fnd_global.conc_login_id,
3784: program_application_id = fnd_global.prog_appl_id,
3785: program_id = fnd_global.conc_program_id,
3786: program_update_date = SYSDATE
3787: WHERE ROWID = l_wda_rowid(i)

Line 3784: program_application_id = fnd_global.prog_appl_id,

3780: SET parent_delivery_detail_id = NULL,
3781: last_update_date = SYSDATE,
3782: last_updated_by = fnd_global.user_id,
3783: last_update_login = fnd_global.conc_login_id,
3784: program_application_id = fnd_global.prog_appl_id,
3785: program_id = fnd_global.conc_program_id,
3786: program_update_date = SYSDATE
3787: WHERE ROWID = l_wda_rowid(i)
3788: AND parent_delivery_detail_id IS NOT NULL

Line 3785: program_id = fnd_global.conc_program_id,

3781: last_update_date = SYSDATE,
3782: last_updated_by = fnd_global.user_id,
3783: last_update_login = fnd_global.conc_login_id,
3784: program_application_id = fnd_global.prog_appl_id,
3785: program_id = fnd_global.conc_program_id,
3786: program_update_date = SYSDATE
3787: WHERE ROWID = l_wda_rowid(i)
3788: AND parent_delivery_detail_id IS NOT NULL
3789: AND delivery_id IS NULL;

Line 3854: p_logging_entity_id => Fnd_Global.user_id,

3850: x_exception_id => l_exception_id,
3851: p_exception_location_id => l_from_location_id,
3852: p_logged_at_location_id => l_to_location_id,
3853: p_logging_entity => 'SHIPPER',
3854: p_logging_entity_id => Fnd_Global.user_id,
3855: p_exception_name => 'WSH_VENDOR_MERGE_CHANGE',
3856: p_message => l_message_text,
3857: p_severity => 'LOW',
3858: p_manually_logged => 'N',

Line 3980: last_updated_by = fnd_global.user_id,

3976: UPDATE wsh_delivery_assignments
3977: SET parent_delivery_detail_id = NULL,
3978: delivery_id = NULL,
3979: last_update_date = SYSDATE,
3980: last_updated_by = fnd_global.user_id,
3981: last_update_login = fnd_global.conc_login_id,
3982: program_application_id = fnd_global.prog_appl_id,
3983: program_id = fnd_global.conc_program_id,
3984: program_update_date = SYSDATE

Line 3981: last_update_login = fnd_global.conc_login_id,

3977: SET parent_delivery_detail_id = NULL,
3978: delivery_id = NULL,
3979: last_update_date = SYSDATE,
3980: last_updated_by = fnd_global.user_id,
3981: last_update_login = fnd_global.conc_login_id,
3982: program_application_id = fnd_global.prog_appl_id,
3983: program_id = fnd_global.conc_program_id,
3984: program_update_date = SYSDATE
3985: WHERE ROWID = l_wda_rowid(i);

Line 3982: program_application_id = fnd_global.prog_appl_id,

3978: delivery_id = NULL,
3979: last_update_date = SYSDATE,
3980: last_updated_by = fnd_global.user_id,
3981: last_update_login = fnd_global.conc_login_id,
3982: program_application_id = fnd_global.prog_appl_id,
3983: program_id = fnd_global.conc_program_id,
3984: program_update_date = SYSDATE
3985: WHERE ROWID = l_wda_rowid(i);
3986: l_sql_count := SQL%rowcount;

Line 3983: program_id = fnd_global.conc_program_id,

3979: last_update_date = SYSDATE,
3980: last_updated_by = fnd_global.user_id,
3981: last_update_login = fnd_global.conc_login_id,
3982: program_application_id = fnd_global.prog_appl_id,
3983: program_id = fnd_global.conc_program_id,
3984: program_update_date = SYSDATE
3985: WHERE ROWID = l_wda_rowid(i);
3986: l_sql_count := SQL%rowcount;
3987: IF l_debug_on THEN

Line 4060: p_logging_entity_id => Fnd_Global.user_id,

4056: x_exception_id => l_exception_id,
4057: p_exception_location_id => l_from_location_id,
4058: p_logged_at_location_id => l_to_location_id,
4059: p_logging_entity => 'SHIPPER',
4060: p_logging_entity_id => Fnd_Global.user_id,
4061: p_exception_name => 'WSH_VENDOR_MERGE_CHANGE',
4062: p_message => l_message_text,
4063: p_severity => 'LOW',
4064: p_manually_logged => 'N',

Line 4106: p_logging_entity_id => Fnd_Global.user_id,

4102: x_exception_id => l_exception_id,
4103: p_exception_location_id => l_from_location_id,
4104: p_logged_at_location_id => l_to_location_id,
4105: p_logging_entity => 'SHIPPER',
4106: p_logging_entity_id => Fnd_Global.user_id,
4107: p_exception_name => 'WSH_VENDOR_MERGE_CHANGE',
4108: p_message => l_message_text,
4109: p_severity => 'LOW',
4110: p_manually_logged => 'N',

Line 4167: last_updated_by = fnd_global.user_id,

4163: p_from_vendor_id, p_to_vendor_id,
4164: customer_id),
4165: ship_to_location_id = l_to_location_id,
4166: last_update_date = SYSDATE,
4167: last_updated_by = fnd_global.user_id,
4168: last_update_login = fnd_global.conc_login_id,
4169: program_application_id = fnd_global.prog_appl_id,
4170: program_id = fnd_global.conc_program_id,
4171: program_update_date = SYSDATE

Line 4168: last_update_login = fnd_global.conc_login_id,

4164: customer_id),
4165: ship_to_location_id = l_to_location_id,
4166: last_update_date = SYSDATE,
4167: last_updated_by = fnd_global.user_id,
4168: last_update_login = fnd_global.conc_login_id,
4169: program_application_id = fnd_global.prog_appl_id,
4170: program_id = fnd_global.conc_program_id,
4171: program_update_date = SYSDATE
4172: WHERE ROWID = l_wdd_rowid(i);

Line 4169: program_application_id = fnd_global.prog_appl_id,

4165: ship_to_location_id = l_to_location_id,
4166: last_update_date = SYSDATE,
4167: last_updated_by = fnd_global.user_id,
4168: last_update_login = fnd_global.conc_login_id,
4169: program_application_id = fnd_global.prog_appl_id,
4170: program_id = fnd_global.conc_program_id,
4171: program_update_date = SYSDATE
4172: WHERE ROWID = l_wdd_rowid(i);
4173: l_sql_count := SQL%rowcount;

Line 4170: program_id = fnd_global.conc_program_id,

4166: last_update_date = SYSDATE,
4167: last_updated_by = fnd_global.user_id,
4168: last_update_login = fnd_global.conc_login_id,
4169: program_application_id = fnd_global.prog_appl_id,
4170: program_id = fnd_global.conc_program_id,
4171: program_update_date = SYSDATE
4172: WHERE ROWID = l_wdd_rowid(i);
4173: l_sql_count := SQL%rowcount;
4174: IF l_debug_on THEN

Line 4223: last_updated_by = fnd_global.user_id,

4219: ultimate_dropoff_location_id = l_to_location_id,
4220: hash_value = l_hash_value_tab(i),
4221: hash_string = l_hash_string_tab(i),
4222: last_update_date = SYSDATE,
4223: last_updated_by = fnd_global.user_id,
4224: last_update_login = fnd_global.conc_login_id,
4225: program_application_id = fnd_global.prog_appl_id,
4226: program_id = fnd_global.conc_program_id,
4227: program_update_date = SYSDATE

Line 4224: last_update_login = fnd_global.conc_login_id,

4220: hash_value = l_hash_value_tab(i),
4221: hash_string = l_hash_string_tab(i),
4222: last_update_date = SYSDATE,
4223: last_updated_by = fnd_global.user_id,
4224: last_update_login = fnd_global.conc_login_id,
4225: program_application_id = fnd_global.prog_appl_id,
4226: program_id = fnd_global.conc_program_id,
4227: program_update_date = SYSDATE
4228: WHERE delivery_id = l_delivery_id_tab(i);

Line 4225: program_application_id = fnd_global.prog_appl_id,

4221: hash_string = l_hash_string_tab(i),
4222: last_update_date = SYSDATE,
4223: last_updated_by = fnd_global.user_id,
4224: last_update_login = fnd_global.conc_login_id,
4225: program_application_id = fnd_global.prog_appl_id,
4226: program_id = fnd_global.conc_program_id,
4227: program_update_date = SYSDATE
4228: WHERE delivery_id = l_delivery_id_tab(i);
4229: l_sql_count := SQL%rowcount;

Line 4226: program_id = fnd_global.conc_program_id,

4222: last_update_date = SYSDATE,
4223: last_updated_by = fnd_global.user_id,
4224: last_update_login = fnd_global.conc_login_id,
4225: program_application_id = fnd_global.prog_appl_id,
4226: program_id = fnd_global.conc_program_id,
4227: program_update_date = SYSDATE
4228: WHERE delivery_id = l_delivery_id_tab(i);
4229: l_sql_count := SQL%rowcount;
4230: IF l_debug_on THEN

Line 4315: p_logging_entity_id => Fnd_Global.user_id,

4311: x_exception_id => l_exception_id,
4312: p_exception_location_id => l_from_location_id,
4313: p_logged_at_location_id => l_to_location_id,
4314: p_logging_entity => 'SHIPPER',
4315: p_logging_entity_id => Fnd_Global.user_id,
4316: p_exception_name => 'WSH_VENDOR_MERGE_CHANGE',
4317: p_message => l_message_text,
4318: p_severity => 'LOW',
4319: p_manually_logged => 'N',

Line 4352: last_updated_by = fnd_global.user_id,

4348:
4349: UPDATE wsh_trip_stops
4350: SET stop_location_id = l_to_location_id,
4351: last_update_date = SYSDATE,
4352: last_updated_by = fnd_global.user_id,
4353: last_update_login = fnd_global.conc_login_id,
4354: program_application_id = fnd_global.prog_appl_id,
4355: program_id = fnd_global.conc_program_id,
4356: program_update_date = SYSDATE

Line 4353: last_update_login = fnd_global.conc_login_id,

4349: UPDATE wsh_trip_stops
4350: SET stop_location_id = l_to_location_id,
4351: last_update_date = SYSDATE,
4352: last_updated_by = fnd_global.user_id,
4353: last_update_login = fnd_global.conc_login_id,
4354: program_application_id = fnd_global.prog_appl_id,
4355: program_id = fnd_global.conc_program_id,
4356: program_update_date = SYSDATE
4357: WHERE Stop_Id in (

Line 4354: program_application_id = fnd_global.prog_appl_id,

4350: SET stop_location_id = l_to_location_id,
4351: last_update_date = SYSDATE,
4352: last_updated_by = fnd_global.user_id,
4353: last_update_login = fnd_global.conc_login_id,
4354: program_application_id = fnd_global.prog_appl_id,
4355: program_id = fnd_global.conc_program_id,
4356: program_update_date = SYSDATE
4357: WHERE Stop_Id in (
4358: SELECT Column2

Line 4355: program_id = fnd_global.conc_program_id,

4351: last_update_date = SYSDATE,
4352: last_updated_by = fnd_global.user_id,
4353: last_update_login = fnd_global.conc_login_id,
4354: program_application_id = fnd_global.prog_appl_id,
4355: program_id = fnd_global.conc_program_id,
4356: program_update_date = SYSDATE
4357: WHERE Stop_Id in (
4358: SELECT Column2
4359: FROM WSH_TMP

Line 4427: last_updated_by = fnd_global.user_id,

4423: ultimate_dropoff_location_id = l_to_location_id,
4424: hash_value = l_grp_attr_tab(i).l1_hash_value,
4425: hash_string = l_grp_attr_tab(i).l1_hash_string,
4426: last_update_date = SYSDATE,
4427: last_updated_by = fnd_global.user_id,
4428: last_update_login = fnd_global.conc_login_id,
4429: program_application_id = fnd_global.prog_appl_id,
4430: program_id = fnd_global.conc_program_id,
4431: program_update_date = SYSDATE

Line 4428: last_update_login = fnd_global.conc_login_id,

4424: hash_value = l_grp_attr_tab(i).l1_hash_value,
4425: hash_string = l_grp_attr_tab(i).l1_hash_string,
4426: last_update_date = SYSDATE,
4427: last_updated_by = fnd_global.user_id,
4428: last_update_login = fnd_global.conc_login_id,
4429: program_application_id = fnd_global.prog_appl_id,
4430: program_id = fnd_global.conc_program_id,
4431: program_update_date = SYSDATE
4432: WHERE delivery_id = l_delivery_id(i);

Line 4429: program_application_id = fnd_global.prog_appl_id,

4425: hash_string = l_grp_attr_tab(i).l1_hash_string,
4426: last_update_date = SYSDATE,
4427: last_updated_by = fnd_global.user_id,
4428: last_update_login = fnd_global.conc_login_id,
4429: program_application_id = fnd_global.prog_appl_id,
4430: program_id = fnd_global.conc_program_id,
4431: program_update_date = SYSDATE
4432: WHERE delivery_id = l_delivery_id(i);
4433:

Line 4430: program_id = fnd_global.conc_program_id,

4426: last_update_date = SYSDATE,
4427: last_updated_by = fnd_global.user_id,
4428: last_update_login = fnd_global.conc_login_id,
4429: program_application_id = fnd_global.prog_appl_id,
4430: program_id = fnd_global.conc_program_id,
4431: program_update_date = SYSDATE
4432: WHERE delivery_id = l_delivery_id(i);
4433:
4434: l_sql_count := SQL%rowcount;