DBA Data[Home] [Help]

PACKAGE: APPS.PSP_PSPLDAWD_XMLP_PKG

Source


1 PACKAGE PSP_PSPLDAWD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPLDAWDS.pls 120.5 2007/10/29 07:23:35 amakrish noship $ */
3   P_AWARD_ID VARCHAR2(2550);
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   P_BUSINESS_GROUP_ID NUMBER;
8 
9   P_SET_OF_BOOKS_ID NUMBER;
10 
11   P_START_DATE DATE;
12 
13   P_END_DATE DATE;
14 
15   P_AWD_TEMPLATE_ID NUMBER;
16 
17   FUNCTION AFTERPFORM RETURN BOOLEAN;
18 
19   FUNCTION BEFOREPFORM(ORIENTATION IN VARCHAR2) RETURN BOOLEAN;
20 
21   FUNCTION CF_EMPLOYEE_NUMBERFORMULA RETURN VARCHAR2;
22 
23   FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2;
24 
25   FUNCTION BEFOREREPORT RETURN BOOLEAN;
26 
27   FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
28 
29   FUNCTION CF_SUM_CURRENCY_CODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
30 
31   FUNCTION CF_CURR_AWD_AMT_TOTALFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
32                                        ,CS_CURR_AWD_AMT_TOTAL IN NUMBER) RETURN CHAR;
33 
34   FUNCTION CF_EARNINGS_AMOUNTFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
35                                     ,EARNINGS_AMOUNT IN NUMBER) RETURN CHAR;
36 
37   FUNCTION CF_AWARD_NAMEFORMULA(AWARD_ID IN NUMBER) RETURN VARCHAR2;
38 
39   FUNCTION CF_EMPLOYEE_NAMEFORMULA(PERSON_ID IN NUMBER) RETURN VARCHAR2;
40 
41   FUNCTION CF_ASSIGNMENT_NUMBERFORMULA(ASSIGNMENT_ID IN NUMBER
42                                       ,PERSON_ID IN NUMBER) RETURN VARCHAR2;
43 
44   FUNCTION CF_ELEMENT_NAMEFORMULA(ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
45 
46   FUNCTION CF_TIME_PERIOD_NAMEFORMULA(TIME_PERIOD_ID IN NUMBER) RETURN VARCHAR2;
47 
48   FUNCTION AFTERREPORT RETURN BOOLEAN;
49 
50   FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR;
51 
52   FUNCTION CF_START_DATE_DISPLAYFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
53 
54   FUNCTION CF_END_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
55 
56   FUNCTION CF_CHARGING_INSTRUCTIONSFORMUL(EXPENDITURE_ORGANIZATION_ID IN NUMBER
57                                          ,TASK_ID IN NUMBER
58                                          ,PROJECT_ID IN NUMBER
59                                          --,CF_AWARD_NAME IN VARCHAR2
60 					  ,AWARD_ID IN VARCHAR2
61                                          ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR;
62 
63   FUNCTION CF_DATE_RUNFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
64 
65   PROCEDURE PUT(NAME IN VARCHAR2
66                ,VAL IN VARCHAR2);
67 
68   FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
69 
70   PROCEDURE GET(NAME IN VARCHAR2
71                ,VAL OUT NOCOPY VARCHAR2);
72 
73   FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
74 
75   FUNCTION SAVE_USER(X_NAME IN VARCHAR2
76                     ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
77 
78   FUNCTION SAVE(X_NAME IN VARCHAR2
79                ,X_VALUE IN VARCHAR2
80                ,X_LEVEL_NAME IN VARCHAR2
81                ,X_LEVEL_VALUE IN VARCHAR2
82                ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
83 
84   PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
85                         ,USER_ID_Z IN NUMBER
86                         ,RESPONSIBILITY_ID_Z IN NUMBER
87                         ,APPLICATION_ID_Z IN NUMBER
88                         ,VAL_Z OUT NOCOPY VARCHAR2
89                         ,DEFINED_Z OUT NOCOPY BOOLEAN);
90 
91   FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
92                          ,USER_ID IN NUMBER
93                          ,RESPONSIBILITY_ID IN NUMBER
94                          ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
95 
96   PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
97                       ,RESPONSIBILITY_ID_Z IN NUMBER
98                       ,APPLICATION_ID_Z IN NUMBER
99                       ,SITE_ID_Z IN NUMBER);
100 
101   PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
102                        ,VALS IN VARCHAR2
103                        ,NUM IN NUMBER);
104 
105 END PSP_PSPLDAWD_XMLP_PKG;