DBA Data[Home] [Help]

APPS.FTE_SERVICES_UI_WRAPPER dependencies on FTE_LANE_PKG

Line 421: l_lane_tbl FTE_LANE_PKG.lane_tbl;

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:

Line 422: l_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;

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;

Line 423: l_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;

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:

Line 424: l_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;

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;

Line 449: l_lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;

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';

Line 494: l_lane_service_tbl(i).lane_service_id := FTE_LANE_PKG.get_next_lane_service_id;

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

Line 583: FTE_LANE_PKG.insert_lane_tables(p_lane_tbl => l_lane_tbl,

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,