1 PACKAGE PA_FP_FCST_GEN_CLIENT_EXT AUTHID CURRENT_USER as
2 /* $Header: PAFPFGCS.pls 120.2 2007/02/06 09:53:06 dthakker ship $ */
3 /*#
4 * This package enables you to control the calculation of estimate to complete (ETC) quantities and amounts in forecasts.
5 * You can use this extension to calculate quantities and amounts for raw cost, burdened cost, and revenue.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Estimate to Complete Generation Method
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_FORECAST
13 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14 */
15 type l_pds_rate_dtls_rec_type is RECORD
16 ( PERIOD_NAME pa_budget_lines.period_name%TYPE,
17 RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
18 BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
19 REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE);
20
21 type l_pds_rate_dtls_tab is
22 TABLE of l_pds_rate_dtls_rec_type INDEX BY BINARY_INTEGER;
23
24 /*
25 type tab_period_name is
26 TABLE of pa_budget_lines.period_name%TYPE;
27
28 type tab_raw_cost_rate is
29 TABLE of pa_budget_lines.txn_standard_cost_rate%TYPE;
30
31 type tab_burden_cost_rate is
32 TABLE of pa_budget_lines.burden_cost_rate%TYPE;
33
34 type tab_bill_rate is
35 TABLE of pa_budget_lines.txn_standard_bill_rate%TYPE;
36 */
37
38 -- Start Bug 5726785
39
40 TYPE l_plan_txn_prd_amt_rec IS RECORD
41 ( period_name pa_budget_lines.period_name%TYPE,
42 etc_quantity pa_budget_lines.quantity%TYPE,
43 txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
44 txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
45 txn_revenue pa_budget_lines.txn_revenue%TYPE,
46 init_quantity pa_budget_lines.init_quantity%TYPE,
47 init_raw_cost pa_budget_lines.init_raw_cost%TYPE,
48 init_burdened_cost pa_budget_lines.init_burdened_cost%TYPE,
49 init_revenue pa_budget_lines.init_revenue%TYPE,
50 periodic_line_editable VARCHAR2(1), -- Identifier which specifies whether the ETC figures are editable for a period or not
51 description VARCHAR2(30) ); -- Description of the period. Values would be stamped using a new lookup type, PA_FP_FCST_GEN_CLNT_EXTN_LU.
52
53 TYPE l_plan_txn_prd_amt_tbl IS
54 TABLE of l_plan_txn_prd_amt_rec INDEX BY BINARY_INTEGER;
55
56 -- End Bug 5726785
57
58 /*#
59 * This API is used to to define calculations for ETC quantities and amounts for raw cost, burdened cost, and revenue.
60 * @param P_PROJECT_ID Project identifier
61 * @rep:paraminfo {@rep:required}
62 * @param P_BUDGET_VERSION_ID Forecast version identifier
63 * @rep:paraminfo {@rep:required}
64 * @param P_RESOURCE_ASSIGNMENT_ID Resource assignment identifier
65 * @rep:paraminfo {@rep:required}
66 * @param P_TASK_ID Task identifier. Set to zero if forecasting at the project level.
67 * @rep:paraminfo {@rep:required}
68 * @param P_TASK_PERCENT_COMPLETE Task percentage complete
69 * @rep:paraminfo {@rep:required}
70 * @param P_PROJECT_PERCENT_COMPLETE Project percentage complete
71 * @rep:paraminfo {@rep:required}
72 * @param P_RESOURCE_LIST_MEMBER_ID Resource list member identifier
73 * @rep:paraminfo {@rep:required}
74 * @param P_UNIT_OF_MEASURE Unit of measure
75 * @rep:paraminfo {@rep:required}
76 * @param P_TXN_CURRENCY_CODE Transaction currency code
77 * @rep:paraminfo {@rep:required}
78 * @param P_ETC_QTY Estimate to complete quantity
79 * @rep:paraminfo {@rep:required}
80 * @param P_ETC_RAW_COST Estimate to complete raw cost
81 * @rep:paraminfo {@rep:required}
82 * @param P_ETC_BURDENED_COST Estimate to complete burdened cost
83 * @rep:paraminfo {@rep:required}
84 * @param P_ETC_REVENUE Estimate to complete revenue
85 * @rep:paraminfo {@rep:required}
86 * @param P_ETC_SOURCE Estimate to complete source
87 * @rep:paraminfo {@rep:required}
88 * @param P_ETC_GEN_METHOD Estimate to complete generation method
89 * @rep:paraminfo {@rep:required}
90 * @param P_ACTUAL_THRU_DATE Actual amounts through date
91 * @rep:paraminfo {@rep:required}
92 * @param P_ETC_START_DATE Estimate to complete start date
93 * @rep:paraminfo {@rep:required}
94 * @param P_ETC_END_DATE Estimate to complete end date
95 * @rep:paraminfo {@rep:required}
96 * @param P_PLANNED_WORK_QTY Planned work quantity
97 * @rep:paraminfo {@rep:required}
98 * @param P_ACTUAL_WORK_QTY Actual work quantity
99 * @rep:paraminfo {@rep:required}
100 * @param P_ACTUAL_QTY Actual quantity
101 * @rep:paraminfo {@rep:required}
102 * @param P_ACTUAL_RAW_COST Actual raw cost
103 * @rep:paraminfo {@rep:required}
104 * @param P_ACTUAL_BURDENED_COST Actual burdened cost
105 * @rep:paraminfo {@rep:required}
106 * @param P_ACTUAL_REVENUE Actual revenue
107 * @rep:paraminfo {@rep:required}
108 * @param P_PERIOD_RATES_TBL Period rates table (l_pds_rate_dtls_tab) - period rates from the source plan
109 * @rep:paraminfo {@rep:required}
110 * @param X_ETC_QTY Estimate to complete quantity
111 * @param X_ETC_RAW_COST Estimate to complete raw cost
112 * @param X_ETC_BURDENED_COST Estimate to complete burdened cost
113 * @param X_ETC_REVENUE Estimate to complete revenue
114 * @param X_PERIOD_RATES_TBL Period rates table (l_pds_rate_dtls_tab)
115 * @param X_RETURN_STATUS Standard out parameter for error handling
116 * @param X_MSG_DATA Standard out parameter for error handling
117 * @param X_MSG_COUNT Standard out parameter for error handling
118 * @rep:scope public
119 * @rep:lifecycle active
120 * @rep:displayname Estimate to Complete Generation Method
121 * @rep:compatibility S
122 */
123 PROCEDURE FCST_GEN_CLIENT_EXTN
124 (P_PROJECT_ID IN NUMBER
125 ,P_BUDGET_VERSION_ID IN NUMBER
126 ,P_RESOURCE_ASSIGNMENT_ID IN NUMBER
127 ,P_TASK_ID IN NUMBER
128 ,P_TASK_PERCENT_COMPLETE IN NUMBER
129 ,P_PROJECT_PERCENT_COMPLETE IN NUMBER
130 ,P_RESOURCE_LIST_MEMBER_ID IN NUMBER
131 ,P_UNIT_OF_MEASURE IN PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE
132 ,P_TXN_CURRENCY_CODE IN VARCHAR2
133 ,P_ETC_QTY IN NUMBER
134 ,P_ETC_RAW_COST IN NUMBER
135 ,P_ETC_BURDENED_COST IN NUMBER
136 ,P_ETC_REVENUE IN NUMBER
137 ,P_ETC_SOURCE IN VARCHAR2
138 ,P_ETC_GEN_METHOD IN VARCHAR2
139 ,P_ACTUAL_THRU_DATE IN DATE
140 ,P_ETC_START_DATE IN DATE
141 ,P_ETC_END_DATE IN DATE
142 ,P_PLANNED_WORK_QTY IN NUMBER
143 ,P_ACTUAL_WORK_QTY IN NUMBER
144 ,P_ACTUAL_QTY IN NUMBER
145 ,P_ACTUAL_RAW_COST IN NUMBER
146 ,P_ACTUAL_BURDENED_COST IN NUMBER
147 ,P_ACTUAL_REVENUE IN NUMBER
148 ,P_PERIOD_RATES_TBL IN l_pds_rate_dtls_tab
149 -- Start Bug 5726785
150 ,p_override_raw_cost_rate IN pa_resource_asgn_curr.txn_raw_cost_rate_override%TYPE DEFAULT NULL
151 ,p_override_burd_cost_rate IN pa_resource_asgn_curr.txn_burden_cost_rate_override%TYPE DEFAULT NULL
152 ,p_override_bill_rate IN pa_resource_asgn_curr.txn_bill_rate_override%TYPE DEFAULT NULL
153 ,p_avg_raw_cost_rate IN pa_resource_asgn_curr.txn_average_raw_cost_rate%TYPE DEFAULT NULL
154 ,p_avg_burd_cost_rate IN pa_resource_asgn_curr.txn_average_burden_cost_rate%TYPE DEFAULT NULL
155 ,p_avg_bill_rate IN pa_resource_asgn_curr.txn_average_bill_rate%TYPE DEFAULT NULL
156 ,px_period_amts_tbl IN OUT NOCOPY l_plan_txn_prd_amt_tbl
157 ,px_period_data_modified IN OUT NOCOPY VARCHAR2
158 -- End Bug 5726785
159 ,X_ETC_QTY OUT NOCOPY NUMBER
160 ,X_ETC_RAW_COST OUT NOCOPY NUMBER
161 ,X_ETC_BURDENED_COST OUT NOCOPY NUMBER
162 ,X_ETC_REVENUE OUT NOCOPY NUMBER
163 ,X_PERIOD_RATES_TBL OUT NOCOPY l_pds_rate_dtls_tab
164 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
165 ,X_MSG_DATA OUT NOCOPY VARCHAR2
166 ,X_MSG_COUNT OUT NOCOPY NUMBER);
167
168 END PA_FP_FCST_GEN_CLIENT_EXT;