1 PACKAGE PA_PAXMGURA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAXMGURAS.pls 120.1.12010000.2 2008/12/12 11:19:00 dbudhwar ship $ */
3 DATE_FROM DATE;
4
5 ORG_ID NUMBER;
6
7 P_ORG_ID NUMBER;
8
9 PROJECT_MANAGER_ID NUMBER;
10
11 PROJ NUMBER;
12
13 /* added for bug 7115658 */
14
15 from_project_number VARCHAR2(40);
16
17 to_project_number VARCHAR2(40);
18
19 project_status VARCHAR2(40);
20
21 project_closed_after date;
22
23 /* added for bug 7115658 */
24
25 AGE VARCHAR2(50);
26
27 BUCKET_SIZE1 NUMBER;
28
29 BUCKET_SIZE2 NUMBER;
30
31 BUCKET_SIZE3 NUMBER;
32
33 P_CONC_REQUEST_ID NUMBER;
34
35 P_DEBUG_MODE VARCHAR2(3);
36
37 P_RULE_OPTIMIZER VARCHAR2(3);
38
39 C_COLHEAD1 VARCHAR2(15);
40
41 C_COLHEAD2 VARCHAR2(15);
42
43 C_COLHEAD3 VARCHAR2(15);
44
45 C_COLHEAD4 VARCHAR2(15);
46
47 C_COMPANY_NAME_HEADER VARCHAR2(60);
48
49 C_NO_DATA_FOUND VARCHAR2(80);
50
51 FUNCTION FINAL_BUCKET4FORMULA(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER) RETURN NUMBER ;
52
53 FUNCTION FINAL_BUCKET3FORMULA(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER) RETURN NUMBER ;
54
55 FUNCTION FINAL_BUCKET2FORMULA(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER) RETURN NUMBER ;
56
57 FUNCTION FINAL_BUCKET1FORMULA(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER,INVOICE_REDUCTION IN NUMBER,RETENTION IN NUMBER) RETURN NUMBER ;
58
59 FUNCTION TOTALFORMULA(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER,INVOICE_REDUCTION IN NUMBER,RETENTION IN NUMBER) RETURN NUMBER ;
60
61 FUNCTION BEFOREPFORM RETURN BOOLEAN;
62
63 FUNCTION AFTERREPORT RETURN BOOLEAN;
64
65 FUNCTION BEFOREREPORT RETURN BOOLEAN;
66
67 FUNCTION CF_CURRENCY_CODEFORMULA RETURN VARCHAR2;
68
69 FUNCTION AFTERPFORM RETURN BOOLEAN;
70
71 -- PROCEDURE UPDATE_EIS;
72
73 FUNCTION G_PROJECTGROUPFILTER(FINAL_BUCKET1 IN NUMBER
74 ,FINAL_BUCKET2 IN NUMBER
75 ,FINAL_BUCKET3 IN NUMBER
76 ,FINAL_BUCKET4 IN NUMBER) RETURN BOOLEAN;
77
78 FUNCTION C_COLHEAD1_P RETURN VARCHAR2;
79
80 FUNCTION C_COLHEAD2_P RETURN VARCHAR2;
81
82 FUNCTION C_COLHEAD3_P RETURN VARCHAR2;
83
84 FUNCTION C_COLHEAD4_P RETURN VARCHAR2;
85
86 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
87
88 FUNCTION C_NO_DATA_FOUND_P RETURN VARCHAR2;
89
90 PROCEDURE SELECT_DATES;
91
92 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
93
94 PROCEDURE GET_COLUMN_HEADINGS;
95
96 PROCEDURE POPULATE;
97
98 FUNCTION CALC_BUCKET1(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER,INVOICE_REDUCTION IN NUMBER,RETENTION IN NUMBER) RETURN NUMBER;
99
100 FUNCTION CALC_BUCKET2(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER) RETURN NUMBER;
101
102 FUNCTION CALC_BUCKET3(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER) RETURN NUMBER;
103
104 FUNCTION CALC_BUCKET4(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER) RETURN NUMBER;
105
106 FUNCTION CALC_TOTAL_BUCKETS(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER,INVOICE_REDUCTION IN NUMBER,RETENTION IN NUMBER) RETURN NUMBER;
107
108 --FUNCTION GET_CURRENCY_CODE RETURN VARCHAR2;
109
110 --FUNCTION ROUND_CURRENCY_AMT(X_AMOUNT IN NUMBER) RETURN NUMBER;
111
112 --FUNCTION CURRENCY_FMT_MASK(X_LENGTH IN NUMBER) RETURN VARCHAR2;
113
114 --FUNCTION RPT_CURRENCY_FMT_MASK(X_ORG_ID IN NUMBER
115 -- ,X_LENGTH IN NUMBER) RETURN VARCHAR2;
116
117 END PA_PAXMGURA_XMLP_PKG;