1 PACKAGE PSP_PSPLDSSA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPLDSSAS.pls 120.5 2007/10/29 09:18:02 amakrish noship $ */
3
4 P_TIME_PERIOD_START DATE;
5
6 P_TIME_PERIOD_END DATE;
7
8 P_ORGANIZATION_ID VARCHAR2(2000);
9
10 P_CONC_REQUEST_ID NUMBER;
11
12 P_BUSINESS_GROUP_ID NUMBER;
13
14 P_SET_OF_BOOKS_ID NUMBER;
15
16 P_ORG_TEMPLATE_ID NUMBER;
17
18 FUNCTION BEFOREPFORM(ORIENTATION IN VARCHAR2) RETURN BOOLEAN;
19
20 FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2;
21
22 FUNCTION BEFOREREPORT RETURN BOOLEAN;
23
24 FUNCTION CF_SUM_CURRENCYFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
25
26 FUNCTION CF_CURR_DIST_AMT_TOTAL_DSPFORM(CF_CURRENCY_FORMAT IN VARCHAR2
27 ,CS_CURR_DIST_AMT_TOTAL IN NUMBER) RETURN CHAR;
28
29 FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
30
31 FUNCTION CF_DISTRIBUTION_AMOUNT_DSPFORM(CF_CURRENCY_FORMAT IN VARCHAR2
32 ,CS_TOTAL_AMOUNT_PERCI IN NUMBER) RETURN CHAR;
33
34 FUNCTION CF_ORGANIZATION_NAMEFORMULA(ORGANIZATION_ID1 IN NUMBER) RETURN VARCHAR2;
35 FUNCTION CF_ACTUAL_GL_CCIDFORMULA(ACTUAL_GL_CCID IN NUMBER
36 ,ACTUAL_PROJECT_ID IN NUMBER
37 ,ACTUAL_TASK_ID IN NUMBER
38 ,ACTUAL_AWARD_ID IN NUMBER
39 ,ACTUAL_EXP_ORG_ID IN NUMBER
40 ,ACTUAL_EXPENDITURE_TYPE IN VARCHAR2) RETURN VARCHAR2 ;
41
42 FUNCTION CF_PERSON_NAMEFORMULA(PERSON_ID_arg IN NUMBER) RETURN VARCHAR2;
43
44 FUNCTION CF_ASSIGNMENT_NUMBERFORMULA(ASSIGNMENT_ID_arg IN NUMBER) RETURN VARCHAR2;
45
46 FUNCTION CF_ELEMENT_NAMEFORMULA(ELEMENT_TYPE_ID_arg IN NUMBER) RETURN VARCHAR2;
47
48 FUNCTION CF_PERIOD_NAMEFORMULA(TIME_PERIOD_ID_arg IN NUMBER
49 ,PAYROLL_ID_arg IN NUMBER) RETURN VARCHAR2;
50
51 FUNCTION CF_GL_CODE_COMBINATION_IDFORMU(GL_CODE_COMBINATION_ID IN NUMBER
52 ,PROJECT_ID_arg IN NUMBER
53 ,TASK_ID_arg IN NUMBER
54 ,AWARD_ID_arg IN NUMBER
55 ,EXPENDITURE_ORGANIZATION_ID IN NUMBER
56 ,EXPENDITURE_TYPE IN VARCHAR2) RETURN VARCHAR2;
57
58 FUNCTION AFTERREPORT RETURN BOOLEAN;
59
60 FUNCTION AFTERPFORM RETURN BOOLEAN;
61
62 FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR;
63
64 FUNCTION CF_BEGIN_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
65
66 FUNCTION CF_END_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
67
68 FUNCTION CF_RUN_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
69
70 PROCEDURE CRT(ERRBUF OUT NOCOPY VARCHAR2
71 ,RETCODE OUT NOCOPY NUMBER
72 ,A_TEMPLATE_ID IN NUMBER);
73
74 PROCEDURE INIT_WORKFLOW(A_TEMPLATE_ID IN NUMBER);
75
76 PROCEDURE UPD_INCLUDE_FLAG(A_TEMPLATE_ID IN NUMBER);
77
78 FUNCTION GET_GL_DESCRIPTION(A_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2;
79
80 PROCEDURE PUT(NAME IN VARCHAR2
81 ,VAL IN VARCHAR2);
82
83 FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
84
85 PROCEDURE GET(NAME IN VARCHAR2
86 ,VAL OUT NOCOPY VARCHAR2);
87
88 FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
89
90 FUNCTION SAVE_USER(X_NAME IN VARCHAR2
91 ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
92
93 FUNCTION SAVE(X_NAME IN VARCHAR2
94 ,X_VALUE IN VARCHAR2
95 ,X_LEVEL_NAME IN VARCHAR2
96 ,X_LEVEL_VALUE IN VARCHAR2
97 ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
98
99 PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
100 ,USER_ID_Z IN NUMBER
101 ,RESPONSIBILITY_ID_Z IN NUMBER
102 ,APPLICATION_ID_Z IN NUMBER
103 ,VAL_Z OUT NOCOPY VARCHAR2
104 ,DEFINED_Z OUT NOCOPY BOOLEAN);
105
106 FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
107 ,USER_ID IN NUMBER
108 ,RESPONSIBILITY_ID IN NUMBER
109 ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
110
111 PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
112 ,RESPONSIBILITY_ID_Z IN NUMBER
113 ,APPLICATION_ID_Z IN NUMBER
114 ,SITE_ID_Z IN NUMBER);
115
116 PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
117 ,VALS IN VARCHAR2
118 ,NUM IN NUMBER);
119
120 END PSP_PSPLDSSA_XMLP_PKG;