PACKAGE: APPS.OTA_OTARPSIS_XMLP_PKG

Source

1 PACKAGE OTA_OTARPSIS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OTARPSISS.pls 120.1.12020000.2 2012/11/06 07:23:32 jaysridh ship $ */
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         P_DISPLAY_PMT_CONF_MEAN varchar2(80);
21         P_DISPLAY_TRAINER_SIG_MEAN varchar2(80);
22 	CP_venue	varchar2(500);
23 	C_BUSINESS_GROUP_NAME	varchar2(240);
24 	C_REPORT_SUBTITLE	varchar2(60);
25 	C_EVENT_TITLE	varchar2(80);
26 	CP_course_start_date	varchar2(20);
27 	CP_course_end_date	varchar2(20);
28 	function BeforeReport return boolean  ;
29 	function CF_OPTIONAL_COLUMNFormula return Char  ;
30 	FUNCTION AfterPForm
31   RETURN BOOLEAN
32  ;
33 	function cf_venueformula
34   (event_id in number) return char
35  ;
36 	function CF_course_end_dateFormula return Char  ;
37 	function CF_course_start_dateFormula return Char  ;
38 	function cf_event_durationformula(course_end in date, course_start in date) return number  ;
39 	function cf_sign4formula(CF_event_duration in number) return char  ;
40 	function cf_sign3formula(CF_event_duration in number) return char  ;
41 	function cf_sign2formula(CF_event_duration in number) return char  ;
42 	function cf_sign1formula(CF_event_duration in number) return char  ;
43 	function CF_BG_NAMEFormula return Char  ;
44 	function AfterReport return boolean  ;
45 	Function CP_venue_p return varchar2;
46 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
47 	Function C_REPORT_SUBTITLE_p return varchar2;
48 	Function C_EVENT_TITLE_p return varchar2;
49 	Function CP_course_start_date_p return varchar2;
50 	Function CP_course_end_date_p return varchar2;
51         Function cf_yes_no_meaning(p_code varchar2) return varchar2;
52 END OTA_OTARPSIS_XMLP_PKG;