PACKAGE: APPS.PSP_PSPENCSC_XMLP_PKG

Source

1 PACKAGE PSP_PSPENCSC_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPENCSCS.pls 120.3 2007/10/29 07:22:43 amakrish noship $ */
3   P_PAYROLL_ID VARCHAR2(400) := 'and 1 =1 ';
4 
5   P_BUSINESS_GROUP NUMBER;
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_ORGANIZATIONS VARCHAR2(400) := 'and  1   = 1 ';
10 
11   P_BEGIN_DATE DATE;
12 
13   CP_BEGIN_DATE VARCHAR2(25);
14 
15   CP_END_DATE VARCHAR2(25);
16 
17   P_END_DATE DATE;
18 
19   P_PAY_TEMPLATE_ID NUMBER;
20 
21   P_ORG_TEMPLATE_ID NUMBER;
22 
23   FUNCTION SUSP_ORGANIZATIONFORMULA(SUSPENSE_ORG_ACCOUNT_ID IN NUMBER) RETURN VARCHAR2;
24 
25   FUNCTION CF_TASK_NAMEFORMULA(TASK_ID1 IN NUMBER
26                               ,PROJECT_ID1 IN NUMBER) RETURN VARCHAR2;
27 
28   FUNCTION CF_AWARD_NUMBERFORMULA(AWARD_ID1 IN NUMBER) RETURN VARCHAR2;
29 
30   FUNCTION CF_PROJECT_NUMBERFORMULA(PROJECT_ID1 IN NUMBER) RETURN VARCHAR2;
31 
32   FUNCTION CF_ORG_NAMEFORMULA(EXPENDITURE_ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2;
33 
34   FUNCTION CF_GL_DESCFORMULA(GL_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2;
35 
36   FUNCTION CF_EMPLOYEE_NUMBERFORMULA(PERSON_ID1 IN NUMBER) RETURN VARCHAR2;
37 
38   FUNCTION BEFOREREPORT RETURN BOOLEAN;
39 
40   FUNCTION P_ORGANIZATIONSVALIDTRIGGER RETURN BOOLEAN;
41 
42   FUNCTION CF_ORG_TOTAL_DSPFORMULA(CS_ORG_TOTAL IN NUMBER
43                                   ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
44 
45   FUNCTION CF_EMP_TOTAL_DSPFORMULA(CS_EMP_TOTAL IN NUMBER
46                                   ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
47 
48   FUNCTION CF_ENC_AMOUNT_DSPFORMULA(CS_ENC_AMOUNT IN NUMBER
49                                    ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
50 
51   FUNCTION AFTERREPORT RETURN BOOLEAN;
52 
53   FUNCTION CF_SUSPENSE_ORG_ACCOUNTFORMULA(GL_CODE_COMBINATION_ID IN NUMBER
54                                          ,CF_PROJECT_NUMBER IN VARCHAR2
55                                          ,CF_AWARD_NUMBER IN VARCHAR2
56                                          ,CF_TASK_NUMBER IN VARCHAR2
57                                          ,CF_ORG_NAME IN VARCHAR2
58                                          ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR;
59 
60   FUNCTION AFTERPFORM RETURN BOOLEAN;
61 
62   FUNCTION CF_CHARGING_INSTRUCTIONSFORMUL RETURN VARCHAR2;
63 
64   FUNCTION CF_PAY_TOTALFORMULA(CS_PAY_TOTAL IN NUMBER
65                               ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
66 
67   FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
68 
69   FUNCTION CF_CURRENCY_TOTAL_DSPFORMULA(CS_CURRENCY_TOTAL IN NUMBER
70                                        ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
71 
72 END PSP_PSPENCSC_XMLP_PKG;