PACKAGE: APPS.OTA_OTARPATT_XMLP_PKG

Source

1 PACKAGE OTA_OTARPATT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OTARPATTS.pls 120.1.12020000.2 2012/11/02 05:30:27 jaysridh ship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	date;
5 	LP_SESSION_DATE varchar2(15);
6 	P_REPORT_TITLE	varchar2(60);
7 	P_CONC_REQUEST_ID	number;
8 	P_COURSE_START_DATE	varchar2(32767);
9 	P_COURSE_END_DATE	varchar2(32767);
10 	P_TRAINING_CENTER_ID	number;
11 	P_EVENT_ID	number;
12 	P_Business	varchar2(80);
13 	P_OPTIONAL_COLUMN	varchar2(15);
14 	P_AND	varchar2(2000);
15 	P_trainer_and	varchar2(1000);
16 	P_display_pmt_conf	varchar2(1);
17 	P_booking_id	number;
18 	P_display_trainer_signature	varchar2(1);
19         P_DISPLAY_PMT_CONF_MEAN varchar2(80);
20         P_DISPLAY_TRAINER_SIG_MEAN varchar2(80);
21 	P_EVENT_NAME	varchar2(80);
22 	P_TRAINING_CENTER_NAME	varchar2(60);
23 	CP_venue	varchar2(500);
24 	C_BUSINESS_GROUP_NAME	varchar2(240);
25 	C_REPORT_SUBTITLE	varchar2(60);
26 	C_EVENT_TITLE	varchar2(80);
27 	CP_course_start_date	varchar2(20);
28 	CP_course_end_date	varchar2(20);
29 	function BeforeReport return boolean  ;
30 	function CF_OPTIONAL_COLUMNFormula return Char  ;
31 	FUNCTION AfterPForm
32   RETURN BOOLEAN
33  ;
34 	function cf_venueformula
35   (event_id in number) return char
36  ;
37 	function CF_course_end_dateFormula return Char  ;
38 	function CF_course_start_dateFormula return Char  ;
39 	function CF_BG_NAMEFormula return Char  ;
40 	function AfterReport return boolean  ;
41 	Function CP_venue_p return varchar2;
42 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
43 	Function C_REPORT_SUBTITLE_p return varchar2;
44 	Function C_EVENT_TITLE_p return varchar2;
45 	Function CP_course_start_date_p return varchar2;
46 	Function CP_course_end_date_p return varchar2;
47         Function cf_yes_no_meaning(p_code varchar2) return varchar2;
48 END OTA_OTARPATT_XMLP_PKG;