PACKAGE: APPS.PSP_PSPLDORG_XMLP_PKG

Source

1 PACKAGE PSP_PSPLDORG_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPLDORGS.pls 120.3 2007/10/29 07:24:11 amakrish noship $ */
3   P_OGM_PERIOD VARCHAR2(1);
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   P_ORG_ID VARCHAR2(2550) := '1=1';
8 
9   P_BEGIN_DATE DATE;
10 
11   P_END_DATE DATE;
12 
13   P_BUSINESS_GROUP_ID NUMBER;
14 
15   P_SET_OF_BOOKS_ID NUMBER;
16 
17   P_ORG_TEMPLATE_ID NUMBER;
18 
19   FUNCTION AFTERPFORM RETURN BOOLEAN;
20 
21   FUNCTION BEFOREPFORM(ORIENTATION IN VARCHAR2) RETURN BOOLEAN;
22 
23   FUNCTION CF_EMPLOYEE_NUMBERFORMULA(PERSON_ID1 IN NUMBER
24                                     ,EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
25 
26   FUNCTION CF_TIME_PERIOD_NAMEFORMULA RETURN VARCHAR2;
27 
28   FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2;
29 
30   FUNCTION BEFOREREPORT RETURN BOOLEAN;
31 
32   FUNCTION CF_CHARGING_DESCFORMULA(GL_ID IN NUMBER
33                                   ,PROJECT_NUMBER IN VARCHAR2
34                                   ,TASK_NUMBER IN VARCHAR2
35                                   ,AWARD_NUMBER IN VARCHAR2
36                                   ,EXPENDITURE_ORGANIZATION_NAME IN VARCHAR2
37                                   ,EXP_TYPE1 IN VARCHAR2) RETURN VARCHAR2;
38 
39   FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
40 
41   FUNCTION CF_EARNINGS_AMOUNT_DSPFORMULA(EARNINGS_AMOUNT IN NUMBER
42                                         ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
43 
44   FUNCTION CF_CURRENCY_CODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
45 
46   FUNCTION CF_ORG_CURR_AMT_TOTAL_DSPFORMU(CF_CURRENCY_FORMAT IN VARCHAR2
47                                          ,CS_ORG_CURR_AMT_TOTAL IN NUMBER) RETURN CHAR;
48 
49   FUNCTION AFTERREPORT RETURN BOOLEAN;
50 
51   FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR;
52 
53   FUNCTION CF_RUN_DATEFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
54 
55   FUNCTION CF_START_DATE_SIPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
56 
57   FUNCTION CF_END_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
58 
59   PROCEDURE PUT(NAME IN VARCHAR2
60                ,VAL IN VARCHAR2);
61 
62   FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
63 
64   PROCEDURE GET(NAME IN VARCHAR2
65                ,VAL OUT NOCOPY VARCHAR2);
66 
67   FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
68 
69   FUNCTION SAVE_USER(X_NAME IN VARCHAR2
70                     ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
71 
72   FUNCTION SAVE(X_NAME IN VARCHAR2
73                ,X_VALUE IN VARCHAR2
74                ,X_LEVEL_NAME IN VARCHAR2
75                ,X_LEVEL_VALUE IN VARCHAR2
76                ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
77 
78   PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
79                         ,USER_ID_Z IN NUMBER
80                         ,RESPONSIBILITY_ID_Z IN NUMBER
81                         ,APPLICATION_ID_Z IN NUMBER
82                         ,VAL_Z OUT NOCOPY VARCHAR2
83                         ,DEFINED_Z OUT NOCOPY BOOLEAN);
84 
85   FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
86                          ,USER_ID IN NUMBER
87                          ,RESPONSIBILITY_ID IN NUMBER
88                          ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
89 
90   PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
91                       ,RESPONSIBILITY_ID_Z IN NUMBER
92                       ,APPLICATION_ID_Z IN NUMBER
93                       ,SITE_ID_Z IN NUMBER);
94 
95   PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
96                        ,VALS IN VARCHAR2
97                        ,NUM IN NUMBER);
98 
99 END PSP_PSPLDORG_XMLP_PKG;