[Home] [Help]
2612:
2613: --Parameters for fin plan model
2614:
2615: --Changes the default of the following parameters from NULL to G_PA_MISS_XXX 24-APR-03 by Xin Liu
2616: ,p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE
2617: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2618: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2619: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2620: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2659: l_msg_entity VARCHAR2(100);
2660: l_msg_entity_index NUMBER;
2661:
2662: --bug 13686054
2663: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
2664:
2665: BEGIN
2666:
2667: -- Standard begin of API savepoint
2675: --not set we will use USD. MSP does not support multiple currency and that's why
2676: --we have to decide at this level.
2677: IF p_pm_product_code = 'MSPROJECT' THEN
2678: --bug fix 14114695 start
2679: --commented the below query since no data populated in the table pa_fp_txn_currencies if multi currency not enabled
2680: /*
2681: SELECT DISTINCT Nvl(cu.TXN_CURRENCY_CODE,'USD')
2682: INTO l_txn_currency_code
2683: FROM pa_fp_txn_currencies cu, pa_tasks pa
2679: --commented the below query since no data populated in the table pa_fp_txn_currencies if multi currency not enabled
2680: /*
2681: SELECT DISTINCT Nvl(cu.TXN_CURRENCY_CODE,'USD')
2682: INTO l_txn_currency_code
2683: FROM pa_fp_txn_currencies cu, pa_tasks pa
2684: WHERE pa.task_id = p_pa_task_id
2685: AND cu.PROJECT_ID= pa.project_id
2686: AND cu.PROJFUNC_CURRENCY_FLAG = 'Y'; */
2687: --added the below query
8170: ( c_fin_plan_version_id NUMBER
8171: ,c_currency_code VARCHAR2)
8172: IS
8173: SELECT 1
8174: FROM pa_fp_txn_currencies
8175: WHERE fin_plan_version_id = c_fin_plan_version_id
8176: AND txn_currency_code = c_currency_code;
8177:
8178: --Cursor to derive plan_class_code and etc_start_date for a budget version