847: l_temp_last NUMBER;
848: l_fia_index NUMBER;
849: l_fia_upd_index NUMBER;
850: l_fetch_size NUMBER(5) := 200;
851: l_t_LINE_NUM Pa_Fi_Amount_Details.LINE_NUM%TYPE;
852: l_t_ITEM_QUANTITY Pa_Fi_Amount_Details.ITEM_QUANTITY%TYPE;
853: l_t_COST_TXN_CURR_CODE Pa_Fi_Amount_Details.COST_TXN_CURRENCY_CODE%TYPE;
854: l_t_REV_TXN_CURR_CODE Pa_Fi_Amount_Details.REVENUE_TXN_CURRENCY_CODE%TYPE;
855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%TYPE;
848: l_fia_index NUMBER;
849: l_fia_upd_index NUMBER;
850: l_fetch_size NUMBER(5) := 200;
851: l_t_LINE_NUM Pa_Fi_Amount_Details.LINE_NUM%TYPE;
852: l_t_ITEM_QUANTITY Pa_Fi_Amount_Details.ITEM_QUANTITY%TYPE;
853: l_t_COST_TXN_CURR_CODE Pa_Fi_Amount_Details.COST_TXN_CURRENCY_CODE%TYPE;
854: l_t_REV_TXN_CURR_CODE Pa_Fi_Amount_Details.REVENUE_TXN_CURRENCY_CODE%TYPE;
855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%TYPE;
856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%TYPE;
849: l_fia_upd_index NUMBER;
850: l_fetch_size NUMBER(5) := 200;
851: l_t_LINE_NUM Pa_Fi_Amount_Details.LINE_NUM%TYPE;
852: l_t_ITEM_QUANTITY Pa_Fi_Amount_Details.ITEM_QUANTITY%TYPE;
853: l_t_COST_TXN_CURR_CODE Pa_Fi_Amount_Details.COST_TXN_CURRENCY_CODE%TYPE;
854: l_t_REV_TXN_CURR_CODE Pa_Fi_Amount_Details.REVENUE_TXN_CURRENCY_CODE%TYPE;
855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%TYPE;
856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%TYPE;
857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %TYPE;
850: l_fetch_size NUMBER(5) := 200;
851: l_t_LINE_NUM Pa_Fi_Amount_Details.LINE_NUM%TYPE;
852: l_t_ITEM_QUANTITY Pa_Fi_Amount_Details.ITEM_QUANTITY%TYPE;
853: l_t_COST_TXN_CURR_CODE Pa_Fi_Amount_Details.COST_TXN_CURRENCY_CODE%TYPE;
854: l_t_REV_TXN_CURR_CODE Pa_Fi_Amount_Details.REVENUE_TXN_CURRENCY_CODE%TYPE;
855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%TYPE;
856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%TYPE;
857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %TYPE;
858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%TYPE;
851: l_t_LINE_NUM Pa_Fi_Amount_Details.LINE_NUM%TYPE;
852: l_t_ITEM_QUANTITY Pa_Fi_Amount_Details.ITEM_QUANTITY%TYPE;
853: l_t_COST_TXN_CURR_CODE Pa_Fi_Amount_Details.COST_TXN_CURRENCY_CODE%TYPE;
854: l_t_REV_TXN_CURR_CODE Pa_Fi_Amount_Details.REVENUE_TXN_CURRENCY_CODE%TYPE;
855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%TYPE;
856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%TYPE;
857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %TYPE;
858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%TYPE;
859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_TXN_CURRENCY_CODE%TYPE;
852: l_t_ITEM_QUANTITY Pa_Fi_Amount_Details.ITEM_QUANTITY%TYPE;
853: l_t_COST_TXN_CURR_CODE Pa_Fi_Amount_Details.COST_TXN_CURRENCY_CODE%TYPE;
854: l_t_REV_TXN_CURR_CODE Pa_Fi_Amount_Details.REVENUE_TXN_CURRENCY_CODE%TYPE;
855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%TYPE;
856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%TYPE;
857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %TYPE;
858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%TYPE;
859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_TXN_CURRENCY_CODE%TYPE;
860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%TYPE;
853: l_t_COST_TXN_CURR_CODE Pa_Fi_Amount_Details.COST_TXN_CURRENCY_CODE%TYPE;
854: l_t_REV_TXN_CURR_CODE Pa_Fi_Amount_Details.REVENUE_TXN_CURRENCY_CODE%TYPE;
855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%TYPE;
856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%TYPE;
857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %TYPE;
858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%TYPE;
859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_TXN_CURRENCY_CODE%TYPE;
860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%TYPE;
861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_COST%TYPE;
854: l_t_REV_TXN_CURR_CODE Pa_Fi_Amount_Details.REVENUE_TXN_CURRENCY_CODE%TYPE;
855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%TYPE;
856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%TYPE;
857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %TYPE;
858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%TYPE;
859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_TXN_CURRENCY_CODE%TYPE;
860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%TYPE;
861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_COST%TYPE;
862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%TYPE;
855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%TYPE;
856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%TYPE;
857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %TYPE;
858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%TYPE;
859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_TXN_CURRENCY_CODE%TYPE;
860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%TYPE;
861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_COST%TYPE;
862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%TYPE;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;
856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%TYPE;
857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %TYPE;
858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%TYPE;
859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_TXN_CURRENCY_CODE%TYPE;
860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%TYPE;
861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_COST%TYPE;
862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%TYPE;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;
864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_RATE_TYPE%TYPE;
857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %TYPE;
858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%TYPE;
859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_TXN_CURRENCY_CODE%TYPE;
860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%TYPE;
861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_COST%TYPE;
862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%TYPE;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;
864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_RATE_TYPE%TYPE;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;
858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%TYPE;
859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_TXN_CURRENCY_CODE%TYPE;
860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%TYPE;
861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_COST%TYPE;
862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%TYPE;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;
864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_RATE_TYPE%TYPE;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;
866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %TYPE;
859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_TXN_CURRENCY_CODE%TYPE;
860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%TYPE;
861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_COST%TYPE;
862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%TYPE;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;
864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_RATE_TYPE%TYPE;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;
866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %TYPE;
867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%TYPE;
860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%TYPE;
861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_COST%TYPE;
862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%TYPE;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;
864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_RATE_TYPE%TYPE;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;
866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %TYPE;
867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%TYPE;
868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%TYPE;
861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_COST%TYPE;
862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%TYPE;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;
864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_RATE_TYPE%TYPE;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;
866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %TYPE;
867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%TYPE;
868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%TYPE;
869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%TYPE;
862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%TYPE;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;
864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_RATE_TYPE%TYPE;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;
866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %TYPE;
867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%TYPE;
868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%TYPE;
869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%TYPE;
870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%TYPE;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;
864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_RATE_TYPE%TYPE;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;
866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %TYPE;
867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%TYPE;
868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%TYPE;
869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%TYPE;
870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%TYPE;
871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%TYPE;
864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_RATE_TYPE%TYPE;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;
866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %TYPE;
867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%TYPE;
868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%TYPE;
869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%TYPE;
870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%TYPE;
871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%TYPE;
872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%TYPE;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;
866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %TYPE;
867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%TYPE;
868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%TYPE;
869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%TYPE;
870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%TYPE;
871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%TYPE;
872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%TYPE;
873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%TYPE;
866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %TYPE;
867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%TYPE;
868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%TYPE;
869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%TYPE;
870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%TYPE;
871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%TYPE;
872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%TYPE;
873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%TYPE;
874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%TYPE;
867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%TYPE;
868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%TYPE;
869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%TYPE;
870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%TYPE;
871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%TYPE;
872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%TYPE;
873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%TYPE;
874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%TYPE;
875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_DATE%TYPE;
868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%TYPE;
869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%TYPE;
870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%TYPE;
871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%TYPE;
872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%TYPE;
873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%TYPE;
874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%TYPE;
875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_DATE%TYPE;
876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_TYPE %TYPE;
869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%TYPE;
870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%TYPE;
871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%TYPE;
872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%TYPE;
873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%TYPE;
874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%TYPE;
875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_DATE%TYPE;
876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_TYPE %TYPE;
877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%TYPE;
871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%TYPE;
872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%TYPE;
873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%TYPE;
874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%TYPE;
875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_DATE%TYPE;
876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_TYPE %TYPE;
877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%TYPE;
872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%TYPE;
873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%TYPE;
874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%TYPE;
875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_DATE%TYPE;
876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_TYPE %TYPE;
877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%TYPE;
873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%TYPE;
874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%TYPE;
875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_DATE%TYPE;
876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_TYPE %TYPE;
877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;
873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%TYPE;
874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%TYPE;
875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_DATE%TYPE;
876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_TYPE %TYPE;
877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;
874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%TYPE;
875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_DATE%TYPE;
876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_TYPE %TYPE;
877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;
882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_EXCHANGE_RATE%TYPE;
875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_DATE%TYPE;
876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_TYPE %TYPE;
877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;
882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_EXCHANGE_RATE%TYPE;
883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%TYPE;
876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_RATE_TYPE %TYPE;
877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;
882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_EXCHANGE_RATE%TYPE;
883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%TYPE;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;
877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;
882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_EXCHANGE_RATE%TYPE;
883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%TYPE;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;
878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;
882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_EXCHANGE_RATE%TYPE;
883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%TYPE;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;
882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_EXCHANGE_RATE%TYPE;
883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%TYPE;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;
887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%TYPE;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;
882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_EXCHANGE_RATE%TYPE;
883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%TYPE;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;
887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%TYPE;
888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%TYPE;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;
882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_EXCHANGE_RATE%TYPE;
883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%TYPE;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;
887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%TYPE;
888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%TYPE;
889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_DATE %TYPE;
882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_EXCHANGE_RATE%TYPE;
883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%TYPE;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;
887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%TYPE;
888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%TYPE;
889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_DATE %TYPE;
890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_TYPE%TYPE;
883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%TYPE;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;
887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%TYPE;
888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%TYPE;
889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_DATE %TYPE;
890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_TYPE%TYPE;
891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_EXCHANGE_RATE%TYPE;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;
887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%TYPE;
888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%TYPE;
889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_DATE %TYPE;
890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_TYPE%TYPE;
891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_EXCHANGE_RATE%TYPE;
892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%TYPE;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;
887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%TYPE;
888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%TYPE;
889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_DATE %TYPE;
890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_TYPE%TYPE;
891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_EXCHANGE_RATE%TYPE;
892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%TYPE;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;
887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%TYPE;
888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%TYPE;
889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_DATE %TYPE;
890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_TYPE%TYPE;
891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_EXCHANGE_RATE%TYPE;
892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%TYPE;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;
894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_DATE%TYPE;
887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%TYPE;
888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%TYPE;
889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_DATE %TYPE;
890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_TYPE%TYPE;
891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_EXCHANGE_RATE%TYPE;
892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%TYPE;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;
894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_DATE%TYPE;
895: l_t_EFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_TYPE%TYPE;
888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%TYPE;
889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_DATE %TYPE;
890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_TYPE%TYPE;
891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_EXCHANGE_RATE%TYPE;
892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%TYPE;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;
894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_DATE%TYPE;
895: l_t_EFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_TYPE%TYPE;
896: l_t_EFUNC_TP_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_TP_EXCHANGE_RATE%TYPE;
889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_DATE %TYPE;
890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_TYPE%TYPE;
891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_EXCHANGE_RATE%TYPE;
892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%TYPE;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;
894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_DATE%TYPE;
895: l_t_EFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_TYPE%TYPE;
896: l_t_EFUNC_TP_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_TP_EXCHANGE_RATE%TYPE;
897: l_t_EFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.EXPFUNC_TRANSFER_PRICE%TYPE;
890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_RATE_TYPE%TYPE;
891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_EXCHANGE_RATE%TYPE;
892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%TYPE;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;
894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_DATE%TYPE;
895: l_t_EFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_TYPE%TYPE;
896: l_t_EFUNC_TP_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_TP_EXCHANGE_RATE%TYPE;
897: l_t_EFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.EXPFUNC_TRANSFER_PRICE%TYPE;
898:
891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_EXCHANGE_RATE%TYPE;
892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%TYPE;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;
894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_DATE%TYPE;
895: l_t_EFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_TYPE%TYPE;
896: l_t_EFUNC_TP_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_TP_EXCHANGE_RATE%TYPE;
897: l_t_EFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.EXPFUNC_TRANSFER_PRICE%TYPE;
898:
899: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%TYPE;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;
894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_DATE%TYPE;
895: l_t_EFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_TYPE%TYPE;
896: l_t_EFUNC_TP_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_TP_EXCHANGE_RATE%TYPE;
897: l_t_EFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.EXPFUNC_TRANSFER_PRICE%TYPE;
898:
899: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
900: l_created_by NUMBER := FND_GLOBAL.USER_ID;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;
894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_DATE%TYPE;
895: l_t_EFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_TYPE%TYPE;
896: l_t_EFUNC_TP_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_TP_EXCHANGE_RATE%TYPE;
897: l_t_EFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.EXPFUNC_TRANSFER_PRICE%TYPE;
898:
899: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
900: l_created_by NUMBER := FND_GLOBAL.USER_ID;
901: l_creation_date DATE := SYSDATE;
3764: l_t_EFUNC_TP_RATE_DATE ,
3765: l_t_EFUNC_TP_RATE_TYPE ,
3766: l_t_EFUNC_TP_EX_RATE ,
3767: l_t_EFUNC_TRANSFER_PRICE
3768: FROM Pa_Fi_Amount_Details WHERE
3769: Forecast_Item_Id = l_fi_id_tab(d) AND
3770: Line_Num = ( SELECT MAX(LINE_NUM) FROM
3771: Pa_Fi_Amount_Details WHERE
3772: Forecast_Item_Id = l_fi_id_tab(d) );
3767: l_t_EFUNC_TRANSFER_PRICE
3768: FROM Pa_Fi_Amount_Details WHERE
3769: Forecast_Item_Id = l_fi_id_tab(d) AND
3770: Line_Num = ( SELECT MAX(LINE_NUM) FROM
3771: Pa_Fi_Amount_Details WHERE
3772: Forecast_Item_Id = l_fi_id_tab(d) );
3773:
3774:
3775: /* setting the variables for updating the FI amount records */
3965: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3966: END IF;
3967:
3968: FORALL b IN 1 .. l_fid_fcst_itemid.COUNT
3969: INSERT INTO Pa_Fi_Amount_Details(
3970: FORECAST_ITEM_ID,
3971: LINE_NUM,
3972: ITEM_DATE,
3973: ITEM_UOM,
4099: END IF;
4100: /* dbms_output.put_line('bef updating FI amount dtls :'); */
4101:
4102: FORALL l_upd_idx IN 1 .. l_fid_upd_fcst_itemid.COUNT
4103: UPDATE Pa_FI_Amount_Details SET
4104: Reversed_flag = 'Y',
4105: Net_Zero_Flag = 'Y',
4106: LAST_UPDATE_DATE = l_last_update_date,
4107: LAST_UPDATED_BY = l_last_updated_by,