417: P_RATE_CHART_LINE_TABLE IN rate_chart_line_table,
418: X_STATUS OUT NOCOPY NUMBER,
419: X_ERROR_MSG OUT NOCOPY VARCHAR2) IS
420:
421: l_lane_tbl FTE_LANE_PKG.lane_tbl;
422: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
423: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
424: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
425:
418: X_STATUS OUT NOCOPY NUMBER,
419: X_ERROR_MSG OUT NOCOPY VARCHAR2) IS
420:
421: l_lane_tbl FTE_LANE_PKG.lane_tbl;
422: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
423: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
424: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
425:
426: l_lane_id NUMBER;
419: X_ERROR_MSG OUT NOCOPY VARCHAR2) IS
420:
421: l_lane_tbl FTE_LANE_PKG.lane_tbl;
422: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
423: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
424: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
425:
426: l_lane_id NUMBER;
427:
420:
421: l_lane_tbl FTE_LANE_PKG.lane_tbl;
422: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
423: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
424: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
425:
426: l_lane_id NUMBER;
427:
428: l_block_header FTE_BULKLOAD_PKG.block_header_tbl;
445:
446: IF (p_lane_table(i).LANE_ID IS NOT NULL) THEN
447: l_lane_id := p_lane_table(i).LANE_ID;
448: ELSE
449: l_lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;
450: END IF;
451:
452: IF (P_TRANSACTION_TYPE = 'CREATE') THEN
453: l_lane_tbl(i).action := 'ADD';
490:
491: -- Initialize l_lane_service_tbl
492: l_lane_service_tbl(i).lane_id := l_lane_id;
493: l_lane_service_tbl(i).service_code := P_LANE_TABLE(i).SERVICE_TYPE_CODE;
494: l_lane_service_tbl(i).lane_service_id := FTE_LANE_PKG.get_next_lane_service_id;
495:
496: END IF;
497:
498: BEGIN
579: END IF;
580:
581: END LOOP;
582:
583: FTE_LANE_PKG.insert_lane_tables(p_lane_tbl => l_lane_tbl,
584: p_lane_rate_chart_tbl => l_lane_rate_chart_tbl,
585: p_lane_commodity_tbl => l_lane_commodity_tbl,
586: p_lane_service_tbl => l_lane_service_tbl,
587: x_status => x_status,