DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_BUDGET_LINES

Line 272: to get actuals data, we query directly to pa_budget_lines to get actual

268: ELSIF p_etc_source_code = 'WORKPLAN_RESOURCES' THEN
269: /*Bug fix for 3973511
270: Workplan side only stores amounts in one currency for each planning
271: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
272: to get actuals data, we query directly to pa_budget_lines to get actual
273: data from source workplan budget version */
274: IF P_PA_DEBUG_MODE = 'Y' THEN
275: pa_fp_gen_amount_utils.fp_debug(
276: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

Line 507: to get actuals data, we query directly to pa_budget_lines to get actual

503: ELSIF p_etc_source_code = 'WORKPLAN_RESOURCES' THEN
504: /*Bug fix for 3973511
505: Workplan side only stores amounts in one currency for each planning
506: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
507: to get actuals data, we query directly to pa_budget_lines to get actual
508: data from source workplan budget version */
509: IF P_PA_DEBUG_MODE = 'Y' THEN
510: pa_fp_gen_amount_utils.fp_debug(
511: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

Line 1412: l_other_rej_code PA_BUDGET_LINES.OTHER_REJECTION_CODE%TYPE;

1408: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1409: AND tmp_ra.transaction_source_code = 'WORKPLAN_RESOURCES';
1410:
1411: -- Variables added for Bug 5203622
1412: l_other_rej_code PA_BUDGET_LINES.OTHER_REJECTION_CODE%TYPE;
1413: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1414:
1415: BEGIN
1416: IF p_pa_debug_mode = 'Y' THEN

Line 2502: l_other_rej_code PA_BUDGET_LINES.OTHER_REJECTION_CODE%TYPE;

2498: l_tot_raw_cost_sum NUMBER;
2499: l_tot_revenue_sum NUMBER;
2500: l_tot_raw_cost_pc_sum NUMBER;
2501: l_tot_revenue_pc_sum NUMBER;
2502: l_other_rej_code PA_BUDGET_LINES.OTHER_REJECTION_CODE%TYPE;
2503: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2504: l_ins_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2505:
2506: BEGIN

Line 2692: to get actuals data, we query directly to pa_budget_lines to get actual

2688: ELSIF l_etc_source_code = 'WORKPLAN_RESOURCES' THEN
2689: /*Bug fix for 3973511
2690: Workplan side only stores amounts in one currency for each planning
2691: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
2692: to get actuals data, we query directly to pa_budget_lines to get actual
2693: data from source workplan budget version */
2694: IF P_PA_DEBUG_MODE = 'Y' THEN
2695: pa_fp_gen_amount_utils.fp_debug(
2696: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

Line 2981: to get actuals data, we query directly to pa_budget_lines to get actual

2977: ELSIF l_etc_source_code = 'WORKPLAN_RESOURCES' THEN
2978: /*Bug fix for 3973511
2979: Workplan side only stores amounts in one currency for each planning
2980: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
2981: to get actuals data, we query directly to pa_budget_lines to get actual
2982: data from source workplan budget version */
2983: IF P_PA_DEBUG_MODE = 'Y' THEN
2984: pa_fp_gen_amount_utils.fp_debug(
2985: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||