46:
47: pct_error EXCEPTION;
48:
49: /* Declaring varible for MCB2 */
50: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
51: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
52: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
53: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
47: pct_error EXCEPTION;
48:
49: /* Declaring varible for MCB2 */
50: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
51: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
52: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
53: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
48:
49: /* Declaring varible for MCB2 */
50: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
51: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
52: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
53: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
53: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
57: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
61: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
57: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
61: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
63: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
64: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
65: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
61: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
63: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
64: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
65: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
66: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
61: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
63: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
64: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
65: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
66: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
61: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
63: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
64: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
65: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
66: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
61: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
63: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
64: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
65: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
66: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
63: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
64: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
65: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
66: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
63: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
64: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
65: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
66: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
71: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
64: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
65: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
66: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
71: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
72: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
65: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
66: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
71: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
72: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
73: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
66: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
71: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
72: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
73: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
74: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
71: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
72: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
73: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
74: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
75: l_return_status VARCHAR2(30);
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
71: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
72: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
73: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
74: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
75: l_return_status VARCHAR2(30);
76: l_msg_count NUMBER;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
71: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
72: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
73: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
74: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
75: l_return_status VARCHAR2(30);
76: l_msg_count NUMBER;
77: l_msg_data VARCHAR2(30);
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
71: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
72: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
73: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
74: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
75: l_return_status VARCHAR2(30);
76: l_msg_count NUMBER;
77: l_msg_data VARCHAR2(30);
78:
446: l_denominator Number;
447: l_numerator Number;
448: l_staus Varchar2(30);
449: l_calling_process Varchar2(50);
450: l_project_id pa_projects_all.project_id%TYPE;
451: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
452: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
453: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
447: l_numerator Number;
448: l_staus Varchar2(30);
449: l_calling_process Varchar2(50);
450: l_project_id pa_projects_all.project_id%TYPE;
451: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
452: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
453: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
448: l_staus Varchar2(30);
449: l_calling_process Varchar2(50);
450: l_project_id pa_projects_all.project_id%TYPE;
451: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
452: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
453: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
449: l_calling_process Varchar2(50);
450: l_project_id pa_projects_all.project_id%TYPE;
451: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
452: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
453: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
458: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
462: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
458: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
462: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
464: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
465: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
466: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
462: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
464: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
465: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
466: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
462: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
464: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
465: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
466: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
462: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
464: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
465: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
466: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
462: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
464: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
465: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
466: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
464: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
465: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
466: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
464: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
465: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
466: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
472: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
465: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
466: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
472: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
473: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
466: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
472: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
473: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
474: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
472: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
473: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
474: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
475: l_return_status VARCHAR2(30);
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
472: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
473: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
474: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
475: l_return_status VARCHAR2(30);
476: l_msg_count NUMBER;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
472: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
473: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
474: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
475: l_return_status VARCHAR2(30);
476: l_msg_count NUMBER;
477: l_msg_data VARCHAR2(30);
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
472: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
473: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
474: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
475: l_return_status VARCHAR2(30);
476: l_msg_count NUMBER;
477: l_msg_data VARCHAR2(30);
478:
631: l_conv_date pa_events.completion_date%TYPE;
632: l_denominator Number;
633: l_numerator Number;
634: l_staus Varchar2(30);
635: l_project_id pa_projects_all.project_id%TYPE;
636: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
637: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
638: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
632: l_denominator Number;
633: l_numerator Number;
634: l_staus Varchar2(30);
635: l_project_id pa_projects_all.project_id%TYPE;
636: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
637: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
638: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
633: l_numerator Number;
634: l_staus Varchar2(30);
635: l_project_id pa_projects_all.project_id%TYPE;
636: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
637: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
638: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
634: l_staus Varchar2(30);
635: l_project_id pa_projects_all.project_id%TYPE;
636: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
637: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
638: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
643: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
647: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
643: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
647: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
648: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
649: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
650: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
647: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
648: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
649: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
650: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
652: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
647: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
648: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
649: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
650: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
652: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
653: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
647: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
648: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
649: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
650: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
652: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
653: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
654: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
647: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
648: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
649: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
650: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
652: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
653: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
654: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
655: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
648: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
649: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
650: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
652: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
653: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
654: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
655: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
656: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
649: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
650: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
652: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
653: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
654: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
655: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
656: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
657: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
650: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
652: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
653: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
654: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
655: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
656: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
657: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
658: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
652: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
653: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
654: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
655: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
656: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
657: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
658: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
659: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
652: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
653: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
654: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
655: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
656: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
657: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
658: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
659: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
660: l_return_status VARCHAR2(30);
653: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
654: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
655: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
656: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
657: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
658: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
659: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
660: l_return_status VARCHAR2(30);
661: l_msg_count NUMBER;
654: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
655: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
656: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
657: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
658: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
659: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
660: l_return_status VARCHAR2(30);
661: l_msg_count NUMBER;
662: l_msg_data VARCHAR2(30);
655: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
656: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
657: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
658: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
659: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
660: l_return_status VARCHAR2(30);
661: l_msg_count NUMBER;
662: l_msg_data VARCHAR2(30);
663:
822: l_conv_date pa_events.completion_date%TYPE;
823: l_denominator Number;
824: l_numerator Number;
825: l_staus Varchar2(30);
826: l_project_id pa_projects_all.project_id%TYPE;
827: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
828: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
829: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
830: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
823: l_denominator Number;
824: l_numerator Number;
825: l_staus Varchar2(30);
826: l_project_id pa_projects_all.project_id%TYPE;
827: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
828: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
829: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
830: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
831: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
824: l_numerator Number;
825: l_staus Varchar2(30);
826: l_project_id pa_projects_all.project_id%TYPE;
827: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
828: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
829: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
830: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
831: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
832: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
825: l_staus Varchar2(30);
826: l_project_id pa_projects_all.project_id%TYPE;
827: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
828: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
829: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
830: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
831: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
832: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
833: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
830: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
831: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
832: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
833: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
834: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
835: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
836: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
837: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
838: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
834: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
835: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
836: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
837: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
838: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
839: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
840: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
841: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
842: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
835: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
836: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
837: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
838: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
839: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
840: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
841: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
842: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
843: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
836: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
837: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
838: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
839: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
840: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
841: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
842: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
843: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
844: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
837: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
838: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
839: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
840: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
841: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
842: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
843: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
844: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
845: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
838: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
839: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
840: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
841: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
842: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
843: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
844: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
845: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
846: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
839: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
840: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
841: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
842: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
843: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
844: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
845: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
846: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
847: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
840: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
841: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
842: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
843: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
844: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
845: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
846: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
847: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
848: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
841: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
842: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
843: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
844: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
845: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
846: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
847: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
848: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
849: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
842: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
843: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
844: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
845: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
846: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
847: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
848: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
849: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
850: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
843: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
844: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
845: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
846: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
847: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
848: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
849: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
850: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
851: l_return_status VARCHAR2(30);
844: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
845: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
846: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
847: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
848: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
849: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
850: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
851: l_return_status VARCHAR2(30);
852: l_msg_count NUMBER;
845: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
846: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
847: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
848: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
849: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
850: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
851: l_return_status VARCHAR2(30);
852: l_msg_count NUMBER;
853: l_msg_data VARCHAR2(30);
846: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
847: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
848: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
849: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
850: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
851: l_return_status VARCHAR2(30);
852: l_msg_count NUMBER;
853: l_msg_data VARCHAR2(30);
854: