DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_COST1

Line 8424: l_insufficient_paramters EXCEPTION; -- Added to raised exception if any required paramter is missing for PA_COST1 api

8420: l_burden_multiplier number;
8421: l_cost_ind_compiled_set_id number;
8422: l_raw_cost_rejection_code varchar2(1000);
8423: l_burden_cost_rejection_code varchar2(1000);
8424: l_insufficient_paramters EXCEPTION; -- Added to raised exception if any required paramter is missing for PA_COST1 api
8425: l_resource_alias pa_task_assignments_v.resource_alias%TYPE; -- Added if any required paramter is missing for PA_COST1 api
8426:
8427: l_null_above VARCHAR2(1) := 'N'; -- Added if any required paramter is miss ing for PA_COST1 api
8428:

Line 8425: l_resource_alias pa_task_assignments_v.resource_alias%TYPE; -- Added if any required paramter is missing for PA_COST1 api

8421: l_cost_ind_compiled_set_id number;
8422: l_raw_cost_rejection_code varchar2(1000);
8423: l_burden_cost_rejection_code varchar2(1000);
8424: l_insufficient_paramters EXCEPTION; -- Added to raised exception if any required paramter is missing for PA_COST1 api
8425: l_resource_alias pa_task_assignments_v.resource_alias%TYPE; -- Added if any required paramter is missing for PA_COST1 api
8426:
8427: l_null_above VARCHAR2(1) := 'N'; -- Added if any required paramter is miss ing for PA_COST1 api
8428:
8429: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE; -- Bug # 3473324.

Line 8427: l_null_above VARCHAR2(1) := 'N'; -- Added if any required paramter is miss ing for PA_COST1 api

8423: l_burden_cost_rejection_code varchar2(1000);
8424: l_insufficient_paramters EXCEPTION; -- Added to raised exception if any required paramter is missing for PA_COST1 api
8425: l_resource_alias pa_task_assignments_v.resource_alias%TYPE; -- Added if any required paramter is missing for PA_COST1 api
8426:
8427: l_null_above VARCHAR2(1) := 'N'; -- Added if any required paramter is miss ing for PA_COST1 api
8428:
8429: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE; -- Bug # 3473324.
8430: g1_debug_mode VARCHAR2(1);
8431: l_res_list_memb_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

Line 9123: PA_COST1.Get_Plan_Actual_Cost_Rates

9119: END IF;
9120:
9121: BEGIN
9122:
9123: PA_COST1.Get_Plan_Actual_Cost_Rates
9124: (p_calling_mode =>l_calling_mode --'ACTUAL_RATES' Bug 3627315
9125: ,p_project_type =>l_project_type
9126: ,p_project_id =>p_project_id
9127: --,p_task_id => null ---- TILL THE ISSUE IS FIXED l_task_id

Line 9173: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'After call PA_COST1.Get_Plan_Actual_Cost_Rates', x_Log_Level=> 3);

9169: ,x_return_status =>l_return_status
9170: ,x_error_msg_code =>l_msg_data );
9171:
9172: IF g1_debug_mode = 'Y' THEN
9173: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'After call PA_COST1.Get_Plan_Actual_Cost_Rates', x_Log_Level=> 3);
9174: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);
9175: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'l_msg_data='||l_msg_data, x_Log_Level=> 3);
9176: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'l_trxn_curr_code='||l_trxn_curr_code, x_Log_Level=> 3);
9177: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'l_txn_raw_cost='||l_txn_raw_cost, x_Log_Level=> 3);

Line 9195: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'p_error_text='||SUBSTRB('PA_COST1.Get_Plan_Actual_Cost_Rates:'||SQLERRM,1,120), x_Log_Level=> 3);

9191: x_resource_burden_rate := 0;
9192: x_resource_curr_code := l_trxn_curr_code;
9193: -- X_dummy_burden_cost := 0;
9194: X_burden_multiplier := 0;
9195: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'p_error_text='||SUBSTRB('PA_COST1.Get_Plan_Actual_Cost_Rates:'||SQLERRM,1,120), x_Log_Level=> 3);
9196: END;
9197:
9198: --bug 3733606
9199: IF l_return_status <> 'S' THEN

Line 9377: pa_cost1.Get_burden_sch_details

9373: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'p_currency_code '||p_currency_code, x_Log_Level=> 3);
9374: pa_debug.write(x_Module=>'PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier', x_Msg => 'l_calling_mode '||l_calling_mode, x_Log_Level=> 3);
9375: END IF;
9376:
9377: pa_cost1.Get_burden_sch_details
9378: (
9379: p_calling_mode =>l_calling_mode
9380: ,p_exp_item_id => NULL
9381: ,p_trxn_type => NULL