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