DBA Data[Home] [Help]

PACKAGE: APPS.OTA_OTARPATT_XMLP_PKG

Source


1 PACKAGE OTA_OTARPATT_XMLP_PKG AS
2 /* $Header: OTARPATTS.pls 120.1 2007/12/07 05:59:25 amakrish noship $ */
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_EVENT_NAME	varchar2(80);
20 	P_TRAINING_CENTER_NAME	varchar2(60);
21 	CP_venue	varchar2(500);
22 	C_BUSINESS_GROUP_NAME	varchar2(240);
23 	C_REPORT_SUBTITLE	varchar2(60);
24 	C_EVENT_TITLE	varchar2(80);
25 	CP_course_start_date	varchar2(20);
26 	CP_course_end_date	varchar2(20);
27 	function BeforeReport return boolean  ;
28 	function CF_OPTIONAL_COLUMNFormula return Char  ;
29 	FUNCTION AfterPForm
30   RETURN BOOLEAN
31  ;
32 	function cf_venueformula
33   (event_id in number) return char
34  ;
35 	function CF_course_end_dateFormula return Char  ;
36 	function CF_course_start_dateFormula return Char  ;
37 	function CF_BG_NAMEFormula return Char  ;
38 	function AfterReport return boolean  ;
39 	Function CP_venue_p return varchar2;
40 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
41 	Function C_REPORT_SUBTITLE_p return varchar2;
42 	Function C_EVENT_TITLE_p return varchar2;
43 	Function CP_course_start_date_p return varchar2;
44 	Function CP_course_end_date_p return varchar2;
45 END OTA_OTARPATT_XMLP_PKG;