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