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

APPS.PA_BILLING_PUB dependencies on PA_PROJECTS_ALL

Line 766: l_project_id pa_projects_all.project_id%TYPE;

762: err_status NUMBER;
763: err_message VARCHAR2(240);
764:
765: /* MCB related changes as of 08/21/2001 by skannoji */
766: l_project_id pa_projects_all.project_id%TYPE;
767: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
768: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
769: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

Line 767: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

763: err_message VARCHAR2(240);
764:
765: /* MCB related changes as of 08/21/2001 by skannoji */
766: l_project_id pa_projects_all.project_id%TYPE;
767: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
768: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
769: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

Line 768: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

764:
765: /* MCB related changes as of 08/21/2001 by skannoji */
766: l_project_id pa_projects_all.project_id%TYPE;
767: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
768: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
769: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

Line 769: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

765: /* MCB related changes as of 08/21/2001 by skannoji */
766: l_project_id pa_projects_all.project_id%TYPE;
767: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
768: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
769: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

Line 774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
789: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

782: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
789: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
790: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

783: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
789: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
790: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
791: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

784: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
789: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
790: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
791: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
792: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

Line 789: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

785: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
789: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
790: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
791: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
792: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
793: l_return_status VARCHAR2(30);

Line 790: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

786: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
789: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
790: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
791: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
792: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
793: l_return_status VARCHAR2(30);
794: l_msg_count NUMBER;

Line 791: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

787: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
789: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
790: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
791: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
792: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
793: l_return_status VARCHAR2(30);
794: l_msg_count NUMBER;
795: l_msg_data VARCHAR2(30);

Line 1479: From PA_Projects_all

1475:
1476: Begin
1477: Select NVL(Enable_Top_Task_Customer_Flag, 'N')
1478: Into l_Enable_Top_Task_Cust_Flag
1479: From PA_Projects_all
1480: Where Project_ID = P_Project_ID;
1481:
1482: Return l_Enable_Top_Task_Cust_Flag;
1483:

Line 1501: From PA_Projects_all

1497:
1498: Begin
1499: Select NVL(ENABLE_TOP_TASK_INV_MTH_FLAG, 'N')
1500: Into l_ENABLE_TOP_TASK_INV_MTH_FLAG
1501: From PA_Projects_all
1502: Where Project_ID = P_Project_ID;
1503:
1504: Return l_ENABLE_TOP_TASK_INV_MTH_FLAG;
1505: