PACKAGE: APPS.PSP_PSPDAREG_XMLP_PKG

Source

1 PACKAGE PSP_PSPDAREG_XMLP_PKG AS
2 /* $Header: PSPDAREGS.pls 120.3 2007/10/29 07:20:50 amakrish noship $ */
3   P_BEGIN_DATE DATE;
4 
5   P_END_DATE DATE;
6 
7   P_BATCH_NAME VARCHAR2(30);
8 
9   P_SUBMITTED_BY NUMBER;
10 
11   P_APPROVED_BY NUMBER;
12 
13   P_ASSIGNMENT_ORGANIZATION_ID NUMBER;
14 
15   P_CONC_REQUEST_ID NUMBER;
16 
17   P_BUSINESS_GROUP_ID NUMBER;
18 
19   P_SET_OF_BOOKS_ID NUMBER;
20 
21   P_PRIMARY_ORGANIZATION_ID NUMBER;
22 
23   P_PRIMARY_ORG_WHERE_CLAUSE VARCHAR2(500) := 'AND 1=1';
24 
25   P_PRIMARY_ORGANIZATION VARCHAR2(40);
26 
27   FUNCTION CF_NEW_CIFORMULA(GLCCID_NEW IN NUMBER
28                            ,PROJECT_ID_NEW IN NUMBER
29                            ,TASK_ID_NEW IN NUMBER
30                            ,AWARD_ID_NEW IN NUMBER
31                            ,EXP_ORG_ID_NEW IN NUMBER
32                            ,EXPENDITURE_TYPE_NEW IN VARCHAR2) RETURN CHAR;
33 
34   FUNCTION CF_OLD_CIFORMULA(GLCCID_OLD IN NUMBER
35                            ,PROJECT_ID_OLD IN NUMBER
36                            ,TASK_ID_OLD IN NUMBER
37                            ,AWARD_ID_OLD IN NUMBER
38                            ,EXP_ORG_ID_OLD IN NUMBER
39                            ,EXPENDITURE_TYPE_OLD IN VARCHAR2) RETURN CHAR;
40 
41   FUNCTION CF_BATCHFORMULA RETURN CHAR;
42 
43   FUNCTION CF_APPROVED_BYFORMULA RETURN CHAR;
44 
45   FUNCTION CF_SUBMITTED_BYFORMULA RETURN CHAR;
46 
47   FUNCTION CF_ASSIGN_ORG_IDFORMULA RETURN CHAR;
48 
49   FUNCTION BEFOREREPORT RETURN BOOLEAN;
50 
51   FUNCTION AFTERREPORT RETURN BOOLEAN;
52 
53   FUNCTION AFTERPFORM RETURN BOOLEAN;
54 
55   FUNCTION CF_PRIMARY_ORG_NAMEFORMULA RETURN CHAR;
56 
57   FUNCTION CF_SOB_IDFORMULA RETURN CHAR;
58 
59   FUNCTION CF_SOB_ID2FORMULA RETURN CHAR;
60 
61   FUNCTION CF_ADJUSTMENT_BYFORMULA(ADJUSTMENT_BY IN VARCHAR2) RETURN CHAR;
62 
63   FUNCTION CF_SUM_CURRENCYFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
64 
65   FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
66 
67   FUNCTION CF_ORIG_AMOUNT_TOTAL_DSPFORMUL(CF_CURRENCY_FORMAT IN VARCHAR2
68                                          ,CS_ORIG_AMOUNT_TOTAL IN NUMBER) RETURN CHAR;
69 
70   FUNCTION CF_ADJUSTED_AMOUNT_TOTAL_DSPFO(CF_CURRENCY_FORMAT IN VARCHAR2
71                                          ,CS_ADJUSTED_AMOUNT_TOTAL IN NUMBER) RETURN CHAR;
72 
73   FUNCTION CF_ORIGINAL_AMOUNT_DSPFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
74                                         ,ORIGINAL_AMOUNT IN NUMBER) RETURN CHAR;
75 
76   FUNCTION CF_ADJUSTED_AMOUNT_DSPFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
77                                         ,ADJUSTED_AMOUNT IN NUMBER) RETURN CHAR;
78 
79 END PSP_PSPDAREG_XMLP_PKG;