DBA Data[Home] [Help]

PACKAGE: APPS.PSP_PSPLDPRJ_XMLP_PKG

Source


1 PACKAGE PSP_PSPLDPRJ_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPLDPRJS.pls 120.4 2007/10/29 07:24:29 amakrish noship $ */
3   P_PROJECT_ID VARCHAR2(2000);
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_PRJ_TEMPLATE_ID NUMBER;
16 
17   FUNCTION AFTERPFORM RETURN BOOLEAN;
18 
19   FUNCTION BEFOREPFORM(ORIENTATION IN VARCHAR2) RETURN BOOLEAN;
20 
21   FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2;
22 
23   FUNCTION BEFOREREPORT RETURN BOOLEAN;
24 
25   FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
26 
27   FUNCTION CF_SUM_CURRENCY_CODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
28 
29   FUNCTION CF_CURR_PROJ_AMT_TOTALFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
30                                         ,CS_CURR_PROJ_AMT_TOTAL IN NUMBER) RETURN CHAR;
31 
32   FUNCTION CF_EARNINGS_AMOUNTFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
33                                     ,EARNINGS_AMOUNT IN NUMBER) RETURN CHAR;
34 
35   FUNCTION CF_PROJECT_NAMEFORMULA(PROJECT_ID_arg IN NUMBER) RETURN VARCHAR2;
36 
37   FUNCTION CF_EMPLOYEE_NAMEFORMULA(PERSON_ID_arg IN NUMBER) RETURN VARCHAR2;
38 
39   FUNCTION CF_ASSIGNMENT_NUMBERFORMULA(ASSIGNMENT_ID_arg IN NUMBER) RETURN VARCHAR2;
40 
41   FUNCTION CF_ELEMENT_NAMEFORMULA(ELEMENT_TYPE_ID_arg IN NUMBER) RETURN VARCHAR2;
42 
43   FUNCTION CF_TIME_PERIOD_NAMEFORMULA(TIME_PERIOD_ID_arg IN NUMBER) RETURN VARCHAR2;
44 
45   FUNCTION AFTERREPORT RETURN BOOLEAN;
46 
47   FUNCTION CF_BEGIN_DATE_DSPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
48 
49   FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR;
50 
51   FUNCTION CF_DATE_RUNFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
52 
53   FUNCTION CF_END_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
54 
55 FUNCTION CF_CHARGING_INSTRUCTIONFORMULA(EXPENDITURE_ORGANIZATION_ID IN NUMBER
56                                          ,TASK_ID_arg IN NUMBER
57                                          ,AWARD_ID_arg IN NUMBER
58                                          ,CF_PROJECT_NAME IN VARCHAR2
59                                          ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR ;
60 
61   PROCEDURE PUT(NAME IN VARCHAR2
62                ,VAL IN VARCHAR2);
63 
64   FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
65 
66   PROCEDURE GET(NAME IN VARCHAR2
67                ,VAL OUT NOCOPY VARCHAR2);
68 
69   FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
70 
71   FUNCTION SAVE_USER(X_NAME IN VARCHAR2
72                     ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
73 
74   FUNCTION SAVE(X_NAME IN VARCHAR2
75                ,X_VALUE IN VARCHAR2
76                ,X_LEVEL_NAME IN VARCHAR2
77                ,X_LEVEL_VALUE IN VARCHAR2
78                ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
79 
80   PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
81                         ,USER_ID_Z IN NUMBER
82                         ,RESPONSIBILITY_ID_Z IN NUMBER
83                         ,APPLICATION_ID_Z IN NUMBER
84                         ,VAL_Z OUT NOCOPY VARCHAR2
85                         ,DEFINED_Z OUT NOCOPY BOOLEAN);
86 
87   FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
88                          ,USER_ID IN NUMBER
89                          ,RESPONSIBILITY_ID IN NUMBER
90                          ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
91 
92   PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
93                       ,RESPONSIBILITY_ID_Z IN NUMBER
94                       ,APPLICATION_ID_Z IN NUMBER
95                       ,SITE_ID_Z IN NUMBER);
96 
97   PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
98                        ,VALS IN VARCHAR2
99                        ,NUM IN NUMBER);
100 
101 END PSP_PSPLDPRJ_XMLP_PKG;