1 PACKAGE PSP_PSPLSODL_XMLP_PKG 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;