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_FI_AMT_CALC_PKG dependencies on PA_FI_AMOUNT_DETAILS

Line 851: l_t_LINE_NUM Pa_Fi_Amount_Details.LINE_NUM%TYPE;

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;

Line 852: l_t_ITEM_QUANTITY Pa_Fi_Amount_Details.ITEM_QUANTITY%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;

Line 853: l_t_COST_TXN_CURR_CODE Pa_Fi_Amount_Details.COST_TXN_CURRENCY_CODE%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;

Line 854: l_t_REV_TXN_CURR_CODE Pa_Fi_Amount_Details.REVENUE_TXN_CURRENCY_CODE%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;

Line 855: l_t_TXN_RAW_COST Pa_Fi_Amount_Details.TXN_RAW_COST%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;

Line 856: l_t_TXN_BD_COST Pa_Fi_Amount_Details.TXN_BURDENED_COST%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;

Line 857: l_t_TXN_REVENUE Pa_Fi_Amount_Details.TXN_REVENUE %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;

Line 858: l_t_TXN_TRANSFER_PRICE Pa_Fi_Amount_Details.TXN_TRANSFER_PRICE%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;

Line 859: l_t_TP_TXN_CURR_CODE Pa_Fi_Amount_Details.TP_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;
863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_RATE_DATE%TYPE;

Line 860: l_t_PROJ_CURR_CODE Pa_Fi_Amount_Details.PROJECT_CURRENCY_CODE%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;

Line 861: l_t_PROJ_RAW_COST Pa_Fi_Amount_Details.PROJECT_RAW_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;
865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_EXCHANGE_RATE%TYPE;

Line 862: l_t_PROJ_BD_COST Pa_Fi_Amount_Details.PROJECT_BURDENED_COST%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;

Line 863: l_t_PROJ_COST_RATE_DATE Pa_Fi_Amount_Details.PROJECT_COST_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;

Line 864: l_t_PROJ_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_COST_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;

Line 865: l_t_PROJ_COST_EX_RATE Pa_Fi_Amount_Details.PROJECT_COST_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;

Line 866: l_t_PROJ_REV_RATE_DATE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_DATE %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;

Line 867: l_t_PROJ_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_REVENUE_RATE_TYPE%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;

Line 868: l_t_PROJ_REV_EX_RATE Pa_Fi_Amount_Details.PROJECT_REVENUE_EXCHANGE_RATE%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;

Line 869: l_t_PROJ_REVENUE Pa_Fi_Amount_Details.PROJECT_REVENUE%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;

Line 870: l_t_PROJ_TP_RATE_DATE Pa_Fi_Amount_Details.PROJECT_TP_RATE_DATE%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;

Line 871: l_t_PROJ_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJECT_TP_RATE_TYPE%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;

Line 872: l_t_PROJ_TP_EX_RATE Pa_Fi_Amount_Details.PROJECT_TP_EXCHANGE_RATE%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;

Line 873: l_t_PROJ_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJECT_TRANSFER_PRICE%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;

Line 874: l_t_PFUNC_CURR_CODE Pa_Fi_Amount_Details.PROJFUNC_CURRENCY_CODE%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;

Line 875: l_t_PFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_COST_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;
879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%TYPE;

Line 876: l_t_PFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_COST_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;
880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_DATE%TYPE;

Line 877: l_t_PFUNC_COST_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_COST_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;
881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_RATE_TYPE%TYPE;

Line 878: l_t_PFUNC_RAW_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%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;

Line 879: l_t_PFUNC_BD_COST Pa_Fi_Amount_Details.PROJFUNC_RAW_COST%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;

Line 880: l_t_PFUNC_REV_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_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;
884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%TYPE;

Line 881: l_t_PFUNC_REV_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_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;
885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%TYPE;

Line 882: l_t_PFUNC_REV_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_REVENUE_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;
886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%TYPE;

Line 883: l_t_PFUNC_REVENUE Pa_Fi_Amount_Details.PROJFUNC_REVENUE%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;

Line 884: l_t_PFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_DATE%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;

Line 885: l_t_PFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.PROJFUNC_TP_RATE_TYPE%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;

Line 886: l_t_PFUNC_TP_EX_RATE Pa_Fi_Amount_Details.PROJFUNC_TP_EXCHANGE_RATE%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;

Line 887: l_t_PFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.PROJFUNC_TRANSFER_PRICE%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;

Line 888: l_t_EFUNC_CURR_CODE Pa_Fi_Amount_Details.EXPFUNC_CURRENCY_CODE%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;

Line 889: l_t_EFUNC_COST_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_COST_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;
893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%TYPE;

Line 890: l_t_EFUNC_COST_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_COST_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;
894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_DATE%TYPE;

Line 891: l_t_EFUNC_COST_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_COST_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;
895: l_t_EFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_TP_RATE_TYPE%TYPE;

Line 892: l_t_EFUNC_RAW_COST Pa_Fi_Amount_Details.EXPFUNC_RAW_COST%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;

Line 893: l_t_EFUNC_BD_COST Pa_Fi_Amount_Details.EXPFUNC_BURDENED_COST%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;

Line 894: l_t_EFUNC_TP_RATE_DATE Pa_Fi_Amount_Details.EXPFUNC_TP_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;
898:

Line 895: l_t_EFUNC_TP_RATE_TYPE Pa_Fi_Amount_Details.EXPFUNC_TP_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:
899: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 896: l_t_EFUNC_TP_EX_RATE Pa_Fi_Amount_Details.EXPFUNC_TP_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;
900: l_created_by NUMBER := FND_GLOBAL.USER_ID;

Line 897: l_t_EFUNC_TRANSFER_PRICE Pa_Fi_Amount_Details.EXPFUNC_TRANSFER_PRICE%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;
901: l_creation_date DATE := SYSDATE;

Line 3744: FROM Pa_Fi_Amount_Details WHERE

3740: l_t_EFUNC_TP_RATE_DATE ,
3741: l_t_EFUNC_TP_RATE_TYPE ,
3742: l_t_EFUNC_TP_EX_RATE ,
3743: l_t_EFUNC_TRANSFER_PRICE
3744: FROM Pa_Fi_Amount_Details WHERE
3745: Forecast_Item_Id = l_fi_id_tab(d) AND
3746: Line_Num = ( SELECT MAX(LINE_NUM) FROM
3747: Pa_Fi_Amount_Details WHERE
3748: Forecast_Item_Id = l_fi_id_tab(d) );

Line 3747: Pa_Fi_Amount_Details WHERE

3743: l_t_EFUNC_TRANSFER_PRICE
3744: FROM Pa_Fi_Amount_Details WHERE
3745: Forecast_Item_Id = l_fi_id_tab(d) AND
3746: Line_Num = ( SELECT MAX(LINE_NUM) FROM
3747: Pa_Fi_Amount_Details WHERE
3748: Forecast_Item_Id = l_fi_id_tab(d) );
3749:
3750:
3751: /* setting the variables for updating the FI amount records */

Line 3945: INSERT INTO Pa_Fi_Amount_Details(

3941: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3942: END IF;
3943:
3944: FORALL b IN 1 .. l_fid_fcst_itemid.COUNT
3945: INSERT INTO Pa_Fi_Amount_Details(
3946: FORECAST_ITEM_ID,
3947: LINE_NUM,
3948: ITEM_DATE,
3949: ITEM_UOM,

Line 4079: UPDATE Pa_FI_Amount_Details SET

4075: END IF;
4076: /* dbms_output.put_line('bef updating FI amount dtls :'); */
4077:
4078: FORALL l_upd_idx IN 1 .. l_fid_upd_fcst_itemid.COUNT
4079: UPDATE Pa_FI_Amount_Details SET
4080: Reversed_flag = 'Y',
4081: Net_Zero_Flag = 'Y',
4082: LAST_UPDATE_DATE = l_last_update_date,
4083: LAST_UPDATED_BY = l_last_updated_by,