PACKAGE: APPS.OTA_OTARPSIS_XMLP_PKG

Source

1 PACKAGE OTA_OTARPSIS_XMLP_PKG AS
2 /* $Header: OTARPSISS.pls 120.1 2007/12/07 06:01:07 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	varchar2(30);
5 	P_REPORT_TITLE	varchar2(60) := 'Learner Sign-In Sheet (by Organization or Company)';
6 	P_CONC_REQUEST_ID	number;
7 	P_COURSE_START_DATE	varchar2(32767);
8 	P_COURSE_END_DATE	varchar2(32767);
9 	P_TRAINING_CENTER_ID	number;
10 	P_EVENT_ID	number;
11 	P_Business	varchar2(80);
12 	P_OPTIONAL_COLUMN	varchar2(15);
13 	P_AND	varchar2(2000);
14 	P_trainer_and	varchar2(1000);
15 	P_display_pmt_conf	varchar2(1);
16 	P_booking_id	number;
17 	P_display_trainer_signature	varchar2(1);
18 	P_EVENT_NAME	varchar2(80);
19 	P_TRAINING_CENTER_NAME	varchar2(60);
20 	CP_venue	varchar2(500);
21 	C_BUSINESS_GROUP_NAME	varchar2(240);
22 	C_REPORT_SUBTITLE	varchar2(60);
23 	C_EVENT_TITLE	varchar2(80);
24 	CP_course_start_date	varchar2(20);
25 	CP_course_end_date	varchar2(20);
26 	function BeforeReport return boolean  ;
27 	function CF_OPTIONAL_COLUMNFormula return Char  ;
28 	FUNCTION AfterPForm
29   RETURN BOOLEAN
30  ;
31 	function cf_venueformula
32   (event_id in number) return char
33  ;
34 	function CF_course_end_dateFormula return Char  ;
35 	function CF_course_start_dateFormula return Char  ;
36 	function cf_event_durationformula(course_end in date, course_start in date) return number  ;
37 	function cf_sign4formula(CF_event_duration in number) return char  ;
38 	function cf_sign3formula(CF_event_duration in number) return char  ;
39 	function cf_sign2formula(CF_event_duration in number) return char  ;
40 	function cf_sign1formula(CF_event_duration in number) return char  ;
41 	function CF_BG_NAMEFormula return Char  ;
42 	function AfterReport return boolean  ;
43 	Function CP_venue_p return varchar2;
44 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
45 	Function C_REPORT_SUBTITLE_p return varchar2;
46 	Function C_EVENT_TITLE_p return varchar2;
47 	Function CP_course_start_date_p return varchar2;
48 	Function CP_course_end_date_p return varchar2;
49 END OTA_OTARPSIS_XMLP_PKG;