eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BILLING_AMOUNT dependencies on PA_PROJECTS

Line 193: l_project_id pa_projects_all.project_id%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;
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;

Line 194: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

190: l_denominator Number;
191: l_numerator Number;
192: l_staus Varchar2(30);
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;

Line 195: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;

191: l_numerator Number;
192: l_staus Varchar2(30);
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;

Line 196: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

192: l_staus Varchar2(30);
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;

Line 201: l_invproc_currency_type pa_projects_all.invproc_currency_type%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;
205: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 205: l_project_currency_code pa_projects_all.project_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;
209: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 206: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%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;
209: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 207: l_project_bil_rate_type pa_projects_all.project_bil_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;
209: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 208: l_project_bil_rate_date pa_projects_all.project_bil_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;
209: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 209: l_project_bil_exchange_rate pa_projects_all.project_bil_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;
209: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_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;
209: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
214: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%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;
209: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
214: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
215: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

208: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
209: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
214: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
215: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
216: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

209: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
214: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
215: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
216: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
217: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 214: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

210: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
214: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
215: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
216: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
217: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
218: l_return_status VARCHAR2(30);

Line 215: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

211: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
214: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
215: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
216: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
217: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
218: l_return_status VARCHAR2(30);
219: l_msg_count NUMBER;

Line 216: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

212: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
214: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
215: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
216: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
217: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
218: l_return_status VARCHAR2(30);
219: l_msg_count NUMBER;
220: l_msg_data VARCHAR2(30);

Line 217: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

213: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
214: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
215: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
216: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
217: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
218: l_return_status VARCHAR2(30);
219: l_msg_count NUMBER;
220: l_msg_data VARCHAR2(30);
221:

Line 373: l_project_id pa_projects_all.project_id%TYPE;

369: l_denominator Number;
370: l_numerator Number;
371: l_staus Varchar2(30);
372: l_calling_process Varchar2(50);
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;

Line 374: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

370: l_numerator Number;
371: l_staus Varchar2(30);
372: l_calling_process Varchar2(50);
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;

Line 375: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

371: l_staus Varchar2(30);
372: l_calling_process Varchar2(50);
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;

Line 376: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

372: l_calling_process Varchar2(50);
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;

Line 381: l_invproc_currency_type pa_projects_all.invproc_currency_type%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;
385: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 385: l_project_currency_code pa_projects_all.project_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;
389: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 386: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%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;
389: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 387: l_project_bil_rate_type pa_projects_all.project_bil_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;
389: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 388: l_project_bil_rate_date pa_projects_all.project_bil_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;
389: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 389: l_project_bil_exchange_rate pa_projects_all.project_bil_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;
389: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_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;
389: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
394: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%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;
389: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
394: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
395: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

388: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
389: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
394: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
395: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
396: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

389: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
394: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
395: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
396: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
397: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 394: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

390: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
394: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
395: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
396: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
397: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
398: l_return_status VARCHAR2(30);

Line 395: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

391: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
394: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
395: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
396: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
397: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
398: l_return_status VARCHAR2(30);
399: l_msg_count NUMBER;

Line 396: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

392: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
394: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
395: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
396: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
397: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
398: l_return_status VARCHAR2(30);
399: l_msg_count NUMBER;
400: l_msg_data VARCHAR2(30);

Line 397: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

393: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
394: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
395: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
396: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
397: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
398: l_return_status VARCHAR2(30);
399: l_msg_count NUMBER;
400: l_msg_data VARCHAR2(30);
401:

Line 556: l_project_id pa_projects_all.project_id%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;
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;

Line 557: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

553: l_denominator Number;
554: l_numerator Number;
555: l_staus Varchar2(30);
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;

Line 558: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;

554: l_numerator Number;
555: l_staus Varchar2(30);
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;

Line 559: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

555: l_staus Varchar2(30);
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;

Line 564: l_invproc_currency_type pa_projects_all.invproc_currency_type%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;
568: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 568: l_project_currency_code pa_projects_all.project_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;
572: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 569: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%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;
572: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 570: l_project_bil_rate_type pa_projects_all.project_bil_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;
572: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 571: l_project_bil_rate_date pa_projects_all.project_bil_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;
572: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 572: l_project_bil_exchange_rate pa_projects_all.project_bil_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;
572: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_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;
572: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
577: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%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;
572: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
577: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
578: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

571: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
572: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
577: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
578: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
579: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

572: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
577: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
578: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
579: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
580: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 577: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

573: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
577: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
578: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
579: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
580: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
581: l_return_status VARCHAR2(30);

Line 578: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

574: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
577: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
578: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
579: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
580: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
581: l_return_status VARCHAR2(30);
582: l_msg_count NUMBER;

Line 579: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

575: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
577: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
578: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
579: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
580: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
581: l_return_status VARCHAR2(30);
582: l_msg_count NUMBER;
583: l_msg_data VARCHAR2(30);

Line 580: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

576: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
577: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
578: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
579: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
580: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
581: l_return_status VARCHAR2(30);
582: l_msg_count NUMBER;
583: l_msg_data VARCHAR2(30);
584:

Line 798: l_project_id pa_projects_all.project_id%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;
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;

Line 799: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

795: l_denominator Number;
796: l_numerator Number;
797: l_staus Varchar2(30);
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;

Line 800: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;

796: l_numerator Number;
797: l_staus Varchar2(30);
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;

Line 801: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

797: l_staus Varchar2(30);
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;

Line 806: l_invproc_currency_type pa_projects_all.invproc_currency_type%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;
810: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 810: l_project_currency_code pa_projects_all.project_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;
814: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 811: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%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;
814: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 812: l_project_bil_rate_type pa_projects_all.project_bil_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;
814: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 813: l_project_bil_rate_date pa_projects_all.project_bil_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;
814: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 814: l_project_bil_exchange_rate pa_projects_all.project_bil_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;
814: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_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;
814: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
819: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%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;
814: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
819: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
820: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

813: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
814: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
819: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
820: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
821: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

814: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
819: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
820: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
821: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
822: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 819: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

815: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
819: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
820: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
821: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
822: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
823: l_return_status VARCHAR2(30);

Line 820: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

816: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
819: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
820: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
821: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
822: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
823: l_return_status VARCHAR2(30);
824: l_msg_count NUMBER;

Line 821: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

817: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
819: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
820: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
821: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
822: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
823: l_return_status VARCHAR2(30);
824: l_msg_count NUMBER;
825: l_msg_data VARCHAR2(30);

Line 822: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

818: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
819: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
820: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
821: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
822: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
823: l_return_status VARCHAR2(30);
824: l_msg_count NUMBER;
825: l_msg_data VARCHAR2(30);
826:

Line 992: pa_projects p,

988: INTO lowest_revenue_amount,
989: lowest_invoice_amount
990: FROM pa_summary_project_fundings psf,
991: pa_agreements_all a, /* Changed table from pa_agreements to pa_agreements_all for MCB2 */
992: pa_projects p,
993: pa_project_customers pc
994: WHERE
995: a.agreement_id = psf.agreement_id
996: AND p.project_id = psf.project_id

Line 1101: FROM pa_projects_all

1097: c := 5;
1098:
1099: SELECT Decode(SUBSTR(distribution_rule,INSTR(distribution_rule,'/')+1),'COST','x','y') /* Added Decode for Bug 2389765 */
1100: INTO l_dummy
1101: FROM pa_projects_all
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'