PACKAGE: APPS.PA_PAXMGPSD_XMLP_PKG

Source

1 PACKAGE PA_PAXMGPSD_XMLP_PKG AS
2 /* $Header: PAXMGPSDS.pls 120.0 2008/01/02 11:36:31 krreddy noship $ */
3   PROJ NUMBER;
4 
5   PA_PERIOD VARCHAR2(40);
6 
7   PROJECT_MANAGER_ID NUMBER;
8 
9   ORG_ID NUMBER;
10 
11   P_DEBUG_MODE VARCHAR2(3);
12 
13   P_CONC_REQUEST_ID NUMBER;
14 
15   P_RULE_OPTIMIZER VARCHAR2(3);
16 
17   PROJ_TYPE VARCHAR2(32767);
18 
19   COST_BGT_CODE VARCHAR2(30);
20 
21   REV_BGT_CODE VARCHAR2(30);
22 
23   P_PROJECT VARCHAR2(2000);
24 
25   P_PROJECT_TYPE VARCHAR2(2000);
26 
27   P_PROJECT_MANAGER VARCHAR2(2000);
28 
29   C_COMPANY_NAME_HEADER VARCHAR2(50);
30 
31   C_NO_DATA_FOUND VARCHAR2(80);
32 
33   C_ORG VARCHAR2(60);
34 
35   C_PROJ_NUM VARCHAR2(30);
36 
37   C_PROJ_NAME VARCHAR2(30);
38 
39   C_MGR VARCHAR2(30);
40 
41   C_START_DATE DATE;
42 
43   C_END_DATE DATE;
44 
45   C_COST_BGT_NAME VARCHAR2(30);
46 
47   C_REV_BGT_NAME VARCHAR2(30);
48 
49   C_COST_BGT_CODE VARCHAR2(30);
50 
51   C_REV_BGT_CODE VARCHAR2(30);
52 
53   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
54 
55   FUNCTION BEFOREREPORT RETURN BOOLEAN;
56 
57   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
58 
59   FUNCTION NO_DATA_FOUND_FUNC RETURN BOOLEAN;
60 
61   FUNCTION GET_PERIOD(SD IN DATE) RETURN VARCHAR2;
62 
63   FUNCTION PERIOD_NAMEFORMULA RETURN VARCHAR2;
64 
65   FUNCTION UNBILLED_RECEIVABLESFORMULA(RETN_ACCOUNTING_FLAG IN VARCHAR2
66                                       ,TOTAL_REVENUE_AMOUNT IN NUMBER
67                                       ,PFC_TOTAL_INVOICE_AMOUNT IN NUMBER
68                                       ,UNBILLED_RETENTION IN NUMBER) RETURN NUMBER;
69 
70   FUNCTION UNEARNED_REVENUEFORMULA(RETN_ACCOUNTING_FLAG IN VARCHAR2
71                                   ,PFC_TOTAL_INVOICE_AMOUNT IN NUMBER
72                                   ,TOTAL_REVENUE_AMOUNT IN NUMBER
73                                   ,UNBILLED_RETENTION IN NUMBER) RETURN NUMBER;
74 
75   FUNCTION AFTERREPORT RETURN BOOLEAN;
76 
77   FUNCTION C_PROJECT_ACTUAL_COSTFORMULA RETURN NUMBER;
78 
79   FUNCTION C_ACT_PER_REVFORMULA(RESOURCE_LIST_MEMBER_ID IN NUMBER
80                                ,PERIOD_NAME IN VARCHAR2
81                                ,PROJECT_ID7 IN NUMBER) RETURN NUMBER;
82 
83   FUNCTION GET_PERIOD_AMT(X_TYPE IN VARCHAR2
84                          ,X_RSRC_LIST_MEMBER_ID IN NUMBER,project_id7 IN NUMBER,PERIOD_NAME IN VARCHAR2) RETURN NUMBER;
85 
86   FUNCTION C_ACT_PER_COSTFORMULA(RESOURCE_LIST_MEMBER_ID1 IN NUMBER
87                                 ,PERIOD_NAME IN VARCHAR2
88                                 ,PROJECT_ID7 IN NUMBER) RETURN NUMBER;
89 
90   FUNCTION C_ACT_PER_REV_SUMFORMULA(C_ACT_PER_REV IN NUMBER
91                                    ,MEMBER_LEVEL2 IN NUMBER) RETURN NUMBER;
92 
93   FUNCTION GET_RSRC_NAME_DISP(X_ALIAS IN VARCHAR2
94                              ,X_LEVEL IN NUMBER) RETURN VARCHAR2;
95 
96   FUNCTION C_ACT_PER_COST_SUMFORMULA(C_ACT_PER_COST IN NUMBER
97                                     ,MEMBER_LEVEL1 IN NUMBER) RETURN NUMBER;
98 
99   FUNCTION GET_PERIOD_AMT_SUM(X_AMT IN NUMBER
100                              ,X_LEVEL IN NUMBER) RETURN NUMBER;
101 
102   FUNCTION CF_CURRENCY_CODEFORMULA RETURN VARCHAR2;
103 
104   FUNCTION UNBILLED_RETNFORMULA(RETN_ACCOUNTING_FLAG IN VARCHAR2
105                                ,UNBILLED_RETENTION IN NUMBER) RETURN NUMBER;
106 
107   FUNCTION AFTERPFORM RETURN BOOLEAN;
108 
109   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
110 
111   FUNCTION C_NO_DATA_FOUND_P RETURN VARCHAR2;
112 
113   FUNCTION C_ORG_P RETURN VARCHAR2;
114 
115   FUNCTION C_PROJ_NUM_P RETURN VARCHAR2;
116 
117   FUNCTION C_PROJ_NAME_P RETURN VARCHAR2;
118 
119   FUNCTION C_MGR_P RETURN VARCHAR2;
120 
121   FUNCTION C_START_DATE_P RETURN DATE;
122 
123   FUNCTION C_END_DATE_P RETURN DATE;
124 
125   FUNCTION C_COST_BGT_NAME_P RETURN VARCHAR2;
126 
127   FUNCTION C_REV_BGT_NAME_P RETURN VARCHAR2;
128 
129   FUNCTION C_COST_BGT_CODE_P RETURN VARCHAR2;
130 
131   FUNCTION C_REV_BGT_CODE_P RETURN VARCHAR2;
132 
133 END PA_PAXMGPSD_XMLP_PKG;