PACKAGE: APPS.PSP_PSPLSODL_XMLP_PKG

Source

1 PACKAGE PSP_PSPLSODL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPLSODLS.pls 120.3 2007/10/29 07:25:53 amakrish noship $ */
3   P_BATCH_ID NUMBER;
4   P_BATCH_ID1 NUMBER;
5 
6   P_CONC_REQUEST_ID NUMBER;
7 
8   P_BUSINESS_GROUP_ID NUMBER;
9 
10   P_SET_OF_BOOKS_ID NUMBER;
11 
12   P_ORG_TEMPLATE_ID NUMBER;
13 
14   P_BEGIN_DATE DATE;
15 
16   P_END_DATE DATE;
17 
18   FUNCTION CF_ORGANIZATION_NAMEFORMULA(ORGANIZATION_ID_V IN NUMBER) RETURN VARCHAR2;
19 
20   FUNCTION CF_GL_ACCOUNTFORMULA(GL_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2;
21 
22   FUNCTION CF_PROJECT_NAMEFORMULA(PROJECT_ID_V IN NUMBER) RETURN VARCHAR2;
23 
24   FUNCTION CF_EXP_ORG_NAMEFORMULA(EXPENDITURE_ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2;
25 
26   FUNCTION CF_TASK_NAMEFORMULA(TASK_ID_V IN NUMBER
27                               ,PROJECT_ID_V IN NUMBER) RETURN VARCHAR2;
28 
29   FUNCTION CF_AWARD_NAMEFORMULA(AWARD_ID_V IN NUMBER) RETURN VARCHAR2;
30 
31   FUNCTION CF_ASSIGNMENT_NUMBERFORMULA(ASSIGNMENT_ID_V IN NUMBER
32                                       ,PERSON_ID_V IN NUMBER) RETURN VARCHAR2;
33 
34   FUNCTION CF_PERSON_NAMEFORMULA(PERSON_ID_V IN NUMBER) RETURN VARCHAR2;
35 
36   FUNCTION CF_EARNINGS_ELEMENTFORMULA(ELEMENT_TYPE_ID_V IN NUMBER) RETURN VARCHAR2;
37 
38   FUNCTION AFTERREPORT RETURN BOOLEAN;
39 
40   FUNCTION CF_EMPLOYEE_IDFORMULA(PERSON_ID_V IN NUMBER) RETURN VARCHAR2;
41 
42   FUNCTION CF_NUMBER_WORKING_DAYSFORMULA(SCHEDULE_BEGIN_DATE IN DATE
43                                         ,SCHEDULE_END_DATE IN DATE) RETURN NUMBER;
44 
45   FUNCTION AFTERPFORM RETURN BOOLEAN;
46 
47   FUNCTION CF_TIME_PERIOD_STARTFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
48 
49   FUNCTION CF_TIME_PERIOD_ENDFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
50 
51   FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2;
52 
53   FUNCTION BEFOREREPORT RETURN BOOLEAN;
54 
55   FUNCTION BEFOREPFORM RETURN BOOLEAN;
56 
57   FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR;
58 
59   FUNCTION CF_DEFAULT_BEGIN_DATEFORMULA(DEFAULT_BEGIN_DATE IN DATE
60                                        ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
61 
62   FUNCTION CF_DEFAULT_END_DATEFORMULA(DEFAULT_END_DATE IN DATE
63                                      ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
64 
65   FUNCTION CF_DATE_RUNFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
66 
67   FUNCTION CF_SCHEDULE_BEGIN_DATEFORMULA(SCHEDULE_BEGIN_DATE IN DATE
68                                         ,CF_DATE_FORMAT IN VARCHAR2
69                                         ,SCHEDULE_END_DATE IN DATE) RETURN CHAR;
70 
71   FUNCTION CF_SCHEDULE_END_DATEFORMULA(SCHEDULE_END_DATE IN DATE
72                                       ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
73 
74   PROCEDURE CRT(ERRBUF OUT NOCOPY VARCHAR2
75                ,RETCODE OUT NOCOPY NUMBER
76                ,A_TEMPLATE_ID IN NUMBER);
77 
78   PROCEDURE INIT_WORKFLOW(A_TEMPLATE_ID IN NUMBER);
79 
80   PROCEDURE UPD_INCLUDE_FLAG(A_TEMPLATE_ID IN NUMBER);
81 
82 
83   PROCEDURE GET_ANNUAL_SALARY(P_ASSIGNMENT_ID IN NUMBER
84                              ,P_SESSION_DATE IN DATE
85                              ,P_ANNUAL_SALARY OUT NOCOPY NUMBER);
86 
87   PROCEDURE GET_GL_CCID(P_PAYROLL_ID IN NUMBER
88                        ,P_SET_OF_BOOKS_ID IN NUMBER
89                        ,P_COST_KEYFLEX_ID IN NUMBER
90                        ,X_GL_CCID OUT NOCOPY NUMBER);
91 
92   FUNCTION BUSINESS_DAYS(LOW_DATE IN DATE
93                         ,HIGH_DATE IN DATE) RETURN NUMBER;
94 
95   FUNCTION GET_GL_DESCRIPTION(A_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2;
96 
97   PROCEDURE PUT(NAME IN VARCHAR2
98                ,VAL IN VARCHAR2);
99 
100   FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
101 
102   PROCEDURE GET(NAME IN VARCHAR2
103                ,VAL OUT NOCOPY VARCHAR2);
104 
105   FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
106 
107   FUNCTION SAVE_USER(X_NAME IN VARCHAR2
108                     ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
109 
110   FUNCTION SAVE(X_NAME IN VARCHAR2
111                ,X_VALUE IN VARCHAR2
112                ,X_LEVEL_NAME IN VARCHAR2
113                ,X_LEVEL_VALUE IN VARCHAR2
114                ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
115 
116   PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
117                         ,USER_ID_Z IN NUMBER
118                         ,RESPONSIBILITY_ID_Z IN NUMBER
119                         ,APPLICATION_ID_Z IN NUMBER
120                         ,VAL_Z OUT NOCOPY VARCHAR2
121                         ,DEFINED_Z OUT NOCOPY BOOLEAN);
122 
123   FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
124                          ,USER_ID IN NUMBER
125                          ,RESPONSIBILITY_ID IN NUMBER
126                          ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
127 
128   PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
129                       ,RESPONSIBILITY_ID_Z IN NUMBER
130                       ,APPLICATION_ID_Z IN NUMBER
131                       ,SITE_ID_Z IN NUMBER);
132 
133   PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
134                        ,VALS IN VARCHAR2
135                        ,NUM IN NUMBER);
136 
137 END PSP_PSPLSODL_XMLP_PKG;