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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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);
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;
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);
1476:
1477: Begin
1478: Select NVL(Enable_Top_Task_Customer_Flag, 'N')
1479: Into l_Enable_Top_Task_Cust_Flag
1480: From PA_Projects_all
1481: Where Project_ID = P_Project_ID;
1482:
1483: Return l_Enable_Top_Task_Cust_Flag;
1484:
1498:
1499: Begin
1500: Select NVL(ENABLE_TOP_TASK_INV_MTH_FLAG, 'N')
1501: Into l_ENABLE_TOP_TASK_INV_MTH_FLAG
1502: From PA_Projects_all
1503: Where Project_ID = P_Project_ID;
1504:
1505: Return l_ENABLE_TOP_TASK_INV_MTH_FLAG;
1506:
1601: err_message VARCHAR2(240);
1602: l_event_id NUMBER;
1603:
1604: /* MCB related changes as of 08/21/2001 by skannoji */
1605: l_project_id pa_projects_all.project_id%TYPE;
1606: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1607: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
1608: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
1602: l_event_id NUMBER;
1603:
1604: /* MCB related changes as of 08/21/2001 by skannoji */
1605: l_project_id pa_projects_all.project_id%TYPE;
1606: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1607: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
1608: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
1603:
1604: /* MCB related changes as of 08/21/2001 by skannoji */
1605: l_project_id pa_projects_all.project_id%TYPE;
1606: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1607: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
1608: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
1604: /* MCB related changes as of 08/21/2001 by skannoji */
1605: l_project_id pa_projects_all.project_id%TYPE;
1606: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1607: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
1608: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
1613: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
1617: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1613: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
1617: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1618: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
1619: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1620: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
1621: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
1617: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1618: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
1619: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1620: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
1621: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
1622: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
1617: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1618: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
1619: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1620: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
1621: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
1622: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1623: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
1617: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1618: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
1619: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1620: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
1621: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
1622: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1623: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
1624: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1617: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1618: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
1619: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1620: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
1621: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
1622: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1623: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
1624: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1625: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
1618: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
1619: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1620: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
1621: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
1622: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1623: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
1624: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1625: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
1626: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
1619: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1620: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
1621: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
1622: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1623: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
1624: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1625: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
1626: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
1627: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1620: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
1621: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
1622: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1623: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
1624: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1625: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
1626: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
1627: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1628: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
1621: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
1622: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1623: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
1624: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1625: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
1626: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
1627: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1628: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
1629: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
1622: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1623: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
1624: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1625: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
1626: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
1627: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1628: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
1629: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
1630: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
1623: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
1624: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1625: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
1626: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
1627: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1628: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
1629: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
1630: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
1631: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
1624: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1625: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
1626: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
1627: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1628: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
1629: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
1630: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
1631: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
1632: l_return_status VARCHAR2(30);
1625: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
1626: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
1627: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1628: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
1629: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
1630: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
1631: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
1632: l_return_status VARCHAR2(30);
1633: l_msg_count NUMBER;
1626: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
1627: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1628: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
1629: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
1630: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
1631: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
1632: l_return_status VARCHAR2(30);
1633: l_msg_count NUMBER;
1634: l_msg_data VARCHAR2(30);