APPS.FTE_LTL_LOADER dependencies on FTE_LANE_COMMODITIES

Line 578: INSERT INTO FTE_LANE_COMMODITIES(lane_commodity_id,

574: FTE_UTIL_PKG.Enter_Debug(l_module_name);
575:
576: FORALL i IN 1..CM_LANE_ID.COUNT
577:
578: INSERT INTO FTE_LANE_COMMODITIES(lane_commodity_id,
579: lane_id,
580: commodity_catg_id,
581: created_by,
582: creation_date,

Line 2051: -- FTE_LANE_COMMODITIES

2047: FOR k IN 1..p_carrier_ids.COUNT LOOP
2048:
2049: SELECT fte_lanes_s.NEXTVAL INTO l_lane_id FROM DUAL;
2050:
2051: -- FTE_LANE_COMMODITIES
2052: FOR m IN 1..p_category_ids.COUNT LOOP
2053: CM_LANE_ID(cm_lane_id.COUNT+1) := l_lane_id;
2054: CM_CATG_ID(cm_catg_id.COUNT+1) := p_category_ids(m);
2055: END LOOP;

Line 2059: -- in FTE_LANES to null and store everything in FTE_LANE_COMMODITIES.

2055: END LOOP;
2056:
2057: --+
2058: -- If we have more than one commodity on the lane, we need to set the commodity
2059: -- in FTE_LANES to null and store everything in FTE_LANE_COMMODITIES.
2060: --+
2061: IF p_category_ids.COUNT > 1 THEN
2062: l_catg_id := NULL;
2063: END IF;

Line 4662: fte_lane_commodities

4658: CURSOR GET_LANE_COMMODITIES (p_lane_id IN NUMBER) IS
4659: SELECT
4660: commodity_catg_id
4661: FROM
4662: fte_lane_commodities
4663: WHERE
4664: lane_id = p_lane_id;
4665:
4666: CURSOR GET_PREVIOUS_REGIONS_INFO (p_tariff_name IN VARCHAR2,