APPS.FTE_LTL_LOADER dependencies on WSH_REGIONS

Line 94: wsh_regions owr,

90: fte_lanes l,
91: fte_tariff_carriers tc,
92: wsh_zone_regions ozr,
93: wsh_zone_regions dzr,
94: wsh_regions owr,
95: wsh_regions dwr
96: WHERE
97: l.tariff_name = p_tariff_name AND
98: l.tariff_name = tc.tariff_name AND

Line 95: wsh_regions dwr

91: fte_tariff_carriers tc,
92: wsh_zone_regions ozr,
93: wsh_zone_regions dzr,
94: wsh_regions owr,
95: wsh_regions dwr
96: WHERE
97: l.tariff_name = p_tariff_name AND
98: l.tariff_name = tc.tariff_name AND
99: tc.action_code IN ('M', 'D') AND

Line 661: wsh_regions_tl oz,

657: FROM
658: fte_lanes l,
659: hz_parties hzp,
660: qp_list_headers_tl qlht,
661: wsh_regions_tl oz,
662: wsh_regions_tl dz,
663: fte_lane_rate_charts flrc,
664: fte_prc_parameters prc
665: WHERE

Line 662: wsh_regions_tl dz,

658: fte_lanes l,
659: hz_parties hzp,
660: qp_list_headers_tl qlht,
661: wsh_regions_tl oz,
662: wsh_regions_tl dz,
663: fte_lane_rate_charts flrc,
664: fte_prc_parameters prc
665: WHERE
666: l.tariff_name = p_tariff_name AND

Line 2399: wsh_regions w2

2395: w2.country_code
2396: FROM
2397: wsh_zone_regions w,
2398: fte_interface_zones f,
2399: wsh_regions w2
2400: WHERE
2401: w.parent_region_id = f.zone_id AND
2402: f.zone_name = p_zone_name AND
2403: w.region_id = w2.region_id;

Line 3579: -- create Zones into WSH_REGIONS, WSH_REGIONS_TL and WSH_ZONE_REGIONS

3575: l_zone_name VARCHAR2(125);
3576:
3577: --+
3578: -- This cursor is used to collect queried rows from fte_interface_zones. Those are used to
3579: -- create Zones into WSH_REGIONS, WSH_REGIONS_TL and WSH_ZONE_REGIONS
3580: --+
3581: CURSOR BULK_ZONES(p_load_id NUMBER) IS
3582: SELECT
3583: zone_name,

Line 3636: WSH_REGIONS_PKG.UPDATE_ZONE(p_insert_type => 'INSERT',

3632: IF (l_zones_temp.zone_name(l_counter) <> l_previous_name) THEN
3633: --+
3634: -- Anytime that the ZONE NAME changes we have to create a new ZONE
3635: --+
3636: WSH_REGIONS_PKG.UPDATE_ZONE(p_insert_type => 'INSERT',
3637: p_zone_id => '',
3638: p_zone_name => l_zone_name,
3639: p_zone_level => 11,
3640: p_zone_type => 11,

Line 3656: wsh_regions_tl

3652: region_id
3653: INTO
3654: l_zone_id
3655: FROM
3656: wsh_regions_tl
3657: WHERE
3658: zone = l_zone_name;
3659: END IF;
3660:

Line 3664: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Zone ID is NULL after WSH_REGIONS_PKG.Update_Zone ');

3660:
3661: IF (l_zone_id IS NULL) THEN
3662: x_status := 2;
3663: x_error_msg := 'Zone ID is NULL';
3664: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Zone ID is NULL after WSH_REGIONS_PKG.Update_Zone ');
3665: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_zone_name',l_zone_name);
3666: FTE_UTIL_PKG.Exit_Debug(l_module_name);
3667: RETURN;
3668: END IF;

Line 3719: WSH_REGIONS_PKG.UPDATE_ZONE_REGION(p_insert_type => 'INSERT',

3715: END;
3716:
3717: END IF;
3718:
3719: WSH_REGIONS_PKG.UPDATE_ZONE_REGION(p_insert_type => 'INSERT',
3720: p_zone_region_id => null,
3721: p_zone_id => l_zone_id,
3722: p_region_id => null,
3723: p_country => '',