PACKAGE: APPS.AP_WEB_DB_SCHLINE_PKG

Source

1 PACKAGE AP_WEB_DB_SCHLINE_PKG AS
2 /* $Header: apwdbscs.pls 120.2 2005/11/20 20:07:13 abordia noship $ */
3 
4 TYPE ScheduleLinesCursor	IS REF CURSOR;
5 
6 TYPE Schedule_Line_Rec IS RECORD (
7         RANGE_HIGH			AP_POL_LINES.RANGE_HIGH%TYPE,
8         RANGE_LOW			AP_POL_LINES.RANGE_LOW%TYPE,
9         START_DATE			AP_POL_SCHEDULE_PERIODS.START_DATE%TYPE,
10         END_DATE			AP_POL_SCHEDULE_PERIODS.END_DATE%TYPE,
11         RATE				AP_POL_LINES.RATE%TYPE,
12         RATE_PER_PASSENGER              AP_POL_SCHEDULE_PERIODS.RATE_PER_PASSENGER%TYPE);
13 
14 TYPE Schedule_Line_Array IS TABLE OF Schedule_Line_Rec
15         INDEX BY BINARY_INTEGER;
16 
17 
18 FUNCTION GetScheduleLinesCursor(
19 	p_policy_id		IN	NUMBER,
20 	p_vehicle_category_code	IN	VARCHAR2,
21 	p_vehicle_type		IN	VARCHAR2,
22 	p_fuel_type		IN	VARCHAR2,
23 	p_currency_code		IN	VARCHAR2,
24 	p_employee_id		IN	NUMBER,
25 	p_start_expense_date	IN	DATE,
26 	p_schedule_lines_cursor OUT NOCOPY ScheduleLinesCursor)
27 RETURN BOOLEAN;
28 -------------------------------------------------------------------------------
29 PROCEDURE getSchHeaderInfo(
30 	p_policy_id	   IN  ap_pol_headers.policy_id%TYPE,
31 	p_sh_distance_uom  OUT NOCOPY ap_pol_headers.distance_uom%TYPE,
32 	p_sh_currency_code OUT NOCOPY ap_pol_headers.currency_code%TYPE,
33         p_sh_distance_thresholds_flag OUT NOCOPY ap_pol_headers.DISTANCE_THRESHOLDS_FLAG%TYPE);
34 --------------------------------------------------------------------------------
35 
36 END AP_WEB_DB_SCHLINE_PKG;