DBA Data[Home] [Help]

APPS.FTE_LANE_PKG dependencies on FTE_LANE_RATE_CHARTS

Line 38: lane_id fte_lane_rate_charts.lane_id%TYPE,

34: lane_rec
35: INDEX BY BINARY_INTEGER;
36:
37: TYPE lane_rate_chart_rec IS RECORD (
38: lane_id fte_lane_rate_charts.lane_id%TYPE,
39: list_header_id fte_lane_rate_charts.list_header_id%TYPE,
40: start_date_active fte_lane_rate_charts.start_date_active%TYPE,
41: end_date_active fte_lane_rate_charts.end_date_active%TYPE);
42:

Line 39: list_header_id fte_lane_rate_charts.list_header_id%TYPE,

35: INDEX BY BINARY_INTEGER;
36:
37: TYPE lane_rate_chart_rec IS RECORD (
38: lane_id fte_lane_rate_charts.lane_id%TYPE,
39: list_header_id fte_lane_rate_charts.list_header_id%TYPE,
40: start_date_active fte_lane_rate_charts.start_date_active%TYPE,
41: end_date_active fte_lane_rate_charts.end_date_active%TYPE);
42:
43: TYPE lane_rate_chart_tbl IS TABLE OF

Line 40: start_date_active fte_lane_rate_charts.start_date_active%TYPE,

36:
37: TYPE lane_rate_chart_rec IS RECORD (
38: lane_id fte_lane_rate_charts.lane_id%TYPE,
39: list_header_id fte_lane_rate_charts.list_header_id%TYPE,
40: start_date_active fte_lane_rate_charts.start_date_active%TYPE,
41: end_date_active fte_lane_rate_charts.end_date_active%TYPE);
42:
43: TYPE lane_rate_chart_tbl IS TABLE OF
44: lane_rate_chart_rec

Line 41: end_date_active fte_lane_rate_charts.end_date_active%TYPE);

37: TYPE lane_rate_chart_rec IS RECORD (
38: lane_id fte_lane_rate_charts.lane_id%TYPE,
39: list_header_id fte_lane_rate_charts.list_header_id%TYPE,
40: start_date_active fte_lane_rate_charts.start_date_active%TYPE,
41: end_date_active fte_lane_rate_charts.end_date_active%TYPE);
42:
43: TYPE lane_rate_chart_tbl IS TABLE OF
44: lane_rate_chart_rec
45: INDEX BY BINARY_INTEGER;

Line 226: -- 1. p_list_header_id: the rate chart to update in fte_lane_rate_charts

222: --
223: -- Purpose: update lane rate chart's dates
224: --
225: -- IN parameters:
226: -- 1. p_list_header_id: the rate chart to update in fte_lane_rate_charts
227: -- 2. p_start_date: start date
228: -- 3. p_end_date: end date
229: --
230: -- OUT parameters: