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_BILL_PCT dependencies on PA_PROJECTS_ALL

Line 50: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

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;

Line 51: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%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;

Line 52: l_revproc_currency_code pa_projects_all.revproc_currency_code%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;

Line 57: l_invproc_currency_type pa_projects_all.invproc_currency_type%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;

Line 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;

Line 62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%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;

Line 63: l_project_bil_rate_type pa_projects_all.project_bil_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;
67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 64: l_project_bil_rate_date pa_projects_all.project_bil_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;
68: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 65: l_project_bil_exchange_rate pa_projects_all.project_bil_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;
69: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 66: l_projfunc_currency_code pa_projects_all.projfunc_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;
70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 67: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_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;
71: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 68: l_projfunc_bil_rate_type pa_projects_all.projfunc_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;
72: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 69: l_projfunc_bil_rate_date pa_projects_all.projfunc_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;
73: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 70: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_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;
74: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 71: l_funding_rate_date_code pa_projects_all.funding_rate_date_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;
75: l_return_status VARCHAR2(30);

Line 72: l_funding_rate_type pa_projects_all.funding_rate_type%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);
76: l_msg_count NUMBER;

Line 73: l_funding_rate_date pa_projects_all.funding_rate_date%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;
77: l_msg_data VARCHAR2(30);

Line 74: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%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);
78:

Line 450: l_project_id pa_projects_all.project_id%TYPE;

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;

Line 451: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%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;

Line 452: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%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;

Line 453: l_revproc_currency_code pa_projects_all.revproc_currency_code%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;

Line 458: l_invproc_currency_type pa_projects_all.invproc_currency_type%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;

Line 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;

Line 463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%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;

Line 464: l_project_bil_rate_type pa_projects_all.project_bil_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;
468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 465: l_project_bil_rate_date pa_projects_all.project_bil_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;
469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 466: l_project_bil_exchange_rate pa_projects_all.project_bil_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;
470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 467: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_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;
471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 468: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%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;

Line 469: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%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;

Line 470: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%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;

Line 471: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%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);

Line 472: l_funding_rate_type pa_projects_all.funding_rate_type%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);
476: l_msg_count NUMBER;

Line 473: l_funding_rate_date pa_projects_all.funding_rate_date%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;
477: l_msg_data VARCHAR2(30);

Line 474: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%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);
478:

Line 633: l_project_id pa_projects_all.project_id%TYPE;

629: l_conv_date pa_events.completion_date%TYPE;
630: l_denominator Number;
631: l_numerator Number;
632: l_staus Varchar2(30);
633: l_project_id pa_projects_all.project_id%TYPE;
634: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
635: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
636: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

Line 634: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

630: l_denominator Number;
631: l_numerator Number;
632: l_staus Varchar2(30);
633: l_project_id pa_projects_all.project_id%TYPE;
634: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
635: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
636: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

Line 635: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;

631: l_numerator Number;
632: l_staus Varchar2(30);
633: l_project_id pa_projects_all.project_id%TYPE;
634: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
635: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
636: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

Line 636: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

632: l_staus Varchar2(30);
633: l_project_id pa_projects_all.project_id%TYPE;
634: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
635: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
636: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

Line 641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
654: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
654: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
655: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
654: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
655: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
656: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

649: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
654: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
655: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
656: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
657: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 654: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

650: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
654: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
655: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
656: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
657: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
658: l_return_status VARCHAR2(30);

Line 655: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

651: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
654: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
655: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
656: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
657: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
658: l_return_status VARCHAR2(30);
659: l_msg_count NUMBER;

Line 656: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

652: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
654: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
655: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
656: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
657: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
658: l_return_status VARCHAR2(30);
659: l_msg_count NUMBER;
660: l_msg_data VARCHAR2(30);

Line 657: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

653: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
654: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
655: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
656: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
657: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
658: l_return_status VARCHAR2(30);
659: l_msg_count NUMBER;
660: l_msg_data VARCHAR2(30);
661:

Line 824: l_project_id pa_projects_all.project_id%TYPE;

820: l_conv_date pa_events.completion_date%TYPE;
821: l_denominator Number;
822: l_numerator Number;
823: l_staus Varchar2(30);
824: l_project_id pa_projects_all.project_id%TYPE;
825: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
826: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
827: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

Line 825: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

821: l_denominator Number;
822: l_numerator Number;
823: l_staus Varchar2(30);
824: l_project_id pa_projects_all.project_id%TYPE;
825: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
826: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
827: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

Line 826: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;

822: l_numerator Number;
823: l_staus Varchar2(30);
824: l_project_id pa_projects_all.project_id%TYPE;
825: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
826: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
827: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

Line 827: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

823: l_staus Varchar2(30);
824: l_project_id pa_projects_all.project_id%TYPE;
825: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
826: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
827: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

Line 832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
845: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
845: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
846: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
845: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
846: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
847: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

840: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
845: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
846: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
847: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
848: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 845: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

841: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
845: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
846: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
847: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
848: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
849: l_return_status VARCHAR2(30);

Line 846: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

842: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
845: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
846: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
847: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
848: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
849: l_return_status VARCHAR2(30);
850: l_msg_count NUMBER;

Line 847: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

843: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
845: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
846: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
847: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
848: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
849: l_return_status VARCHAR2(30);
850: l_msg_count NUMBER;
851: l_msg_data VARCHAR2(30);

Line 848: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

844: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
845: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
846: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
847: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
848: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
849: l_return_status VARCHAR2(30);
850: l_msg_count NUMBER;
851: l_msg_data VARCHAR2(30);
852: