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_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_LOCATIONS

Line 1000: FROM wsh_locations wl,

996: IS
997:
998: CURSOR c_get_carrier(c_location_id IN NUMBER) IS
999: SELECT wc.carrier_id
1000: FROM wsh_locations wl,
1001: hz_party_sites hps,
1002: hz_parties hp,
1003: wsh_carriers wc
1004: WHERE wl.wsh_location_id = c_location_id

Line 1088: FROM wsh_locations wl,

1084: IS
1085:
1086: CURSOR c_get_customer(c_location_id IN NUMBER) IS
1087: SELECT hcas.cust_account_id
1088: FROM wsh_locations wl,
1089: hz_party_sites hps,
1090: hz_cust_acct_sites_all hcas
1091: WHERE wl.wsh_location_id = c_location_id
1092: AND wl.location_source_code = 'HZ'

Line 1289: wsh_locations wl

1285: FROM hz_parties hz,
1286: po_vendors po,
1287: hz_relationships rel,
1288: hz_party_sites hps,
1289: wsh_locations wl
1290: WHERE wl.wsh_location_id = c_location_id
1291: AND wl.location_source_code = 'HZ'
1292: AND wl.source_location_id = hps.location_id
1293: AND rel.relationship_type = 'POS_VENDOR_PARTY'

Line 9177: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

9173: --Made the changes outside if condition.
9174:
9175: --#DUM_LOC(S)
9176: --Check if ultimate drop off location is a dummy location
9177: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
9178: p_internal_cust_location_id => l_ultimate_do_loc_id,
9179: x_internal_org_location_id => l_physical_location_id,
9180: x_return_status => l_return_status);
9181:

Line 11785: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

11781: -- Delivery's ultimate_dropoff_location_id to be converted to physical internal
11782: -- location if it is a dummy location.
11783: -- We have to use the API for this purpose.
11784:
11785: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
11786: p_internal_cust_location_id => l_delivery_info(i).ultimate_dropoff_location_id,
11787: x_internal_org_location_id => l_physical_location_id,
11788: x_return_status => l_return_status);
11789:

Line 11885: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

11881: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_info(i).ultimate_dropoff_location_id : '||l_delivery_info(i).ultimate_dropoff_location_id);
11882: END IF;
11883: --
11884: --#DUM_LOC(S)
11885: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
11886: p_internal_cust_location_id => l_delivery_info(i).ultimate_dropoff_location_id,
11887: x_internal_org_location_id => l_physical_location_id,
11888: x_return_status => l_return_status);
11889:

Line 12004: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12000: --#DUM_LOC(S)
12001: -- Delivery detail's Dummy ship_to_location_id has to be converted to physical internal
12002: -- location
12003:
12004: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12005: p_internal_cust_location_id => l_dlvy_assigned_lines(j).ship_to_location_id,
12006: x_internal_org_location_id => l_physical_location_id,
12007: x_return_status => l_return_status);
12008:

Line 12065: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12061: l_dlvy_assigned_lines(i).line_direction := p_dlvy_assigned_lines(i).line_direction;
12062: l_dlvy_assigned_lines(i).shipping_control := nvl(p_dlvy_assigned_lines(i).shipping_control,'BUYER');
12063:
12064: --#DUM_LOC(S)
12065: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12066: p_internal_cust_location_id => l_dlvy_assigned_lines(i).ship_to_location_id,
12067: x_internal_org_location_id => l_physical_location_id,
12068: x_return_status => l_return_status);
12069:

Line 12105: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12101: FETCH c_get_trip_dlvy INTO l_delivery_rec;
12102: EXIT WHEN c_get_trip_dlvy%NOTFOUND;
12103:
12104: --#DUM_LOC(S)
12105: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12106: p_internal_cust_location_id => l_delivery_rec.ultimate_dropoff_location_id,
12107: x_internal_org_location_id => l_physical_location_id,
12108: x_return_status => l_return_status);
12109:

Line 12139: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12135: l_target_trip_assign_dels(l) := p_target_trip_assign_dels(l);
12136: -- AGDUMMY
12137:
12138: --#DUM_LOC(S)
12139: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12140: p_internal_cust_location_id => l_target_trip_assign_dels(l).ultimate_dropoff_location_id,
12141: x_internal_org_location_id => l_physical_location_id,
12142: x_return_status => l_return_status);
12143:

Line 12175: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12171: FETCH c_get_trip_details_std INTO l_detail_rec;
12172: EXIT WHEN c_get_trip_details_std%NOTFOUND;
12173:
12174: --#DUM_LOC(S)
12175: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12176: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
12177: x_internal_org_location_id => l_physical_location_id,
12178: x_return_status => l_return_status);
12179:

Line 12209: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12205: FETCH c_get_trip_details INTO l_detail_rec;
12206: EXIT WHEN c_get_trip_details%NOTFOUND;
12207:
12208: --#DUM_LOC(S)
12209: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12210: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
12211: x_internal_org_location_id => l_physical_location_id,
12212: x_return_status => l_return_status);
12213:

Line 12243: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12239: LOOP
12240: l_target_trip_dlvy_lines(l) := p_target_trip_dlvy_lines(l);
12241:
12242: --#DUM_LOC(S)
12243: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12244: p_internal_cust_location_id => l_target_trip_dlvy_lines(l).ship_to_location_id,
12245: x_internal_org_location_id => l_physical_location_id,
12246: x_return_status => l_return_status);
12247:

Line 12350: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12346:
12347: -- #DUM_LOC(S)
12348: -- p_target_tripstops.PICKUP_LOCATION_ID
12349:
12350: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12351: p_internal_cust_location_id => p_target_tripstops.pickup_location_id,
12352: x_internal_org_location_id => l_physical_location_id,
12353: x_return_status => l_return_status);
12354:

Line 12372: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12368: END IF;
12369:
12370: -- p_target_tripstops.DROPOFF_LOCATION_ID
12371:
12372: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12373: p_internal_cust_location_id => p_target_tripstops.dropoff_location_id,
12374: x_internal_org_location_id => l_physical_location_id,
12375: x_return_status => l_return_status);
12376:

Line 13305: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13301: -- TODO
13302:
13303: --#DUM_LOC(S)
13304: --Check if ultimate drop off location is a dummy location
13305: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13306: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
13307: x_internal_org_location_id => l_physical_location_id,
13308: x_return_status => l_return_status);
13309:

Line 13343: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13339: -- TODO
13340:
13341: --#DUM_LOC(S)
13342: --Check if ultimate drop off location is a dummy location
13343: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13344: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
13345: x_internal_org_location_id => l_physical_location_id,
13346: x_return_status => l_return_status);
13347:

Line 13380: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13376: -- TODO
13377:
13378: --#DUM_LOC(S)
13379: --Check if ultimate drop off location is a dummy location
13380: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13381: p_internal_cust_location_id => l_dleg_dlvy_rec.ultimate_dropoff_location_id,
13382: x_internal_org_location_id => l_physical_location_id,
13383: x_return_status => l_return_status);
13384:

Line 13409: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13405: --#DUM_LOC(S)
13406: --Check if input dleg's drop off location is a dummy location
13407: l_delivery_leg_rec := p_delivery_leg_rec;
13408:
13409: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13410: p_internal_cust_location_id => p_delivery_leg_rec.dropoffstop_location_id,
13411: x_internal_org_location_id => l_physical_location_id,
13412: x_return_status => l_return_status);
13413:

Line 13907: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13903: -- TODO
13904:
13905: --#DUM_LOC(S)
13906: --Check if ultimate drop off location is a dummy location
13907: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13908: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
13909: x_internal_org_location_id => l_physical_location_id,
13910: x_return_status => l_return_status);
13911:

Line 13945: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13941: -- TODO
13942:
13943: --#DUM_LOC(S)
13944: --Check if ultimate drop off location is a dummy location
13945: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13946: p_internal_cust_location_id => l_dlvy_rec.ultimate_dropoff_location_id,
13947: x_internal_org_location_id => l_physical_location_id,
13948: x_return_status => l_return_status);
13949:

Line 14582: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14578: FETCH c_get_line_details into l_del_detail_info(i);
14579: CLOSE c_get_line_details;
14580:
14581: --#DUM_LOC(S)
14582: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14583: p_internal_cust_location_id => l_del_detail_info(i).ship_to_location_id,
14584: x_internal_org_location_id => l_physical_location_id,
14585: x_return_status => l_return_status);
14586:

Line 14646: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14642: l_del_detail_info(i).SHIPPING_CONTROL := nvl(p_del_detail_info(i).SHIPPING_CONTROL,'BUYER');
14643: l_del_detail_info(i).ORGANIZATION_ID := p_del_detail_info(i).ORGANIZATION_ID;
14644:
14645: --#DUM_LOC(S)
14646: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14647: p_internal_cust_location_id => l_del_detail_info(i).ship_to_location_id,
14648: x_internal_org_location_id => l_physical_location_id,
14649: x_return_status => l_return_status);
14650:

Line 14684: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14680: FETCH c_get_dlvy into l_target_delivery;
14681: CLOSE c_get_dlvy;
14682:
14683: --#DUM_LOC(S)
14684: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14685: p_internal_cust_location_id => l_target_delivery.ultimate_dropoff_location_id,
14686: x_internal_org_location_id => l_physical_location_id,
14687: x_return_status => l_return_status);
14688:

Line 14718: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14714: FETCH c_get_line_details into l_target_container;
14715: CLOSE c_get_line_details;
14716:
14717: --#DUM_LOC(S)
14718: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14719: p_internal_cust_location_id => l_target_container.ship_to_location_id,
14720: x_internal_org_location_id => l_physical_location_id,
14721: x_return_status => l_return_status);
14722:

Line 14755: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14751: FETCH c_get_details INTO l_detail_rec;
14752: EXIT WHEN c_get_details%NOTFOUND;
14753:
14754: --#DUM_LOC(S)
14755: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14756: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
14757: x_internal_org_location_id => l_physical_location_id,
14758: x_return_status => l_return_status);
14759:

Line 14788: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14784: FETCH c_get_details_consol INTO l_detail_rec;
14785: EXIT WHEN c_get_details%NOTFOUND;
14786:
14787: --#DUM_LOC(S)
14788: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14789: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
14790: x_internal_org_location_id => l_physical_location_id,
14791: x_return_status => l_return_status);
14792:

Line 14825: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14821: FETCH c_get_assigned_lines_cont INTO l_detail_rec;
14822: EXIT WHEN c_get_assigned_lines_cont%NOTFOUND;
14823:
14824: --#DUM_LOC(S)
14825: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14826: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
14827: x_internal_org_location_id => l_physical_location_id,
14828: x_return_status => l_return_status);
14829:

Line 14889: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14885: l_dlvy_assigned_lines(i).LINE_DIRECTION := p_dlvy_assigned_lines(i).LINE_DIRECTION;
14886: l_dlvy_assigned_lines(i).SHIPPING_CONTROL := nvl(p_dlvy_assigned_lines(i).SHIPPING_CONTROL,'BUYER');
14887:
14888: --#DUM_LOC(S)
14889: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14890: p_internal_cust_location_id => l_dlvy_assigned_lines(i).ship_to_location_id,
14891: x_internal_org_location_id => l_physical_location_id,
14892: x_return_status => l_return_status);
14893:

Line 15820: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

15816: FETCH c_get_trip_dlvy INTO l_delivery_rec;
15817: EXIT WHEN c_get_trip_dlvy%NOTFOUND;
15818:
15819: --#DUM_LOC(S)
15820: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
15821: p_internal_cust_location_id => l_delivery_rec.ultimate_dropoff_location_id,
15822: x_internal_org_location_id => l_physical_location_id,
15823: x_return_status => l_return_status);
15824:

Line 15856: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

15852: LOOP
15853: FETCH c_get_trip_details_std INTO l_detail_rec;
15854: EXIT WHEN c_get_trip_details_std%NOTFOUND;
15855: --#DUM_LOC(S)
15856: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
15857: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
15858: x_internal_org_location_id => l_physical_location_id,
15859: x_return_status => l_return_status);
15860:

Line 15912: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

15908: LOOP
15909: l_trip_assigned_dels(l) := p_trip_assigned_dels(l);
15910:
15911: --#DUM_LOC(S)
15912: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
15913: p_internal_cust_location_id => l_trip_assigned_dels(l).ultimate_dropoff_location_id,
15914: x_internal_org_location_id => l_physical_location_id,
15915: x_return_status => l_return_status);
15916:

Line 15947: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

15943: l := p_trip_dlvy_lines.FIRST;
15944: LOOP
15945: l_trip_dlvy_lines(l) := p_trip_dlvy_lines(l);
15946: --#DUM_LOC(S)
15947: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
15948: p_internal_cust_location_id => l_trip_dlvy_lines(l).ship_to_location_id,
15949: x_internal_org_location_id => l_physical_location_id,
15950: x_return_status => l_return_status);
15951:

Line 18336: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

18332: -- Delivery's ultimate_dropoff_location_id to be converted to physical internal
18333: -- location if it is a dummy location.
18334: -- We have to use the API for this purpose.
18335:
18336: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
18337: p_internal_cust_location_id => p_delivery_info(i).ultimate_dropoff_location_id,
18338: x_internal_org_location_id => l_physical_location_id,
18339: x_return_status => l_return_status);
18340: