[Home] [Help]
PACKAGE BODY: APPS.PQH_PQHUSNNT_XMLP_PKG
Source
1 PACKAGE BODY PQH_PQHUSNNT_XMLP_PKG AS
2 /* $Header: PQHUSNNTB.pls 120.2 2011/02/16 13:33:32 apjaiswa ship $ */
3 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4 L_LNAME VARCHAR2(150);
5 L_TITLE VARCHAR2(240);
6 L_EMPID VARCHAR2(30);
7 L_BODY_TEXT2 VARCHAR2(20);
8 L_BODY_TEXT3 VARCHAR2(20);
9 L_BODY_TEXT4 VARCHAR2(20);
10 L_BODY_TEXT5 VARCHAR2(20);
11 L_BODY_TEXT6 VARCHAR2(20);
12 L_BODY_TEXT7 VARCHAR2(20);
13 L_BODY_TEXT8 VARCHAR2(20);
14 L_HIREDATE DATE;
15 L_MANAGER_ID NUMBER;
16 BEGIN
17 P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
18 CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
19 CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
20 L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
21 CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
22 ,P_BUSINESS_GROUP_ID);
23 CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
24 ,P_BUSINESS_GROUP_ID);
25 PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID
26 ,L_EMPID
27 ,CP_FACULTY_MEMBER_NAME
28 ,CP_FACULTY_MEMBER_LNAME
29 ,CP_FACULTY_MEMBER_TITLE
30 ,CP_FACULTY_MEMBER_EMAIL
31 ,CP_CONTRACT_START_DATE);
32 PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID
33 ,L_EMPID
34 ,CP_ACADEMIC_MANAGER_NAME
35 ,L_LNAME
36 ,L_TITLE
37 ,CP_ACADEMIC_MANAGER_EMAIL
38 ,L_HIREDATE);
39 PQH_TENURE_DETAIL.GETREPORTBODYTEXT('NT'
40 ,CP_REGARDS
41 ,CP_BODY_TEXT
42 ,L_BODY_TEXT2
43 ,L_BODY_TEXT3
44 ,L_BODY_TEXT4
45 ,L_BODY_TEXT5
46 ,L_BODY_TEXT6
47 ,L_BODY_TEXT7
48 ,L_BODY_TEXT8);
49 CP_BODY_TEXT := REPLACE(CP_BODY_TEXT
50 ,'COLLEGE_UNIVERSITY_NAME'
51 ,CP_BUSINESS_GROUP_NAME);
52 /* Corrected and added as a part of Bug#10239077 Starts
53 CP_BODY_TEXT := REPLACE(CP_BODY_TEXT
54 ,'EFFECTIVE_DATE'
55 ,FND_DATE.DATE_TO_DISPLAYDATE(CP_CONTRACT_START_DATE)); */
56 CP_BODY_TEXT := REPLACE(CP_BODY_TEXT
57 ,'EFFECTIVE_DATE'
58 ,FND_DATE.DATE_TO_DISPLAYDATE(CP_CONTRACT_START_DATE, calendar_aware => FND_DATE.calendar_aware_alt));
59 /* Corrected and added as a part of Bug#10239077 Ends */
60 CP_BODY_TEXT := REPLACE(CP_BODY_TEXT
61 ,fnd_global.local_chr(38)
62 ,'');
63 RETURN (TRUE);
64 END BEFOREREPORT;
65
66 FUNCTION AFTERREPORT RETURN BOOLEAN IS
67 BEGIN
68 -- HR_STANDARD.EVENT('AFTER REPORT');
69 RETURN (TRUE);
70 END AFTERREPORT;
71
72 FUNCTION CP_BUSINESS_GROUP_NAME_P RETURN VARCHAR2 IS
73 BEGIN
74 RETURN CP_BUSINESS_GROUP_NAME;
75 END CP_BUSINESS_GROUP_NAME_P;
76
77 FUNCTION CP_BODY_TEXT_P RETURN VARCHAR2 IS
78 BEGIN
79 RETURN CP_BODY_TEXT;
80 END CP_BODY_TEXT_P;
81
82 FUNCTION CP_FACULTY_MEMBER_NAME_P RETURN VARCHAR2 IS
83 BEGIN
84 RETURN CP_FACULTY_MEMBER_NAME;
85 END CP_FACULTY_MEMBER_NAME_P;
86
87 FUNCTION CP_FACULTY_MEMBER_EMAIL_P RETURN VARCHAR2 IS
88 BEGIN
89 RETURN CP_FACULTY_MEMBER_EMAIL;
90 END CP_FACULTY_MEMBER_EMAIL_P;
91
92 FUNCTION CP_FACULTY_MEMBER_ADDRESS_P RETURN VARCHAR2 IS
93 BEGIN
94 RETURN CP_FACULTY_MEMBER_ADDRESS;
95 END CP_FACULTY_MEMBER_ADDRESS_P;
96
97 FUNCTION CP_FACULTY_MEMBER_TITLE_P RETURN VARCHAR2 IS
98 BEGIN
99 RETURN CP_FACULTY_MEMBER_TITLE;
100 END CP_FACULTY_MEMBER_TITLE_P;
101
102 FUNCTION CP_ACADEMIC_MANAGER_NAME_P RETURN VARCHAR2 IS
103 BEGIN
104 RETURN CP_ACADEMIC_MANAGER_NAME;
105 END CP_ACADEMIC_MANAGER_NAME_P;
106
107 FUNCTION CP_ACADEMIC_MANAGER_EMAIL_P RETURN VARCHAR2 IS
108 BEGIN
109 RETURN CP_ACADEMIC_MANAGER_EMAIL;
110 END CP_ACADEMIC_MANAGER_EMAIL_P;
111
112 FUNCTION CP_ACADEMIC_MANAGER_ADDRESS_P RETURN VARCHAR2 IS
113 BEGIN
114 RETURN CP_ACADEMIC_MANAGER_ADDRESS;
115 END CP_ACADEMIC_MANAGER_ADDRESS_P;
116
117 FUNCTION CP_LOGGED_USER_NAME_P RETURN VARCHAR2 IS
118 BEGIN
119 RETURN CP_LOGGED_USER_NAME;
120 END CP_LOGGED_USER_NAME_P;
121
122 FUNCTION CP_CONTRACT_START_DATE_P RETURN VARCHAR2 IS
123 BEGIN
124 RETURN CP_CONTRACT_START_DATE;
125 END CP_CONTRACT_START_DATE_P;
126
127 FUNCTION CP_FACULTY_MEMBER_LNAME_P RETURN VARCHAR2 IS
128 BEGIN
129 RETURN CP_FACULTY_MEMBER_LNAME;
130 END CP_FACULTY_MEMBER_LNAME_P;
131
132 FUNCTION CP_REGARDS_P RETURN VARCHAR2 IS
133 BEGIN
134 RETURN CP_REGARDS;
135 END CP_REGARDS_P;
136
137
138 FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
139 X0 VARCHAR2(2000);
140 BEGIN
141 X0 := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
142 RETURN X0;
143 END GET_BUSINESS_GROUP;
144
145 END PQH_PQHUSNNT_XMLP_PKG;