PACKAGE: APPS.OTA_OTARPBUD_XMLP_PKG

Source

1 PACKAGE OTA_OTARPBUD_XMLP_PKG AS
2 /* $Header: OTARPBUDS.pls 120.1 2007/12/07 05:59:44 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	date;
5 	LP_SESSION_DATE	date;
6 	P_REPORT_TITLE	varchar2(60);
7 	P_CONC_REQUEST_ID	number;
8 	P_TRANSFER_STATUS	varchar2(40);
9 	P_PRICE	varchar2(40);
10 	P_RESOURCE_BOOKING_STATUS	varchar2(40);
11 	P_PAYMENT_STATUS	varchar2(40);
12 	P_DISPLAY_MODE	varchar2(40);
13 	P_COURSE_START_DATE	varchar2(32767);
14 	P_COURSE_END_DATE	varchar2(32767);
15 	P_DELEGATE_BOOKING_CURRENCY	varchar2(40);
16 	P_RESOURCE_BOOKING_CURRENCY	varchar2(40);
17 	P_ACTIVITY_ID	varchar2(40);
18 	P_ACTIVITY_VERSION_ID	varchar2(40);
19 	P_EVENT_ID	varchar2(40);
20 	P_PROGRAM_ID	varchar2(40);
21 	P_revenue_display_currency	varchar2(4);
22 	P_delegate_display_currency	varchar2(32767);
23 	P_Business	varchar2(80);
24 	CP_rev_curr	number := 0 ;
25 	CP_cost_curr	number := 0 ;
26 	CP_Venue	varchar2(500);
27 	CP_prev_event	number;
28 	CP_conv	number := 0 ;
29 	CP_prev_event2	number;
30 	CP_conv1	number := 0 ;
31 	C_BUSINESS_GROUP_NAME	varchar2(60);
32 	C_REPORT_SUBTITLE	varchar2(60);
33 	C_ACTIVITY_NAME	varchar2(80);
34 	C_ACTIVITY_VERSION_NAME	varchar2(80);
35 	C_EVENT_TITLE	varchar2(80);
36 	C_PROGRAM_NAME	varchar2(80);
37 	CP_transfer_status	varchar2(80);
38 	CP_resource_booking_status	varchar2(80);
39 	function BeforeReport return boolean  ;
40 	function CF_eff_dateFormula return Date  ;
41 	function cf_conv_amountformula(event_id in number, currency_code1 in varchar2, money_amount in number, cf_eff_date in date, cf_currency_type in varchar2) return number  ;
42 	function cf_conv1formula(event_id in number, currency_code3 in varchar2, money_amount2 in number, cf_eff_date in date, cf_currency_type in varchar2) return number  ;
43 	function cf_currency_typeformula(cf_eff_date in date) return varchar2  ;
44 	function cf_venueformula
45   (event_id in number) return char
46  ;
47 	function AfterPForm return boolean  ;
48 	function AfterReport return boolean  ;
49 	Function CP_rev_curr_p return number;
50 	Function CP_cost_curr_p return number;
51 	Function CP_Venue_p return varchar2;
52 	Function CP_prev_event_p return number;
53 	Function CP_conv_p return number;
54 	Function CP_prev_event2_p return number;
55 	Function CP_conv1_p return number;
56 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
57 	Function C_REPORT_SUBTITLE_p return varchar2;
58 	Function C_ACTIVITY_NAME_p return varchar2;
59 	Function C_ACTIVITY_VERSION_NAME_p return varchar2;
60 	Function C_EVENT_TITLE_p return varchar2;
61 	Function C_PROGRAM_NAME_p return varchar2;
62 	Function CP_transfer_status_p return varchar2;
63 	Function CP_resource_booking_status_p return varchar2;
64 END OTA_OTARPBUD_XMLP_PKG;