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

Line 636: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 818: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1190: FROM pa_projects_all ppa , pa_project_statuses pps

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:

Line 1822: pa_projects_all p

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'

Line 1836: from PA_PROJECTS_ALL

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;