APPS.FTE_LTL_LOADER dependencies on FTE_PRC_PARAMETERS

Line 523: INSERT INTO fte_prc_parameters(value_from,

519: BEGIN
520: FTE_UTIL_PKG.Enter_Debug(l_module_name);
521:
522: FORALL i IN 1..PRC_LANE_ID.COUNT
523: INSERT INTO fte_prc_parameters(value_from,
524: uom_code,
525: currency_code,
526: parameter_instance_id,
527: lane_id,

Line 537: FTE_PRC_PARAMETERS_S.NEXTVAL,

533: last_update_login)
534: VALUES(PRC_VALUE_FROM(i),
535: G_LTL_UOM,
536: G_LTL_CURRENCY,
537: FTE_PRC_PARAMETERS_S.NEXTVAL,
538: PRC_LANE_ID(i),
539: PRC_PARAMETER_ID(i),
540: G_USER_ID,
541: SYSDATE,

Line 664: fte_prc_parameters prc

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
667: l.lane_type = 'LTL_' || p_tariff_name || '_' || p_load_number AND
668: l.lane_id = prc.lane_id AND

Line 2093: -- FTE_PRC_PARAMETERS

2089: LRC_LIST_HEADER_ID(lrc_list_header_id.COUNT+1) := p_list_header_id;
2090: LRC_START_DATE(lrc_start_date.COUNT+1) := G_VALID_DATE;
2091: LRC_END_DATE(lrc_end_date.COUNT+1) := NULL;
2092:
2093: -- FTE_PRC_PARAMETERS
2094:
2095: -- Deficit Weight Breaks
2096: l_deficit_wt_breaks := STRINGARRAY('0', '500', '1000', '2000', '5000', '10000', '20000', '30000', '40000');
2097:

Line 4647: fte_prc_parameters prc

4643: prc.value_from
4644: FROM
4645: fte_lanes l,
4646: fte_lane_rate_charts lrc,
4647: fte_prc_parameters prc
4648: WHERE
4649: l.tariff_name = p_tariff_name AND
4650: l.LANE_ID = lrc.LANE_ID AND
4651: prc.LANE_ID = l.LANE_ID AND