PACKAGE: APPS.PSP_PSPENCDU_XMLP_PKG

Source

1 PACKAGE PSP_PSPENCDU_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPENCDUS.pls 120.7 2008/01/30 07:44:01 amakrish noship $ */
3   P_PAYROLL_ID VARCHAR2(2047) := 'and 1 =1 ';
4 
5   P_BUSINESS_GROUP NUMBER;
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_ORGANIZATIONS VARCHAR2(2047) := 'and  1   = 1 ';
10 
11   P_BEGIN_DATE DATE;
12 
13   LP_BEGIN_DATE varchar2(20);
14 
15   P_END_DATE DATE;
16 
17   LP_END_DATE varchar2(20);
18 
19   P_PAY_TEMPLATE_ID NUMBER;
20 
21   P_ORG_TEMPLATE_ID NUMBER;
22 
23   P_BUSINESS_GROUP_ID VARCHAR2(40);
24 
25   FUNCTION CF_TASK_NAMEFORMULA(TASK_ID IN NUMBER
26                               ,PROJECT_ID IN NUMBER) RETURN VARCHAR2;
27 
28   FUNCTION CF_AWARD_NUMBERFORMULA(AWARD_ID IN NUMBER) RETURN VARCHAR2;
29 
30   FUNCTION CF_PROJECT_NUMBERFORMULA(PROJECT_ID 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_ID 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_1FORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
68 
69   FUNCTION CF_CURRENCY_TOTAL_DSPFORMULA(CURRENCY_CODE IN VARCHAR2
70                                        ,CF_CURRENCY_FORMAT IN VARCHAR2
71                                        ,CS_CURRENCY_TOTAL IN NUMBER) RETURN CHAR;
72 
73 END PSP_PSPENCDU_XMLP_PKG;