PACKAGE: APPS.PQH_PQHUSUCE_XMLP_PKG

Source

1 PACKAGE PQH_PQHUSUCE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PQHUSUCES.pls 120.1 2007/12/07 06:58:50 vjaganat noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   P_PERSON_ID NUMBER;
8 
9   CP_BUSINESS_GROUP_NAME VARCHAR2(240);
10 
11   CP_BODY_TEXT VARCHAR2(2000);
12 
13   CP_FACULTY_MEMBER_NAME VARCHAR2(240);
14 
15   CP_ACADEMIC_MANAGER_NAME VARCHAR2(240);
16 
17   CP_EMPLOYEE_ID VARCHAR2(22);
18 
19   FUNCTION BEFOREREPORT RETURN BOOLEAN;
20 
21   FUNCTION AFTERREPORT RETURN BOOLEAN;
22 
23   FUNCTION CP_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
24 
25   FUNCTION CP_BODY_TEXT_P RETURN VARCHAR2;
26 
27   FUNCTION CP_FACULTY_MEMBER_NAME_P RETURN VARCHAR2;
28 
29   FUNCTION CP_ACADEMIC_MANAGER_NAME_P RETURN VARCHAR2;
30 
31   FUNCTION CP_EMPLOYEE_ID_P RETURN VARCHAR2;
32 
33   FUNCTION_DESC VARCHAR2(240);
34 
35   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
36 
37 END PQH_PQHUSUCE_XMLP_PKG;