DBA Data[Home] [Help]

APPS.PA_BILLING_AMOUNT dependencies on PA_EVENTS

Line 180: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;

176:
177: pending_ccrev REAL;
178: accrued_ccrev REAL;
179: /* Varible for MCB2 */
180: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
181: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
182: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
183: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

Line 181: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;

177: pending_ccrev REAL;
178: accrued_ccrev REAL;
179: /* Varible for MCB2 */
180: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
181: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
182: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
183: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

Line 182: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;

178: accrued_ccrev REAL;
179: /* Varible for MCB2 */
180: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
181: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
182: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
183: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
186: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

Line 183: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

179: /* Varible for MCB2 */
180: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
181: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
182: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
183: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
186: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
187: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

Line 184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

180: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
181: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
182: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
183: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
186: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
187: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
188: l_event_date pa_events.completion_date%TYPE;

Line 185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

181: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
182: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
183: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
186: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
187: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
188: l_event_date pa_events.completion_date%TYPE;
189: l_conv_date pa_events.completion_date%TYPE;

Line 186: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

182: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
183: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
186: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
187: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
188: l_event_date pa_events.completion_date%TYPE;
189: l_conv_date pa_events.completion_date%TYPE;
190: l_denominator Number;

Line 187: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

183: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
186: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
187: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
188: l_event_date pa_events.completion_date%TYPE;
189: l_conv_date pa_events.completion_date%TYPE;
190: l_denominator Number;
191: l_numerator Number;

Line 188: l_event_date pa_events.completion_date%TYPE;

184: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
186: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
187: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
188: l_event_date pa_events.completion_date%TYPE;
189: l_conv_date pa_events.completion_date%TYPE;
190: l_denominator Number;
191: l_numerator Number;
192: l_staus Varchar2(30);

Line 189: l_conv_date pa_events.completion_date%TYPE;

185: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
186: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
187: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
188: l_event_date pa_events.completion_date%TYPE;
189: l_conv_date pa_events.completion_date%TYPE;
190: l_denominator Number;
191: l_numerator Number;
192: l_staus Varchar2(30);
193: l_project_id pa_projects_all.project_id%TYPE;

Line 197: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

193: l_project_id pa_projects_all.project_id%TYPE;
194: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
195: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
196: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
197: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
198: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
199: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
200: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
201: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 198: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

194: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
195: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
196: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
197: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
198: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
199: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
200: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
201: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
202: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 199: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

195: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
196: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
197: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
198: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
199: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
200: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
201: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
202: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
203: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 200: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

196: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
197: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
198: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
199: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
200: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
201: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
202: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
203: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
204: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 202: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

198: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
199: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
200: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
201: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
202: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
203: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
204: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
205: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
206: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 203: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

199: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
200: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
201: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
202: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
203: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
204: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
205: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
206: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
207: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 204: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

200: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
201: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
202: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
203: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
204: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
205: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
206: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
207: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
208: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 225: FROM pa_events e,

221:
222: CURSOR func_revenue(X2_project_id Number,X2_task_id Number) IS
223: SELECT NVL(e.bill_trans_rev_amount,0) trans_rev_amount,e.bill_trans_currency_code,
224: e.projfunc_currency_code,e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
225: FROM pa_events e,
226: pa_billing_assignments bea,
227: pa_billing_extensions be
228: where be.billing_extension_id = bea.billing_extension_id
229: and e.project_id = X2_project_id

Line 249: pa_events e,

245: WHERE dri.project_id = X2_project_id
246: AND nvl(dri.task_id,0) = decode(X2_task_id, NULL, nvl(dri.task_id,0), X2_task_id )
247: AND (EXISTS ( select '1'
248: from pa_cust_event_rev_dist_lines erdl,
249: pa_events e,
250: pa_billing_assignments bea,
251: pa_billing_extensions be
252: where be.billing_extension_id = bea.billing_extension_id
253: and bea.billing_assignment_id = e.billing_assignment_id

Line 272: FROM pa_events e,

268: /* The following code is commented because this amount is in RPC i.e. Revenue programm is going to populate this amount
269: */
270: /* SELECT sum(nvl(e.revenue_amount,0))
271: INTO pending_ccrev
272: FROM pa_events e,
273: pa_billing_assignments bea,
274: pa_billing_extensions be
275: where be.billing_extension_id = bea.billing_extension_id
276: and e.project_id = X2_project_id

Line 357: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;

353: X2_revenue_amount OUT NOCOPY REAL, --File.Sql.39 bug 4440895
354: X2_invoice_amount OUT NOCOPY REAL ) --File.Sql.39 bug 4440895
355: IS
356: /* Varibles added for MCB2 */
357: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
358: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
359: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
360: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;

Line 358: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;

354: X2_invoice_amount OUT NOCOPY REAL ) --File.Sql.39 bug 4440895
355: IS
356: /* Varibles added for MCB2 */
357: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
358: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
359: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
360: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

Line 359: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;

355: IS
356: /* Varibles added for MCB2 */
357: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
358: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
359: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
360: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

Line 360: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;

356: /* Varibles added for MCB2 */
357: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
358: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
359: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
360: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

Line 361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;

357: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
358: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
359: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
360: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
365: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

Line 362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

358: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
359: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
360: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
365: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
366: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

Line 363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

359: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
360: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
365: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
366: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
367: l_event_date pa_events.completion_date%TYPE;

Line 364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

360: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
365: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
366: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
367: l_event_date pa_events.completion_date%TYPE;
368: l_conv_date pa_events.completion_date%TYPE;

Line 365: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

361: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
365: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
366: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
367: l_event_date pa_events.completion_date%TYPE;
368: l_conv_date pa_events.completion_date%TYPE;
369: l_denominator Number;

Line 366: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

362: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
365: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
366: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
367: l_event_date pa_events.completion_date%TYPE;
368: l_conv_date pa_events.completion_date%TYPE;
369: l_denominator Number;
370: l_numerator Number;

Line 367: l_event_date pa_events.completion_date%TYPE;

363: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
365: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
366: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
367: l_event_date pa_events.completion_date%TYPE;
368: l_conv_date pa_events.completion_date%TYPE;
369: l_denominator Number;
370: l_numerator Number;
371: l_staus Varchar2(30);

Line 368: l_conv_date pa_events.completion_date%TYPE;

364: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
365: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
366: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
367: l_event_date pa_events.completion_date%TYPE;
368: l_conv_date pa_events.completion_date%TYPE;
369: l_denominator Number;
370: l_numerator Number;
371: l_staus Varchar2(30);
372: l_calling_process Varchar2(50);

Line 377: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

373: l_project_id pa_projects_all.project_id%TYPE;
374: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
375: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
376: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
377: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
378: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
379: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
380: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
381: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 378: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

374: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
375: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
376: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
377: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
378: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
379: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
380: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
381: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
382: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 379: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

375: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
376: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
377: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
378: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
379: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
380: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
381: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
382: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
383: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 380: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

376: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
377: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
378: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
379: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
380: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
381: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
382: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
383: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
384: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 382: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

378: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
379: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
380: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
381: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
382: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
383: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
384: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
385: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
386: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 383: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

379: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
380: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
381: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
382: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
383: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
384: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
385: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
386: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
387: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 384: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

380: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
381: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
382: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
383: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
384: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
385: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
386: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
387: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
388: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 415: FROM pa_events e,

411: (DECODE(et.event_type_classification,'INVOICE REDUCTION', -1 * NVL(e.bill_trans_bill_amount,0),
412: NVL(e.bill_trans_bill_amount,0))) trans_bill_amount,
413: e.bill_trans_currency_code,e.projfunc_currency_code,e.projfunc_rate_type,
414: e.projfunc_rate_date,e.projfunc_exchange_rate
415: FROM pa_events e,
416: pa_event_types et
417: WHERE e.event_type = et.event_type
418: AND e.project_id = X2_project_id
419: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))

Line 441: FROM pa_events e,

437: 'INVOICE REDUCTION', -1 * nvl(bill_amount,0),
438: nvl(bill_amount,0)))
439: INTO X2_revenue_amount,
440: X2_invoice_amount
441: FROM pa_events e,
442: pa_event_types et
443: WHERE e.event_type = et.event_type
444: AND e.project_id = X2_project_id
445: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))

Line 543: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;

539: task_billed_ev_ccinv REAL;
540: billed_ccinv REAL;
541:
542: /* Varibles added for MCB2 */
543: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
544: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
545: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
546: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

Line 544: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;

540: billed_ccinv REAL;
541:
542: /* Varibles added for MCB2 */
543: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
544: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
545: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
546: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

Line 545: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;

541:
542: /* Varibles added for MCB2 */
543: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
544: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
545: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
546: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
549: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

Line 546: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

542: /* Varibles added for MCB2 */
543: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
544: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
545: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
546: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
549: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
550: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

Line 547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

543: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
544: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
545: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
546: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
549: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
550: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
551: l_event_date pa_events.completion_date%TYPE;

Line 548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

544: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
545: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
546: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
549: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
550: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
551: l_event_date pa_events.completion_date%TYPE;
552: l_conv_date pa_events.completion_date%TYPE;

Line 549: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

545: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
546: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
549: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
550: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
551: l_event_date pa_events.completion_date%TYPE;
552: l_conv_date pa_events.completion_date%TYPE;
553: l_denominator Number;

Line 550: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

546: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
549: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
550: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
551: l_event_date pa_events.completion_date%TYPE;
552: l_conv_date pa_events.completion_date%TYPE;
553: l_denominator Number;
554: l_numerator Number;

Line 551: l_event_date pa_events.completion_date%TYPE;

547: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
549: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
550: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
551: l_event_date pa_events.completion_date%TYPE;
552: l_conv_date pa_events.completion_date%TYPE;
553: l_denominator Number;
554: l_numerator Number;
555: l_staus Varchar2(30);

Line 552: l_conv_date pa_events.completion_date%TYPE;

548: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
549: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
550: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
551: l_event_date pa_events.completion_date%TYPE;
552: l_conv_date pa_events.completion_date%TYPE;
553: l_denominator Number;
554: l_numerator Number;
555: l_staus Varchar2(30);
556: l_project_id pa_projects_all.project_id%TYPE;

Line 560: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

556: l_project_id pa_projects_all.project_id%TYPE;
557: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
558: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
559: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
560: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
561: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
562: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
563: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
564: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 561: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

557: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
558: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
559: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
560: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
561: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
562: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
563: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
564: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
565: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 562: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

558: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
559: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
560: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
561: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
562: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
563: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
564: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
565: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
566: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 563: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

559: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
560: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
561: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
562: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
563: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
564: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
565: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
566: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
567: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 565: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

561: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
562: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
563: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
564: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
565: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
566: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
567: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
568: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
569: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 566: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

562: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
563: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
564: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
565: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
566: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
567: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
568: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
569: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
570: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 567: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

563: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
564: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
565: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
566: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
567: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
568: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
569: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
570: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
571: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 591: FROM pa_events e,

587: CURSOR func_invoice(X2_project_id Number,X2_task_id Number) IS
588: SELECT NVL(e.bill_trans_bill_amount,0) trans_bill_amount,e.bill_trans_currency_code,
589: e.projfunc_currency_code,
590: e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
591: FROM pa_events e,
592: pa_billing_assignments bea,
593: pa_billing_extensions be
594: WHERE be.billing_extension_id = bea.billing_extension_id
595: AND bea.billing_assignment_id = e.billing_assignment_id

Line 621: from pa_events e,

617:
618: /*
619: SELECT sum(nvl(e.bill_amount,0))
620: INTO pending_ccinv
621: from pa_events e,
622: pa_billing_assignments bea,
623: pa_billing_extensions be
624: where be.billing_extension_id = bea.billing_extension_id
625: and bea.billing_assignment_id = e.billing_assignment_id

Line 710: from pa_events e,

706: INTO billed_ccinv
707: FROM pa_draft_invoice_items dii
708: WHERE dii.project_id = X2_project_id
709: AND (EXISTS (select '1'
710: from pa_events e,
711: pa_billing_assignments bea,
712: pa_billing_extensions be
713: where be.billing_extension_id = bea.billing_extension_id
714: and bea.billing_assignment_id = e.billing_assignment_id

Line 751: from pa_events e,

747: FROM pa_draft_invoice_items pdii
748: WHERE pdii.event_task_id = X2_task_id
749: AND pdii.Project_ID = X2_Project_ID -- Perf Bug 2695243
750: AND EXISTS (select '1'
751: from pa_events e,
752: pa_billing_assignments bea,
753: pa_billing_extensions be
754: where be.billing_extension_id = bea.billing_extension_id
755: and bea.billing_assignment_id = e.billing_assignment_id

Line 783: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;

779: lowest_invoice_amount REAL := 0;
780: current_event_revenue REAL := 0;
781: current_event_invoice REAL := 0;
782:
783: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
784: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
785: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
786: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;

Line 784: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;

780: current_event_revenue REAL := 0;
781: current_event_invoice REAL := 0;
782:
783: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
784: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
785: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
786: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

Line 785: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;

781: current_event_invoice REAL := 0;
782:
783: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
784: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
785: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
786: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

Line 786: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;

782:
783: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
784: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
785: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
786: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

Line 787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;

783: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
784: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
785: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
786: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
791: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

Line 788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

784: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
785: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
786: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
791: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
792: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

Line 789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

785: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
786: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
791: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
792: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
793: l_event_date pa_events.completion_date%TYPE;

Line 790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

786: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
791: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
792: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
793: l_event_date pa_events.completion_date%TYPE;
794: l_conv_date pa_events.completion_date%TYPE;

Line 791: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

787: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
791: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
792: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
793: l_event_date pa_events.completion_date%TYPE;
794: l_conv_date pa_events.completion_date%TYPE;
795: l_denominator Number;

Line 792: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

788: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
791: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
792: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
793: l_event_date pa_events.completion_date%TYPE;
794: l_conv_date pa_events.completion_date%TYPE;
795: l_denominator Number;
796: l_numerator Number;

Line 793: l_event_date pa_events.completion_date%TYPE;

789: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
791: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
792: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
793: l_event_date pa_events.completion_date%TYPE;
794: l_conv_date pa_events.completion_date%TYPE;
795: l_denominator Number;
796: l_numerator Number;
797: l_staus Varchar2(30);

Line 794: l_conv_date pa_events.completion_date%TYPE;

790: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
791: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
792: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
793: l_event_date pa_events.completion_date%TYPE;
794: l_conv_date pa_events.completion_date%TYPE;
795: l_denominator Number;
796: l_numerator Number;
797: l_staus Varchar2(30);
798: l_project_id pa_projects_all.project_id%TYPE;

Line 802: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

798: l_project_id pa_projects_all.project_id%TYPE;
799: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
800: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
801: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
802: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
803: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
804: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
805: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
806: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 803: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

799: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
800: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
801: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
802: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
803: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
804: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
805: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
806: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
807: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 804: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

800: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
801: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
802: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
803: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
804: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
805: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
806: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
807: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
808: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 805: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

801: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
802: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
803: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
804: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
805: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
806: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
807: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
808: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
809: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 807: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

803: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
804: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
805: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
806: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
807: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
808: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
809: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
810: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
811: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 808: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

804: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
805: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
806: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
807: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
808: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
809: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
810: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
811: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
812: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 809: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

805: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
806: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
807: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
808: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
809: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
810: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
811: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
812: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
813: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 836: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii

832: SELECT DECODE(e.revenue_distributed_flag,'N', NVL(e.bill_trans_rev_amount,0),0) trans_rev_amount,
833: DECODE(pdii.event_num,NULL, NVL(e.bill_trans_bill_amount,0),0) trans_bill_amount,
834: e.bill_trans_currency_code,
835: e.projfunc_currency_code,e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
836: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii
837: WHERE e.project_id = X2_project_id
838: AND pdii.project_id (+)= e.project_id
839: AND pdii.event_num (+)= e.event_num
840: AND nvl(pdii.event_task_id,0) = nvl(e.task_id,0)

Line 863: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii

859: sum(decode(pdii.event_num,
860: NULL, nvl(e.bill_amount,0),
861: 0))
862: INTO current_event_revenue, current_event_invoice
863: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii
864: WHERE e.project_id = X2_project_id
865: AND pdii.project_id (+)= e.project_id
866: and pdii.event_num (+)= e.event_num
867: and nvl(pdii.event_task_id,0) = nvl(e.task_id,0)

Line 1106: from pa_events e,

1102: WHERE project_id = X_project_id
1103: AND substr(distribution_rule,1,instr(distribution_rule,'/')-1)
1104: IN ('COST','EVENT')
1105: AND exists ( select 'x'
1106: from pa_events e,
1107: pa_event_types et
1108: where e.project_id = X_project_id
1109: and e.event_type = et.event_type
1110: and et.event_type_classification = 'SCHEDULED PAYMENTS');