632: event_description VARCHAR2(240);
633: l_currency_code VARCHAR2(15);
634:
635: /* Declaring varible for MCB2 */
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_currency_code VARCHAR2(15);
634:
635: /* Declaring varible for MCB2 */
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:
635: /* Declaring varible for MCB2 */
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_currency_code pa_projects_all.projfunc_currency_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_currency_code pa_projects_all.projfunc_currency_code%TYPE;
653: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%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_currency_code pa_projects_all.projfunc_currency_code%TYPE;
653: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
654: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%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_currency_code pa_projects_all.projfunc_currency_code%TYPE;
653: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
654: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
655: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%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_currency_code pa_projects_all.projfunc_currency_code%TYPE;
653: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
654: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
655: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
656: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%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_currency_code pa_projects_all.projfunc_currency_code%TYPE;
653: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
654: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
655: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
656: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
657: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%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_currency_code pa_projects_all.projfunc_currency_code%TYPE;
653: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
654: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
655: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
656: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
657: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
658: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
651: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
652: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
653: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
654: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
655: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
656: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
657: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
658: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
659: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
652: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
653: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
654: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
655: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
656: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
657: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
658: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
659: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
660: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
653: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
654: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
655: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
656: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
657: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
658: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
659: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
660: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
661: l_return_status VARCHAR2(30);
654: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
655: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
656: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
657: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
658: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
659: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
660: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
661: l_return_status VARCHAR2(30);
662: l_msg_count NUMBER;
655: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
656: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
657: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
658: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
659: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
660: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
661: l_return_status VARCHAR2(30);
662: l_msg_count NUMBER;
663: l_msg_data VARCHAR2(30);
656: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
657: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
658: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
659: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
660: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
661: l_return_status VARCHAR2(30);
662: l_msg_count NUMBER;
663: l_msg_data VARCHAR2(30);
664:
814: event_description VARCHAR2(240);
815: l_currency_code VARCHAR2(15);
816:
817: /* Declaring varible for MCB2 */
818: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
819: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
820: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
821: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
815: l_currency_code VARCHAR2(15);
816:
817: /* Declaring varible for MCB2 */
818: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
819: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
820: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
821: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
816:
817: /* Declaring varible for MCB2 */
818: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
819: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
820: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
821: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
821: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
825: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
829: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
825: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
829: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
830: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
831: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
832: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
833: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
829: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
830: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
831: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
832: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
833: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
834: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
829: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
830: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
831: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
832: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
833: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
834: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
835: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
829: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
830: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
831: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
832: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
833: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
834: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
835: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
836: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
829: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
830: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
831: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
832: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
833: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
834: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
835: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
836: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
837: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
830: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
831: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
832: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
833: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
834: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
835: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
836: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
837: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
838: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
831: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
832: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
833: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
834: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
835: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
836: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
837: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
838: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
839: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
832: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
833: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
834: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
835: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
836: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
837: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
838: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
839: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
840: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
833: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
834: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
835: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
836: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
837: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
838: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
839: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
840: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
841: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
834: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
835: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
836: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
837: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
838: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
839: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
840: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
841: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
842: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
835: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
836: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
837: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
838: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
839: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
840: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
841: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
842: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
843: l_return_status VARCHAR2(30);
836: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
837: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
838: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
839: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
840: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
841: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
842: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
843: l_return_status VARCHAR2(30);
844: l_msg_count NUMBER;
837: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
838: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
839: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
840: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
841: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
842: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
843: l_return_status VARCHAR2(30);
844: l_msg_count NUMBER;
845: l_msg_data VARCHAR2(30);
838: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
839: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
840: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
841: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
842: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
843: l_return_status VARCHAR2(30);
844: l_msg_count NUMBER;
845: l_msg_data VARCHAR2(30);
846:
1186: -- Select the project system status code
1187:
1188: SELECT pps.project_system_status_code
1189: INTO l_project_status
1190: FROM pa_projects_all ppa , pa_project_statuses pps
1191: WHERE ppa.project_id = x_project_id
1192: AND ppa.project_status_code = pps.project_status_code
1193: AND pps.status_type = 'PROJECT';
1194:
1818: l_ca_wip_event_type,
1819: l_ca_budget_type
1820: from pa_billing_extensions be,
1821: pa_billing_assignments_all bea,
1822: pa_projects_all p
1823: where p.project_id = p_project_id
1824: and bea.active_flag = 'Y'
1825: and bea.billing_extension_id = be.billing_extension_id
1826: and be.attribute11 = 'COST-ACCRUAL'
1832: IF l_Check_For_Proj_Type = 1 THEN
1833: Begin
1834: Select Project_type, Org_ID , NVL(PROJECT_LEVEL_FUNDING_FLAG,'X')
1835: INTO l_Project_Type, l_Org_ID, l_funding_flag1
1836: from PA_PROJECTS_ALL
1837: where Project_ID = P_Project_ID;
1838: Exception when no_data_found then
1839: l_cost_accrual_flag := 'N';
1840: l_Check_For_Proj_Type := 0;