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_FP_COPY_FROM_PKG dependencies on PA_BUDGET_LINES

Line 571: -- pa_budget_lines,pa_resource_assignments

567: -- End of changes for bug 2729191
568:
569: -- Calling an api to delete the existing records of target_version in
570: -- pa_proj_periods_denorm, p_fin_plan_adj_lines, pa_fp_adj_elements,
571: -- pa_budget_lines,pa_resource_assignments
572:
573: IF P_PA_DEBUG_MODE = 'Y' THEN
574: pa_debug.g_err_stage:='Calling the delete version api';
575: pa_debug.write('Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);

Line 4227: FROM pa_budget_lines bl

4223: ,l_txn_revenue_tbl
4224: ,l_rate_based_flag_tbl
4225: ,l_init_quantity_tbl
4226: ,l_txn_currency_code_tbl
4227: FROM pa_budget_lines bl
4228: ,pa_resource_assignments ra
4229: WHERE bl.resource_assignment_id=ra.resource_assignment_id
4230: AND bl.budget_version_id=p_budget_version_id
4231: AND ra.budget_version_id=p_budget_version_id

Line 4384: UPDATE pa_budget_lines

4380: IF p_target_version_type='COST' THEN
4381:
4382: FORALL kk IN 1..l_bl_id_tbl.COUNT
4383:
4384: UPDATE pa_budget_lines
4385: SET txn_cost_rate_override = DECODE(cost_rejection_code, NULL,l_raw_cost_override_rate_tbl(kk),txn_cost_rate_override),
4386: burden_cost_rate_override = DECODE(burden_rejection_code, NULL,l_burd_cost_override_rate_tbl(kk),burden_cost_rate_override)
4387: WHERE budget_line_id = l_bl_id_tbl(kk);
4388:

Line 4393: UPDATE pa_budget_lines

4389: ELSIF p_target_version_type='ALL' THEN
4390:
4391: FORALL kk IN 1..l_bl_id_tbl.COUNT
4392:
4393: UPDATE pa_budget_lines
4394: SET txn_cost_rate_override = DECODE(cost_rejection_code, NULL,l_raw_cost_override_rate_tbl(kk),txn_cost_rate_override),
4395: burden_cost_rate_override = DECODE(burden_rejection_code, NULL,l_burd_cost_override_rate_tbl(kk),burden_cost_rate_override),
4396: txn_revenue = DECODE(revenue_rejection_code, NULL,l_txn_revenue_tbl(kk),txn_revenue),
4397: txn_bill_rate_override = DECODE(revenue_rejection_code, NULL,l_bill_override_rate_tbl(kk),txn_bill_rate_override)

Line 4408: UPDATE pa_budget_lines

4404: IF p_target_version_type='REVENUE' THEN
4405:
4406: FORALL kk IN 1..l_bl_id_tbl.COUNT
4407:
4408: UPDATE pa_budget_lines
4409: SET txn_bill_rate_override = DECODE(revenue_rejection_code, NULL,l_bill_override_rate_tbl(kk),txn_bill_rate_override)
4410: WHERE budget_line_id = l_bl_id_tbl(kk);
4411:
4412: ELSIF p_target_version_type='ALL' THEN

Line 4416: UPDATE pa_budget_lines

4412: ELSIF p_target_version_type='ALL' THEN
4413:
4414: FORALL kk IN 1..l_bl_id_tbl.COUNT
4415:
4416: UPDATE pa_budget_lines
4417: SET quantity = l_quantity_tbl(kk),
4418: txn_raw_cost = DECODE(cost_rejection_code, NULL,l_txn_raw_cost_tbl(kk),txn_raw_cost),
4419: txn_burdened_cost = DECODE(burden_rejection_code, NULL,l_txn_burdened_cost_tbl(kk),txn_burdened_cost),
4420: txn_cost_rate_override = DECODE(cost_rejection_code, NULL,l_raw_cost_override_rate_tbl(kk),txn_cost_rate_override),

Line 4528: UPDATE pa_budget_lines

4524: IF p_target_version_type='COST' THEN
4525:
4526: FORALL kk IN 1..l_bl_id_tbl.COUNT
4527:
4528: UPDATE pa_budget_lines
4529: SET quantity = l_quantity_tbl(kk),
4530: txn_raw_cost = DECODE (l_bl_rb_flag_chg_tbl(kk),
4531: 'Y',l_txn_raw_cost_tbl(kk),
4532: DECODE(cost_rejection_code,

Line 4564: UPDATE pa_budget_lines

4560: ELSIF p_target_version_type='REVENUE' THEN
4561:
4562: FORALL kk IN 1..l_bl_id_tbl.COUNT
4563:
4564: UPDATE pa_budget_lines
4565: SET quantity = l_quantity_tbl(kk),
4566: txn_revenue = DECODE (l_bl_rb_flag_chg_tbl(kk),
4567: 'Y',l_txn_revenue_tbl(kk),
4568: DECODE(revenue_rejection_code,

Line 4585: UPDATE pa_budget_lines

4581: ELSIF p_target_version_type='ALL' THEN
4582:
4583: FORALL kk IN 1..l_bl_id_tbl.COUNT
4584:
4585: UPDATE pa_budget_lines
4586: SET quantity = l_quantity_tbl(kk),
4587: txn_raw_cost = DECODE (l_bl_rb_flag_chg_tbl(kk),
4588: 'Y',l_txn_raw_cost_tbl(kk),
4589: DECODE(cost_rejection_code,

Line 4889: INSERT INTO PA_BUDGET_LINES(

4885: --Bug 4290043.Used p_copy_actuals_flag and p_derv_rates_missing_amts_flag to decide on copying actuals/rates
4886: --If p_derv_rates_missing_amts_flag is Y then rates will not be copied and the derv_missing_amts_chk_neg_qty
4887: --API called later on will stamp them on budget lines
4888: --Display_quantity is being set in copy_version and copy_finplans_from_project api as well
4889: INSERT INTO PA_BUDGET_LINES(
4890: budget_line_id /* FPB2 */
4891: ,budget_version_id /* FPB2 */
4892: ,resource_assignment_id
4893: ,start_date

Line 5007: SELECT pa_budget_lines_s.nextval /* FPB2 */

5003: ,cost_ind_compiled_set_id
5004: ,pc_cur_conv_rejection_code
5005: ,pfc_cur_conv_rejection_code
5006: )
5007: SELECT pa_budget_lines_s.nextval /* FPB2 */
5008: ,p_target_plan_version_id /* FPB2 */
5009: ,pra.resource_assignment_id
5010: ,pbl.start_date
5011: ,sysdate

Line 5126: FROM PA_BUDGET_LINES pbl

5122: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',burden_cost_rate_override,NULL),NULL) --burden_cost_rate_override
5123: ,cost_ind_compiled_set_id
5124: ,Decode(l_adj_percentage,0,pc_cur_conv_rejection_code,null)
5125: ,Decode(l_adj_percentage,0,pfc_cur_conv_rejection_code,null)
5126: FROM PA_BUDGET_LINES pbl
5127: ,pa_resource_assignments pra
5128: WHERE pbl.resource_assignment_id = pra.parent_assignment_id
5129: AND pbl.budget_version_id = p_source_plan_version_id
5130: AND pra.budget_version_id = p_target_plan_version_id

Line 5141: --The logic of inserting into pa_budget_lines using pa_fp_bl_map_tmp is removed for bug 4224703

5137: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5138: END IF;
5139:
5140: --Populate the pa_fp_bl_map_tmp table so that the MRC API can have the mapping readily defined.
5141: --The logic of inserting into pa_budget_lines using pa_fp_bl_map_tmp is removed for bug 4224703
5142: --The below table need not be popluated for worplan versions since MRC is not maintained for
5143: --workplan versions
5144: IF l_wp_version_flag='N' THEN
5145:

Line 5151: FROM pa_budget_lines pblt,

5147: (source_budget_line_id,
5148: target_budget_line_id)
5149: SELECT pbls.budget_line_id,
5150: pblt.budget_line_id
5151: FROM pa_budget_lines pblt,
5152: pa_budget_lines pbls,
5153: pa_resource_assignments prat
5154: WHERE pblt.budget_version_id=p_target_plan_version_id
5155: AND prat.budget_version_id=p_target_plan_version_id

Line 5152: pa_budget_lines pbls,

5148: target_budget_line_id)
5149: SELECT pbls.budget_line_id,
5150: pblt.budget_line_id
5151: FROM pa_budget_lines pblt,
5152: pa_budget_lines pbls,
5153: pa_resource_assignments prat
5154: WHERE pblt.budget_version_id=p_target_plan_version_id
5155: AND prat.budget_version_id=p_target_plan_version_id
5156: AND prat.project_id = l_target_project_id -- Bug 4493425.

Line 6550: --Calling populate_display_qty for populating display_quantity in pa_budget_lines

6546: END IF;
6547: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6548: END IF;
6549:
6550: --Calling populate_display_qty for populating display_quantity in pa_budget_lines
6551: PA_BUDGET_LINES_UTILS.populate_display_qty
6552: (p_budget_version_id => l_target_version_id,
6553: p_context => 'FINANCIAL',
6554: p_use_temp_table_flag => 'N',

Line 6551: PA_BUDGET_LINES_UTILS.populate_display_qty

6547: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6548: END IF;
6549:
6550: --Calling populate_display_qty for populating display_quantity in pa_budget_lines
6551: PA_BUDGET_LINES_UTILS.populate_display_qty
6552: (p_budget_version_id => l_target_version_id,
6553: p_context => 'FINANCIAL',
6554: p_use_temp_table_flag => 'N',
6555: x_return_status => l_return_status);

Line 6559: pa_debug.g_err_stage:= 'Error in PA_BUDGET_LINES_UTILS.populate_display_qty';

6555: x_return_status => l_return_status);
6556:
6557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6558: IF P_PA_debug_mode = 'Y' THEN
6559: pa_debug.g_err_stage:= 'Error in PA_BUDGET_LINES_UTILS.populate_display_qty';
6560: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level5);
6561: END IF;
6562: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6563: END IF;

Line 6595: pa_budget_lines. Note: This keeps the override rates copied in the

6591: rac.budget_version_id = l_source_version_id and
6592: pra.parent_assignment_id = rac.resource_assignment_id;
6593:
6594: /*Calling the maintain_data api for the 2nd time to do the rollup from
6595: pa_budget_lines. Note: This keeps the override rates copied in the
6596: previous call, intact */
6597: pa_res_asg_currency_pub.maintain_data
6598: (p_fp_cols_rec => l_fp_cols_rec,
6599: p_calling_module => 'COPY_PLAN',

Line 7236: PROCEDURE populate_cpy_periods_tmp(p_budget_version_id PA_BUDGET_LINES.budget_version_id%type,

7232: /* Bug# 2634726 -
7233: Private procedure (not available in specification) used by COPY_BUDGET_LINES
7234: (with shift days logic) to insert shifted periods data into pa_fp_cpy_period_tmp */
7235:
7236: PROCEDURE populate_cpy_periods_tmp(p_budget_version_id PA_BUDGET_LINES.budget_version_id%type,
7237: p_period_type PA_PROJ_FP_OPTIONS.cost_time_phased_code%TYPE,
7238: p_shift_periods number) AS
7239: cursor bl_periods is
7240: SELECT distinct bl.period_name,bl.start_date

Line 7241: FROM pa_budget_lines bl

7237: p_period_type PA_PROJ_FP_OPTIONS.cost_time_phased_code%TYPE,
7238: p_shift_periods number) AS
7239: cursor bl_periods is
7240: SELECT distinct bl.period_name,bl.start_date
7241: FROM pa_budget_lines bl
7242: WHERE budget_version_id = p_budget_version_id;
7243:
7244: l_err_code NUMBER;
7245: l_err_stage VARCHAR2(2000);

Line 7423: pa_debug.g_err_stage:='Inserting into pa_budget_lines';

7419: pa_debug.g_err_stage:='Time Phased Code ='|| l_target_time_phased_code;
7420: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
7421: pa_debug.g_err_stage:='Budget Entry Level ='|| l_target_budget_entry_level;
7422: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
7423: pa_debug.g_err_stage:='Inserting into pa_budget_lines';
7424: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
7425: END IF;
7426:
7427: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 7476: FROM pa_budget_lines bl

7472: END IF;
7473:
7474: SELECT min(bl.start_date)
7475: INTO l_start_Date
7476: FROM pa_budget_lines bl
7477: WHERE bl.budget_version_id = p_source_plan_version_id;
7478:
7479: -- If l_start_date is null after the above select it implies
7480: -- there are no budget lines. So return immediately as nothing

Line 7531: INSERT INTO PA_BUDGET_LINES(

7527: start and end dates for budget line start and end dates
7528: */
7529: --Display_quantity is being set in copy_version and copy_finplans_from_project api as well
7530:
7531: INSERT INTO PA_BUDGET_LINES(
7532: budget_line_id /* FPB2 */
7533: ,budget_version_id /* FPB2 */
7534: ,resource_assignment_id
7535: ,start_date

Line 7651: SELECT pa_budget_lines_s.nextval /* FPB2 */

7647: ,pc_cur_conv_rejection_code
7648: ,pfc_cur_conv_rejection_code
7649:
7650: )
7651: SELECT pa_budget_lines_s.nextval /* FPB2 */
7652: ,p_target_plan_version_id /* FPB2 */
7653: ,pra.resource_assignment_id
7654: ,DECODE(l_target_time_phased_code,
7655: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N,nvl(l_target_proj_start_date , pbl.start_date + l_shift_days), --Bug 4739375,l_target_proj_start_date.--bug 3841942 l_target_proj_start_date,

Line 7785: FROM PA_BUDGET_LINES pbl

7781: ,nvl(burden_cost_rate_override,burden_cost_rate) -- burden_cost_rate_override
7782: ,NULL -- pc_cur_conv_rejection_code
7783: ,NULL -- pfc_cur_conv_rejection_code
7784:
7785: FROM PA_BUDGET_LINES pbl
7786: ,pa_resource_assignments pra
7787: WHERE pbl.resource_assignment_id = pra.parent_assignment_id
7788: AND pbl.budget_version_id = p_source_plan_version_id
7789: AND pra.budget_version_id=p_target_plan_version_id;

Line 7805: FROM pa_budget_lines bl

7801: greatest(pra.planning_end_date + l_shift_days,
7802: nvl(max(bl.end_date) , pra.planning_end_date + l_shift_days)),
7803: greatest(least(pra.sp_fixed_date + l_shift_days , pra.planning_end_date + l_shift_days),
7804: pra.planning_start_date + l_shift_days)
7805: FROM pa_budget_lines bl
7806: WHERE bl.resource_assignment_id = pra.resource_assignment_id
7807: )
7808: WHERE pra.budget_version_id = p_target_plan_version_id;
7809: */

Line 7825: from pa_budget_lines bl

7821: 1,
7822: nvl(min(bl.start_date),nvl(l_target_proj_start_date, pra.planning_start_date + l_shift_days)),
7823: nvl(min(bl.end_date),nvl(l_target_proj_completion_date, pra.planning_end_date + l_shift_days))), -- end_date
7824: decode(pra.sp_fixed_date,null,null,nvl(min(bl.start_date),nvl(l_target_proj_start_date, pra.sp_fixed_date + l_shift_days)))
7825: from pa_budget_lines bl
7826: where bl.resource_assignment_id = pra.resource_assignment_id
7827: )
7828: where pra.budget_version_id = p_target_plan_version_id;
7829:

Line 7849: INSERT INTO PA_BUDGET_LINES(

7845: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7846: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7847: -- pa_fp_cpy_periods_tmp
7848:
7849: INSERT INTO PA_BUDGET_LINES(
7850: budget_line_id /* FPB2 */
7851: ,budget_version_id /* FPB2 */
7852: ,resource_assignment_id
7853: ,start_date

Line 7968: SELECT pa_budget_lines_s.nextval /* FPB2 */

7964: ,burden_cost_rate_override
7965: ,pc_cur_conv_rejection_code
7966: ,pfc_cur_conv_rejection_code
7967: )
7968: SELECT pa_budget_lines_s.nextval /* FPB2 */
7969: ,p_target_plan_version_id /* FPB2 */
7970: ,pra.resource_assignment_id
7971: ,pptmp.start_date
7972: ,sysdate

Line 8084: FROM PA_BUDGET_LINES pbl

8080: ,NULL -- burden_cost_rate
8081: ,nvl(burden_cost_rate_override,burden_cost_rate) -- burden_cost_rate_override
8082: ,NULL -- pc_cur_conv_rejection_code
8083: ,NULL -- pfc_cur_conv_rejection_code
8084: FROM PA_BUDGET_LINES pbl
8085: ,pa_resource_assignments pra
8086: ,PA_FP_CPY_PERIODS_TMP pptmp /* Bug# 2634726 */
8087: WHERE pra.parent_assignment_id = pbl.resource_assignment_id
8088: AND decode(l_target_time_phased_code,

Line 8108: from pa_budget_lines bl

8104: greatest(pra.planning_end_date+l_shift_days,
8105: nvl(max(bl.end_date),pra.planning_end_date+l_shift_days)),
8106: greatest(least(pra.sp_fixed_date + l_shift_days, pra.planning_end_date+ l_shift_days),
8107: pra.planning_start_date+ l_shift_days)
8108: from pa_budget_lines bl
8109: where bl.resource_assignment_id = pra.resource_assignment_id
8110: )
8111: where pra.budget_version_id = p_target_plan_version_id;
8112:

Line 9414: FROM pa_budget_lines pbl, pa_resource_assignments pra

9410: l_period_nameTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9411:
9412: CURSOR Cur_group_source_budget_lines IS
9413: SELECT distinct pbl.resource_assignment_id resource_assignment_id, pbl.start_date start_date,pra.rate_based_flag
9414: FROM pa_budget_lines pbl, pa_resource_assignments pra
9415: WHERE pbl.budget_version_id = p_source_plan_version_id
9416: AND pra.resource_assignment_id = pbl.resource_assignment_id;
9417:
9418: CURSOR Cur_source_budget_lines(p_resource_assignment_id IN NUMBER, p_start_date IN DATE

Line 9452: FROM pa_budget_lines

9448: ,projfunc_currency_code
9449: ,project_currency_code
9450: ,end_date
9451: ,period_name
9452: FROM pa_budget_lines
9453: WHERE resource_assignment_id = p_resource_assignment_id
9454: AND start_date = p_start_date
9455: AND cost_rejection_code is null
9456: AND burden_rejection_code is null

Line 9611: SELECT pa_budget_lines_s.nextval

9607: l_project_burdened_cost_tot := 0;
9608: l_project_revenue_tot := 0;
9609: l_rate_based_flag := rec_group_source_budget_lines.rate_based_flag;
9610:
9611: SELECT pa_budget_lines_s.nextval
9612: INTO l_target_budget_line_id
9613: FROM dual;
9614:
9615: Open Cur_source_budget_lines(rec_group_source_budget_lines.resource_assignment_id,

Line 9724: INSERT INTO PA_BUDGET_LINES(

9720: l_txn_bill_rate_override := l_revenue_tot/l_quantity_tot;
9721: l_burden_cost_rate_override := l_burdened_cost_tot/l_quantity_tot;
9722: END IF;
9723:
9724: INSERT INTO PA_BUDGET_LINES(
9725: budget_line_id
9726: ,budget_version_id
9727: ,resource_assignment_id
9728: ,start_date