PACKAGE: APPS.PQH_PQHUSASR_XMLP_PKG

Source

1 PACKAGE PQH_PQHUSASR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PQHUSASRS.pls 120.1 2007/12/07 06:48:42 vjaganat noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   P_PERSON_ID NUMBER;
8 
9   P_NOTIFICATION_TYPE VARCHAR2(32767);
10 
11   P_DATE_FORMAT VARCHAR2(32767);
12 
13   CP_BUSINESS_GROUP_NAME VARCHAR2(240);
14 
15   CP_BODY_TEXT1 VARCHAR2(2000);
16 
17   CP_FACULTY_MEMBER_NAME VARCHAR2(240);
18 
19   CP_FACULTY_MEMBER_EMAIL VARCHAR2(240);
20 
21   CP_FACULTY_MEMBER_ADDRESS VARCHAR2(1000);
22 
23   CP_FACULTY_MEMBER_TITLE VARCHAR2(240);
24 
25   CP_ACADEMIC_MANAGER_NAME VARCHAR2(240);
26 
27   CP_ACADEMIC_MANAGER_EMAIL VARCHAR2(240);
28 
29   CP_ACADEMIC_MANAGER_ADDRESS VARCHAR2(1000);
30 
31   CP_LOGGED_USER_NAME VARCHAR2(240);
32 
33   CP_CONTRACT_START_DATE VARCHAR2(20);
34 
35   CP_FACULTY_MEMBER_LNAME VARCHAR2(150);
36 
37   CP_REGARDS VARCHAR2(100);
38 
39   CP_BODY_TEXT2 VARCHAR2(2000);
40 
41   CP_BODY_TEXT3 VARCHAR2(2000);
42 
43   CP_BODY_TEXT4 VARCHAR2(2000);
44 
45   CP_BODY_TEXT5 VARCHAR2(2000);
46 
47   CP_ACADEMIC_RANK VARCHAR2(240);
48 
49   FUNCTION BEFOREREPORT RETURN BOOLEAN;
50 
51   FUNCTION AFTERREPORT RETURN BOOLEAN;
52 
53   FUNCTION CP_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
54 
55   FUNCTION CP_BODY_TEXT1_P RETURN VARCHAR2;
56 
57   FUNCTION CP_FACULTY_MEMBER_NAME_P RETURN VARCHAR2;
58 
59   FUNCTION CP_FACULTY_MEMBER_EMAIL_P RETURN VARCHAR2;
60 
61   FUNCTION CP_FACULTY_MEMBER_ADDRESS_P RETURN VARCHAR2;
62 
63   FUNCTION CP_FACULTY_MEMBER_TITLE_P RETURN VARCHAR2;
64 
65   FUNCTION CP_ACADEMIC_MANAGER_NAME_P RETURN VARCHAR2;
66 
67   FUNCTION CP_ACADEMIC_MANAGER_EMAIL_P RETURN VARCHAR2;
68 
69   FUNCTION CP_ACADEMIC_MANAGER_ADDRESS_P RETURN VARCHAR2;
70 
71   FUNCTION CP_LOGGED_USER_NAME_P RETURN VARCHAR2;
72 
73   FUNCTION CP_CONTRACT_START_DATE_P RETURN VARCHAR2;
74 
75   FUNCTION CP_FACULTY_MEMBER_LNAME_P RETURN VARCHAR2;
76 
77   FUNCTION CP_REGARDS_P RETURN VARCHAR2;
78 
79   FUNCTION CP_BODY_TEXT2_P RETURN VARCHAR2;
80 
81   FUNCTION CP_BODY_TEXT3_P RETURN VARCHAR2;
82 
83   FUNCTION CP_BODY_TEXT4_P RETURN VARCHAR2;
84 
85   FUNCTION CP_BODY_TEXT5_P RETURN VARCHAR2;
86 
87   FUNCTION CP_ACADEMIC_RANK_P RETURN VARCHAR2;
88 
89   FUNCTION_DESC VARCHAR2(240);
90 
91   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
92 
93 END PQH_PQHUSASR_XMLP_PKG;