PACKAGE: APPS.PA_PARCPRJR_XMLP_PKG

Source

1 PACKAGE PA_PARCPRJR_XMLP_PKG AS
2 /* $Header: PARCPRJRS.pls 120.1 2008/04/09 11:59:37 krreddy noship $ */
3   P_COA_ID NUMBER;
4 
5   P_DEBUG_MODE VARCHAR2(30);
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_CONC_RESQUEST_ID VARCHAR2(40);
10 
11   P_FROM_EMP_NUM VARCHAR2(30);
12 
13   P_TO_EMP_NUM VARCHAR2(30);
14 
15   P_ORGANIZATION_ID NUMBER;
16 
17   P_REFRESH VARCHAR2(10);
18 
19   P_PULL_TERM_RES VARCHAR2(32767);
20 
21   P_TERM_RANGE_DATE DATE;
22 
23   P_TERM_RANGE_DATE1 varchar2(25);
24 
25   P_PERSON_TYPE VARCHAR2(32767);
26 
27   P_SELECTION_OPTION VARCHAR2(30);
28 
29   P_ORG_STR_VERSION_ID NUMBER;
30 
31   P_START_ORGANIZATION_ID NUMBER;
32 
33    P_RET_STATUS VARCHAR2(1) := 'N';
34 
35   CP_NODATAFOUND VARCHAR2(80) := 'No Data Found';
36 
37   CP_COUNT NUMBER := 0;
38 
39   CP_CHK_ORG_OR_EMP VARCHAR2(20);
40 
41   CP_CHK_EMP_RANGE VARCHAR2(20);
42 
43   CP_CHK_ORG_AND_EMP_RANGE VARCHAR2(20);
44 
45   CP_CHK_SINGLE_ORG VARCHAR2(20);
46 
47   CP_CHK_START_ORG VARCHAR2(20);
48 
49   FUNCTION AFTERREPORT RETURN BOOLEAN;
50 
51   FUNCTION BEFOREREPORT RETURN BOOLEAN;
52 
53   FUNCTION CF_ORGANIZATION_NAMEFORMULA RETURN CHAR;
54 
55   FUNCTION CF_REFRESHFORMULA RETURN CHAR;
56 
57   FUNCTION CF_SELECTION_OPTIONFORMULA RETURN CHAR;
58 
59   FUNCTION CF_ORG_STR_VERSION_IDFORMULA RETURN CHAR;
60 
61   FUNCTION CF_START_ORG_IDFORMULA RETURN CHAR;
62 
63   FUNCTION CF_PULL_TERM_RESFORMULA RETURN CHAR;
64 
65   FUNCTION CF_PERSON_TYPEFORMULA RETURN CHAR;
66 
67   FUNCTION CP_NODATAFOUND_P RETURN VARCHAR2;
68 
69   FUNCTION CP_COUNT_P RETURN NUMBER;
70 
71   FUNCTION CP_CHK_ORG_OR_EMP_P RETURN VARCHAR2;
72 
73   FUNCTION CP_CHK_EMP_RANGE_P RETURN VARCHAR2;
74 
75   FUNCTION CP_CHK_ORG_AND_EMP_RANGE_P RETURN VARCHAR2;
76 
77   FUNCTION CP_CHK_SINGLE_ORG_P RETURN VARCHAR2;
78 
79   FUNCTION CP_CHK_START_ORG_P RETURN VARCHAR2;
80 
81 END PA_PARCPRJR_XMLP_PKG;