PACKAGE: APPS.PSP_PSPLSEMP_XMLP_PKG

Source

1 PACKAGE PSP_PSPLSEMP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPLSEMPS.pls 120.3 2007/10/29 07:25:05 amakrish noship $ */
3   P_ORGANIZATION_ID VARCHAR2(2000) := '1=1';
4 
5   P_END_DATE DATE;
6 
7   P_BEGIN_DATE DATE;
8 
9   P_RUN_ID NUMBER;
10 
11   P_REPORT_TYPE VARCHAR2(1);
12 
13   P_CONC_REQUEST_ID NUMBER;
14 
15   P_BUSINESS_GROUP_ID NUMBER;
16 
17   P_SET_OF_BOOKS_ID NUMBER;
18 
19   P_ORG_TEMPLATE_ID NUMBER;
20 
21   FUNCTION CF_ORGANIZATION_NAMEFORMULA(ORGANIZATION_ID_V IN NUMBER) RETURN CHAR;
22 
23   FUNCTION CF_EMPLOYEE_NAMEFORMULA(PERSON_ID_V IN NUMBER) RETURN CHAR;
24 
25   FUNCTION CF_GL_DESCRIPTIONFORMULA(GL_CODE_COMBINATION_ID IN NUMBER) RETURN CHAR;
26 
27   FUNCTION CF_PROJECT_NUMBERFORMULA(PROJECT_ID_V IN NUMBER) RETURN CHAR;
28 
29   FUNCTION CF_TASK_NUMBERFORMULA(TASK_ID_V IN NUMBER) RETURN CHAR;
30 
31   FUNCTION CF_AWARD_NUMBERFORMULA(AWARD_ID_V IN NUMBER) RETURN CHAR;
32 
33   FUNCTION CF_EXP_ORG_NAMEFORMULA(EXPENDITURE_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
34 
35   FUNCTION CF_DESCRIPTIONFORMULA(TYPE IN NUMBER
36                                 ,SCHEDULING_TYPES_CODE IN VARCHAR2) RETURN CHAR;
37 
38   FUNCTION AFTERREPORT RETURN BOOLEAN;
39 
40   FUNCTION BEFOREREPORT RETURN BOOLEAN;
41 
42   FUNCTION CF_HIER_DESCFORMULA(SCHEDULING_TYPES_CODE IN VARCHAR2
43                               ,CF_DESCRIPTION IN VARCHAR2) RETURN CHAR;
44 
45   FUNCTION AFTERPFORM RETURN BOOLEAN;
46 
47   FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR;
48 
49   FUNCTION CF_REPORT_RUN_DATEFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
50 
51   FUNCTION CF_SCH_BEGIN_DATE_DISPFORMULA(SCHEDULE_BEGIN_DATE IN DATE
52                                         ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
53 
54   FUNCTION CF_SCH_END_DATE_DSPFORMULA(SCHEDULE_END_DATE IN DATE
55                                      ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
56 
57   FUNCTION CF_PERIOD_START_DATE_DISPFORMU(PERIOD_START_DATE IN DATE
58                                          ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
59 
60   FUNCTION CF_PERIOD_END_DATE_DISPFORMULA(PERIOD_END_DATE IN DATE
61                                          ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
62 
63   FUNCTION CF_BEGIN_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
64 
65   FUNCTION CF_END_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
66 
67 END PSP_PSPLSEMP_XMLP_PKG;