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_PARTY_MERGE dependencies on FND_GLOBAL

Line 774: last_updated_by = fnd_global.user_id,

770: --{
771: UPDATE wsh_carriers
772: SET supplier_id = p_to_id,
773: last_update_date = sysdate,
774: last_updated_by = fnd_global.user_id,
775: last_update_login = fnd_global.login_id
776: WHERE supplier_id = p_from_id
777: AND supplier_site_id IS NULL;
778: --

Line 775: last_update_login = fnd_global.login_id

771: UPDATE wsh_carriers
772: SET supplier_id = p_to_id,
773: last_update_date = sysdate,
774: last_updated_by = fnd_global.user_id,
775: last_update_login = fnd_global.login_id
776: WHERE supplier_id = p_from_id
777: AND supplier_site_id IS NULL;
778: --
779: IF l_debug_on THEN

Line 814: last_updated_by = fnd_global.user_id,

810: --
811: UPDATE wsh_calendar_assignments
812: SET vendor_id = p_to_id,
813: last_update_date = sysdate,
814: last_updated_by = fnd_global.user_id,
815: last_update_login = fnd_global.login_id
816: WHERE calendar_assignment_id = check_calendar_rec.calendar_assignment_id;
817: --
818: IF l_debug_on THEN

Line 815: last_update_login = fnd_global.login_id

811: UPDATE wsh_calendar_assignments
812: SET vendor_id = p_to_id,
813: last_update_date = sysdate,
814: last_updated_by = fnd_global.user_id,
815: last_update_login = fnd_global.login_id
816: WHERE calendar_assignment_id = check_calendar_rec.calendar_assignment_id;
817: --
818: IF l_debug_on THEN
819: --

Line 2012: last_updated_by = fnd_global.user_id,

2008: deliver_to_location_id = decode( nvl(deliver_to_site_use_id, ship_to_site_use_id),
2009: ship_to_site_use_id, l_to_location_id,
2010: deliver_to_location_id ),
2011: last_update_date = SYSDATE,
2012: last_updated_by = fnd_global.user_id,
2013: last_update_login = fnd_global.conc_login_id,
2014: program_application_id = fnd_global.prog_appl_id,
2015: program_id = fnd_global.conc_program_id,
2016: program_update_date = SYSDATE

Line 2013: last_update_login = fnd_global.conc_login_id,

2009: ship_to_site_use_id, l_to_location_id,
2010: deliver_to_location_id ),
2011: last_update_date = SYSDATE,
2012: last_updated_by = fnd_global.user_id,
2013: last_update_login = fnd_global.conc_login_id,
2014: program_application_id = fnd_global.prog_appl_id,
2015: program_id = fnd_global.conc_program_id,
2016: program_update_date = SYSDATE
2017: WHERE WDD.Rowid = l_del_detail_rowid_tab(i);

Line 2014: program_application_id = fnd_global.prog_appl_id,

2010: deliver_to_location_id ),
2011: last_update_date = SYSDATE,
2012: last_updated_by = fnd_global.user_id,
2013: last_update_login = fnd_global.conc_login_id,
2014: program_application_id = fnd_global.prog_appl_id,
2015: program_id = fnd_global.conc_program_id,
2016: program_update_date = SYSDATE
2017: WHERE WDD.Rowid = l_del_detail_rowid_tab(i);
2018:

Line 2015: program_id = fnd_global.conc_program_id,

2011: last_update_date = SYSDATE,
2012: last_updated_by = fnd_global.user_id,
2013: last_update_login = fnd_global.conc_login_id,
2014: program_application_id = fnd_global.prog_appl_id,
2015: program_id = fnd_global.conc_program_id,
2016: program_update_date = SYSDATE
2017: WHERE WDD.Rowid = l_del_detail_rowid_tab(i);
2018:
2019: --

Line 2039: last_updated_by = fnd_global.user_id,

2035: FORALL i IN l_del_assignments_rowid_tab.FIRST..l_del_assignments_rowid_tab.LAST
2036: UPDATE WSH_DELIVERY_ASSIGNMENTS
2037: SET parent_delivery_detail_id = null,
2038: last_update_date = SYSDATE,
2039: last_updated_by = fnd_global.user_id,
2040: last_update_login = fnd_global.conc_login_id,
2041: program_application_id = fnd_global.prog_appl_id,
2042: program_id = fnd_global.conc_program_id,
2043: program_update_date = SYSDATE

Line 2040: last_update_login = fnd_global.conc_login_id,

2036: UPDATE WSH_DELIVERY_ASSIGNMENTS
2037: SET parent_delivery_detail_id = null,
2038: last_update_date = SYSDATE,
2039: last_updated_by = fnd_global.user_id,
2040: last_update_login = fnd_global.conc_login_id,
2041: program_application_id = fnd_global.prog_appl_id,
2042: program_id = fnd_global.conc_program_id,
2043: program_update_date = SYSDATE
2044: WHERE rowid = l_del_assignments_rowid_tab(i)

Line 2041: program_application_id = fnd_global.prog_appl_id,

2037: SET parent_delivery_detail_id = null,
2038: last_update_date = SYSDATE,
2039: last_updated_by = fnd_global.user_id,
2040: last_update_login = fnd_global.conc_login_id,
2041: program_application_id = fnd_global.prog_appl_id,
2042: program_id = fnd_global.conc_program_id,
2043: program_update_date = SYSDATE
2044: WHERE rowid = l_del_assignments_rowid_tab(i)
2045: AND Parent_Delivery_Detail_Id IS NOT NULL

Line 2042: program_id = fnd_global.conc_program_id,

2038: last_update_date = SYSDATE,
2039: last_updated_by = fnd_global.user_id,
2040: last_update_login = fnd_global.conc_login_id,
2041: program_application_id = fnd_global.prog_appl_id,
2042: program_id = fnd_global.conc_program_id,
2043: program_update_date = SYSDATE
2044: WHERE rowid = l_del_assignments_rowid_tab(i)
2045: AND Parent_Delivery_Detail_Id IS NOT NULL
2046: AND Delivery_Id IS NULL;

Line 2160: p_logging_entity_id => Fnd_Global.user_id,

2156: x_exception_id => l_exception_id,
2157: p_exception_location_id => l_to_location_id,
2158: p_logged_at_location_id => l_to_location_id,
2159: p_logging_entity => 'SHIPPER',
2160: p_logging_entity_id => Fnd_Global.user_id,
2161: p_exception_name => 'WSH_PARTY_MERGE_CHANGE',
2162: p_message => l_message_name,
2163: p_severity => 'LOW',
2164: p_manually_logged => 'N',

Line 2230: last_updated_by = fnd_global.user_id,

2226: UPDATE WSH_DELIVERY_ASSIGNMENTS
2227: SET parent_delivery_detail_id = null,
2228: delivery_id = null,
2229: last_update_date = SYSDATE,
2230: last_updated_by = fnd_global.user_id,
2231: last_update_login = fnd_global.conc_login_id,
2232: program_application_id = fnd_global.prog_appl_id,
2233: program_id = fnd_global.conc_program_id,
2234: program_update_date = SYSDATE

Line 2231: last_update_login = fnd_global.conc_login_id,

2227: SET parent_delivery_detail_id = null,
2228: delivery_id = null,
2229: last_update_date = SYSDATE,
2230: last_updated_by = fnd_global.user_id,
2231: last_update_login = fnd_global.conc_login_id,
2232: program_application_id = fnd_global.prog_appl_id,
2233: program_id = fnd_global.conc_program_id,
2234: program_update_date = SYSDATE
2235: WHERE rowid = l_del_assignments_rowid_tab(i);

Line 2232: program_application_id = fnd_global.prog_appl_id,

2228: delivery_id = null,
2229: last_update_date = SYSDATE,
2230: last_updated_by = fnd_global.user_id,
2231: last_update_login = fnd_global.conc_login_id,
2232: program_application_id = fnd_global.prog_appl_id,
2233: program_id = fnd_global.conc_program_id,
2234: program_update_date = SYSDATE
2235: WHERE rowid = l_del_assignments_rowid_tab(i);
2236: ***/

Line 2233: program_id = fnd_global.conc_program_id,

2229: last_update_date = SYSDATE,
2230: last_updated_by = fnd_global.user_id,
2231: last_update_login = fnd_global.conc_login_id,
2232: program_application_id = fnd_global.prog_appl_id,
2233: program_id = fnd_global.conc_program_id,
2234: program_update_date = SYSDATE
2235: WHERE rowid = l_del_assignments_rowid_tab(i);
2236: ***/
2237:

Line 2326: p_logging_entity_id => Fnd_Global.user_id,

2322: x_exception_id => l_exception_id,
2323: p_exception_location_id => l_to_location_id,
2324: p_logged_at_location_id => l_to_location_id,
2325: p_logging_entity => 'SHIPPER',
2326: p_logging_entity_id => Fnd_Global.user_id,
2327: p_exception_name => 'WSH_PARTY_MERGE_CHANGE',
2328: p_message => l_message_name,
2329: p_severity => 'LOW',
2330: p_manually_logged => 'N',

Line 2381: last_updated_by = fnd_global.user_id,

2377: deliver_to_location_id = decode(deliver_to_location_id,
2378: ship_to_location_id, l_to_location_id,
2379: deliver_to_location_id),
2380: last_update_date = SYSDATE,
2381: last_updated_by = fnd_global.user_id,
2382: last_update_login = fnd_global.conc_login_id,
2383: program_application_id = fnd_global.prog_appl_id,
2384: program_id = fnd_global.conc_program_id,
2385: program_update_date = SYSDATE

Line 2382: last_update_login = fnd_global.conc_login_id,

2378: ship_to_location_id, l_to_location_id,
2379: deliver_to_location_id),
2380: last_update_date = SYSDATE,
2381: last_updated_by = fnd_global.user_id,
2382: last_update_login = fnd_global.conc_login_id,
2383: program_application_id = fnd_global.prog_appl_id,
2384: program_id = fnd_global.conc_program_id,
2385: program_update_date = SYSDATE
2386: WHERE Wdd.Rowid = l_del_detail_rowid_tab(updCnt);

Line 2383: program_application_id = fnd_global.prog_appl_id,

2379: deliver_to_location_id),
2380: last_update_date = SYSDATE,
2381: last_updated_by = fnd_global.user_id,
2382: last_update_login = fnd_global.conc_login_id,
2383: program_application_id = fnd_global.prog_appl_id,
2384: program_id = fnd_global.conc_program_id,
2385: program_update_date = SYSDATE
2386: WHERE Wdd.Rowid = l_del_detail_rowid_tab(updCnt);
2387:

Line 2384: program_id = fnd_global.conc_program_id,

2380: last_update_date = SYSDATE,
2381: last_updated_by = fnd_global.user_id,
2382: last_update_login = fnd_global.conc_login_id,
2383: program_application_id = fnd_global.prog_appl_id,
2384: program_id = fnd_global.conc_program_id,
2385: program_update_date = SYSDATE
2386: WHERE Wdd.Rowid = l_del_detail_rowid_tab(updCnt);
2387:
2388: --

Line 2456: l_delivery_rec.last_updated_by := fnd_global.user_id;

2452: l_delivery_rec.ultimate_dropoff_location_id := l_to_location_id;
2453: l_delivery_rec.hash_string := l_hash_string;
2454: l_delivery_rec.hash_value := l_hash_value;
2455: l_delivery_rec.last_update_date := SYSDATE;
2456: l_delivery_rec.last_updated_by := fnd_global.user_id;
2457: l_delivery_rec.last_update_login := fnd_global.conc_login_id;
2458: l_delivery_rec.program_application_id := fnd_global.prog_appl_id;
2459: l_delivery_rec.program_id := fnd_global.conc_program_id;
2460: l_delivery_rec.program_update_date := SYSDATE;

Line 2457: l_delivery_rec.last_update_login := fnd_global.conc_login_id;

2453: l_delivery_rec.hash_string := l_hash_string;
2454: l_delivery_rec.hash_value := l_hash_value;
2455: l_delivery_rec.last_update_date := SYSDATE;
2456: l_delivery_rec.last_updated_by := fnd_global.user_id;
2457: l_delivery_rec.last_update_login := fnd_global.conc_login_id;
2458: l_delivery_rec.program_application_id := fnd_global.prog_appl_id;
2459: l_delivery_rec.program_id := fnd_global.conc_program_id;
2460: l_delivery_rec.program_update_date := SYSDATE;
2461:

Line 2458: l_delivery_rec.program_application_id := fnd_global.prog_appl_id;

2454: l_delivery_rec.hash_value := l_hash_value;
2455: l_delivery_rec.last_update_date := SYSDATE;
2456: l_delivery_rec.last_updated_by := fnd_global.user_id;
2457: l_delivery_rec.last_update_login := fnd_global.conc_login_id;
2458: l_delivery_rec.program_application_id := fnd_global.prog_appl_id;
2459: l_delivery_rec.program_id := fnd_global.conc_program_id;
2460: l_delivery_rec.program_update_date := SYSDATE;
2461:
2462: --

Line 2459: l_delivery_rec.program_id := fnd_global.conc_program_id;

2455: l_delivery_rec.last_update_date := SYSDATE;
2456: l_delivery_rec.last_updated_by := fnd_global.user_id;
2457: l_delivery_rec.last_update_login := fnd_global.conc_login_id;
2458: l_delivery_rec.program_application_id := fnd_global.prog_appl_id;
2459: l_delivery_rec.program_id := fnd_global.conc_program_id;
2460: l_delivery_rec.program_update_date := SYSDATE;
2461:
2462: --
2463: IF l_debug_on THEN

Line 2606: p_logging_entity_id => Fnd_Global.user_id,

2602: x_exception_id => l_exception_id,
2603: p_exception_location_id => l_to_location_id,
2604: p_logged_at_location_id => l_to_location_id,
2605: p_logging_entity => 'SHIPPER',
2606: p_logging_entity_id => Fnd_Global.user_id,
2607: p_exception_name => 'WSH_PARTY_MERGE_CHANGE',
2608: p_message => l_message_name,
2609: p_severity => 'LOW',
2610: p_manually_logged => 'N',

Line 2634: last_updated_by = fnd_global.user_id,

2630:
2631: UPDATE WSH_TRIP_STOPS Wts
2632: SET stop_location_id = l_to_location_id,
2633: last_update_date = SYSDATE,
2634: last_updated_by = fnd_global.user_id,
2635: last_update_login = fnd_global.conc_login_id,
2636: program_application_id = fnd_global.prog_appl_id,
2637: program_id = fnd_global.conc_program_id,
2638: program_update_date = SYSDATE

Line 2635: last_update_login = fnd_global.conc_login_id,

2631: UPDATE WSH_TRIP_STOPS Wts
2632: SET stop_location_id = l_to_location_id,
2633: last_update_date = SYSDATE,
2634: last_updated_by = fnd_global.user_id,
2635: last_update_login = fnd_global.conc_login_id,
2636: program_application_id = fnd_global.prog_appl_id,
2637: program_id = fnd_global.conc_program_id,
2638: program_update_date = SYSDATE
2639: WHERE Wts.Stop_Id in (

Line 2636: program_application_id = fnd_global.prog_appl_id,

2632: SET stop_location_id = l_to_location_id,
2633: last_update_date = SYSDATE,
2634: last_updated_by = fnd_global.user_id,
2635: last_update_login = fnd_global.conc_login_id,
2636: program_application_id = fnd_global.prog_appl_id,
2637: program_id = fnd_global.conc_program_id,
2638: program_update_date = SYSDATE
2639: WHERE Wts.Stop_Id in (
2640: SELECT Column2

Line 2637: program_id = fnd_global.conc_program_id,

2633: last_update_date = SYSDATE,
2634: last_updated_by = fnd_global.user_id,
2635: last_update_login = fnd_global.conc_login_id,
2636: program_application_id = fnd_global.prog_appl_id,
2637: program_id = fnd_global.conc_program_id,
2638: program_update_date = SYSDATE
2639: WHERE Wts.Stop_Id in (
2640: SELECT Column2
2641: FROM WSH_TMP

Line 2690: last_updated_by = fnd_global.user_id,

2686: FORALL i IN l_del_detail_rowid_tab.FIRST..l_del_detail_rowid_tab.LAST
2687: UPDATE WSH_DELIVERY_DETAILS Wdd
2688: SET deliver_to_location_id = l_to_location_id,
2689: last_update_date = SYSDATE,
2690: last_updated_by = fnd_global.user_id,
2691: last_update_login = fnd_global.conc_login_id,
2692: program_application_id = fnd_global.prog_appl_id,
2693: program_id = fnd_global.conc_program_id,
2694: program_update_date = SYSDATE

Line 2691: last_update_login = fnd_global.conc_login_id,

2687: UPDATE WSH_DELIVERY_DETAILS Wdd
2688: SET deliver_to_location_id = l_to_location_id,
2689: last_update_date = SYSDATE,
2690: last_updated_by = fnd_global.user_id,
2691: last_update_login = fnd_global.conc_login_id,
2692: program_application_id = fnd_global.prog_appl_id,
2693: program_id = fnd_global.conc_program_id,
2694: program_update_date = SYSDATE
2695: WHERE WDD.Rowid = l_del_detail_rowid_tab(i);

Line 2692: program_application_id = fnd_global.prog_appl_id,

2688: SET deliver_to_location_id = l_to_location_id,
2689: last_update_date = SYSDATE,
2690: last_updated_by = fnd_global.user_id,
2691: last_update_login = fnd_global.conc_login_id,
2692: program_application_id = fnd_global.prog_appl_id,
2693: program_id = fnd_global.conc_program_id,
2694: program_update_date = SYSDATE
2695: WHERE WDD.Rowid = l_del_detail_rowid_tab(i);
2696:

Line 2693: program_id = fnd_global.conc_program_id,

2689: last_update_date = SYSDATE,
2690: last_updated_by = fnd_global.user_id,
2691: last_update_login = fnd_global.conc_login_id,
2692: program_application_id = fnd_global.prog_appl_id,
2693: program_id = fnd_global.conc_program_id,
2694: program_update_date = SYSDATE
2695: WHERE WDD.Rowid = l_del_detail_rowid_tab(i);
2696:
2697: --

Line 2733: last_updated_by = fnd_global.user_id,

2729: FORALL i IN l_del_detail_id_tab.FIRST..l_del_detail_id_tab.LAST
2730: UPDATE WSH_DELIVERY_DETAILS Wdd
2731: SET deliver_to_location_id = l_to_location_id,
2732: last_update_date = SYSDATE,
2733: last_updated_by = fnd_global.user_id,
2734: last_update_login = fnd_global.conc_login_id,
2735: program_application_id = fnd_global.prog_appl_id,
2736: program_id = fnd_global.conc_program_id,
2737: program_update_date = SYSDATE

Line 2734: last_update_login = fnd_global.conc_login_id,

2730: UPDATE WSH_DELIVERY_DETAILS Wdd
2731: SET deliver_to_location_id = l_to_location_id,
2732: last_update_date = SYSDATE,
2733: last_updated_by = fnd_global.user_id,
2734: last_update_login = fnd_global.conc_login_id,
2735: program_application_id = fnd_global.prog_appl_id,
2736: program_id = fnd_global.conc_program_id,
2737: program_update_date = SYSDATE
2738: WHERE WDD.Delivery_Detail_Id = l_del_detail_id_tab(i)

Line 2735: program_application_id = fnd_global.prog_appl_id,

2731: SET deliver_to_location_id = l_to_location_id,
2732: last_update_date = SYSDATE,
2733: last_updated_by = fnd_global.user_id,
2734: last_update_login = fnd_global.conc_login_id,
2735: program_application_id = fnd_global.prog_appl_id,
2736: program_id = fnd_global.conc_program_id,
2737: program_update_date = SYSDATE
2738: WHERE WDD.Delivery_Detail_Id = l_del_detail_id_tab(i)
2739: AND WDD.Container_Flag = 'Y'; -- To make sure that we are updating container records

Line 2736: program_id = fnd_global.conc_program_id,

2732: last_update_date = SYSDATE,
2733: last_updated_by = fnd_global.user_id,
2734: last_update_login = fnd_global.conc_login_id,
2735: program_application_id = fnd_global.prog_appl_id,
2736: program_id = fnd_global.conc_program_id,
2737: program_update_date = SYSDATE
2738: WHERE WDD.Delivery_Detail_Id = l_del_detail_id_tab(i)
2739: AND WDD.Container_Flag = 'Y'; -- To make sure that we are updating container records
2740:

Line 2764: last_updated_by = fnd_global.user_id,

2760:
2761: UPDATE WSH_PICKING_RULES WPR
2762: SET ship_to_location_id = l_to_location_id,
2763: last_update_date = SYSDATE,
2764: last_updated_by = fnd_global.user_id,
2765: last_update_login = fnd_global.conc_login_id,
2766: program_application_id = fnd_global.prog_appl_id,
2767: program_id = fnd_global.conc_program_id,
2768: program_update_date = SYSDATE

Line 2765: last_update_login = fnd_global.conc_login_id,

2761: UPDATE WSH_PICKING_RULES WPR
2762: SET ship_to_location_id = l_to_location_id,
2763: last_update_date = SYSDATE,
2764: last_updated_by = fnd_global.user_id,
2765: last_update_login = fnd_global.conc_login_id,
2766: program_application_id = fnd_global.prog_appl_id,
2767: program_id = fnd_global.conc_program_id,
2768: program_update_date = SYSDATE
2769: WHERE ship_to_location_id = l_from_location_id

Line 2766: program_application_id = fnd_global.prog_appl_id,

2762: SET ship_to_location_id = l_to_location_id,
2763: last_update_date = SYSDATE,
2764: last_updated_by = fnd_global.user_id,
2765: last_update_login = fnd_global.conc_login_id,
2766: program_application_id = fnd_global.prog_appl_id,
2767: program_id = fnd_global.conc_program_id,
2768: program_update_date = SYSDATE
2769: WHERE ship_to_location_id = l_from_location_id
2770: AND EXISTS

Line 2767: program_id = fnd_global.conc_program_id,

2763: last_update_date = SYSDATE,
2764: last_updated_by = fnd_global.user_id,
2765: last_update_login = fnd_global.conc_login_id,
2766: program_application_id = fnd_global.prog_appl_id,
2767: program_id = fnd_global.conc_program_id,
2768: program_update_date = SYSDATE
2769: WHERE ship_to_location_id = l_from_location_id
2770: AND EXISTS
2771: ( SELECT 'X'