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 4215: FROM pa_budget_lines bl

4211: ,l_txn_revenue_tbl
4212: ,l_rate_based_flag_tbl
4213: ,l_init_quantity_tbl
4214: ,l_txn_currency_code_tbl
4215: FROM pa_budget_lines bl
4216: ,pa_resource_assignments ra
4217: WHERE bl.resource_assignment_id=ra.resource_assignment_id
4218: AND bl.budget_version_id=p_budget_version_id
4219: AND ra.budget_version_id=p_budget_version_id

Line 4372: UPDATE pa_budget_lines

4368: IF p_target_version_type='COST' THEN
4369:
4370: FORALL kk IN 1..l_bl_id_tbl.COUNT
4371:
4372: UPDATE pa_budget_lines
4373: SET txn_cost_rate_override = DECODE(cost_rejection_code, NULL,l_raw_cost_override_rate_tbl(kk),txn_cost_rate_override),
4374: burden_cost_rate_override = DECODE(burden_rejection_code, NULL,l_burd_cost_override_rate_tbl(kk),burden_cost_rate_override)
4375: WHERE budget_line_id = l_bl_id_tbl(kk);
4376:

Line 4381: UPDATE pa_budget_lines

4377: ELSIF p_target_version_type='ALL' THEN
4378:
4379: FORALL kk IN 1..l_bl_id_tbl.COUNT
4380:
4381: UPDATE pa_budget_lines
4382: SET txn_cost_rate_override = DECODE(cost_rejection_code, NULL,l_raw_cost_override_rate_tbl(kk),txn_cost_rate_override),
4383: burden_cost_rate_override = DECODE(burden_rejection_code, NULL,l_burd_cost_override_rate_tbl(kk),burden_cost_rate_override),
4384: txn_revenue = DECODE(revenue_rejection_code, NULL,l_txn_revenue_tbl(kk),txn_revenue),
4385: txn_bill_rate_override = DECODE(revenue_rejection_code, NULL,l_bill_override_rate_tbl(kk),txn_bill_rate_override)

Line 4396: UPDATE pa_budget_lines

4392: IF p_target_version_type='REVENUE' THEN
4393:
4394: FORALL kk IN 1..l_bl_id_tbl.COUNT
4395:
4396: UPDATE pa_budget_lines
4397: SET txn_bill_rate_override = DECODE(revenue_rejection_code, NULL,l_bill_override_rate_tbl(kk),txn_bill_rate_override)
4398: WHERE budget_line_id = l_bl_id_tbl(kk);
4399:
4400: ELSIF p_target_version_type='ALL' THEN

Line 4404: UPDATE pa_budget_lines

4400: ELSIF p_target_version_type='ALL' THEN
4401:
4402: FORALL kk IN 1..l_bl_id_tbl.COUNT
4403:
4404: UPDATE pa_budget_lines
4405: SET quantity = l_quantity_tbl(kk),
4406: txn_raw_cost = DECODE(cost_rejection_code, NULL,l_txn_raw_cost_tbl(kk),txn_raw_cost),
4407: txn_burdened_cost = DECODE(burden_rejection_code, NULL,l_txn_burdened_cost_tbl(kk),txn_burdened_cost),
4408: txn_cost_rate_override = DECODE(cost_rejection_code, NULL,l_raw_cost_override_rate_tbl(kk),txn_cost_rate_override),

Line 4516: UPDATE pa_budget_lines

4512: IF p_target_version_type='COST' THEN
4513:
4514: FORALL kk IN 1..l_bl_id_tbl.COUNT
4515:
4516: UPDATE pa_budget_lines
4517: SET quantity = l_quantity_tbl(kk),
4518: txn_raw_cost = DECODE (l_bl_rb_flag_chg_tbl(kk),
4519: 'Y',l_txn_raw_cost_tbl(kk),
4520: DECODE(cost_rejection_code,

Line 4552: UPDATE pa_budget_lines

4548: ELSIF p_target_version_type='REVENUE' THEN
4549:
4550: FORALL kk IN 1..l_bl_id_tbl.COUNT
4551:
4552: UPDATE pa_budget_lines
4553: SET quantity = l_quantity_tbl(kk),
4554: txn_revenue = DECODE (l_bl_rb_flag_chg_tbl(kk),
4555: 'Y',l_txn_revenue_tbl(kk),
4556: DECODE(revenue_rejection_code,

Line 4573: UPDATE pa_budget_lines

4569: ELSIF p_target_version_type='ALL' THEN
4570:
4571: FORALL kk IN 1..l_bl_id_tbl.COUNT
4572:
4573: UPDATE pa_budget_lines
4574: SET quantity = l_quantity_tbl(kk),
4575: txn_raw_cost = DECODE (l_bl_rb_flag_chg_tbl(kk),
4576: 'Y',l_txn_raw_cost_tbl(kk),
4577: DECODE(cost_rejection_code,

Line 4877: INSERT INTO PA_BUDGET_LINES(

4873: --Bug 4290043.Used p_copy_actuals_flag and p_derv_rates_missing_amts_flag to decide on copying actuals/rates
4874: --If p_derv_rates_missing_amts_flag is Y then rates will not be copied and the derv_missing_amts_chk_neg_qty
4875: --API called later on will stamp them on budget lines
4876: --Display_quantity is being set in copy_version and copy_finplans_from_project api as well
4877: INSERT INTO PA_BUDGET_LINES(
4878: budget_line_id /* FPB2 */
4879: ,budget_version_id /* FPB2 */
4880: ,resource_assignment_id
4881: ,start_date

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

4991: ,cost_ind_compiled_set_id
4992: ,pc_cur_conv_rejection_code
4993: ,pfc_cur_conv_rejection_code
4994: )
4995: SELECT pa_budget_lines_s.nextval /* FPB2 */
4996: ,p_target_plan_version_id /* FPB2 */
4997: ,pra.resource_assignment_id
4998: ,pbl.start_date
4999: ,sysdate

Line 5114: FROM PA_BUDGET_LINES pbl

5110: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',burden_cost_rate_override,NULL),NULL) --burden_cost_rate_override
5111: ,cost_ind_compiled_set_id
5112: ,Decode(l_adj_percentage,0,pc_cur_conv_rejection_code,null)
5113: ,Decode(l_adj_percentage,0,pfc_cur_conv_rejection_code,null)
5114: FROM PA_BUDGET_LINES pbl
5115: ,pa_resource_assignments pra
5116: WHERE pbl.resource_assignment_id = pra.parent_assignment_id
5117: AND pbl.budget_version_id = p_source_plan_version_id
5118: AND pra.budget_version_id = p_target_plan_version_id

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

5125: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5126: END IF;
5127:
5128: --Populate the pa_fp_bl_map_tmp table so that the MRC API can have the mapping readily defined.
5129: --The logic of inserting into pa_budget_lines using pa_fp_bl_map_tmp is removed for bug 4224703
5130: --The below table need not be popluated for worplan versions since MRC is not maintained for
5131: --workplan versions
5132: IF l_wp_version_flag='N' THEN
5133:

Line 5139: FROM pa_budget_lines pblt,

5135: (source_budget_line_id,
5136: target_budget_line_id)
5137: SELECT pbls.budget_line_id,
5138: pblt.budget_line_id
5139: FROM pa_budget_lines pblt,
5140: pa_budget_lines pbls,
5141: pa_resource_assignments prat
5142: WHERE pblt.budget_version_id=p_target_plan_version_id
5143: AND prat.budget_version_id=p_target_plan_version_id

Line 5140: pa_budget_lines pbls,

5136: target_budget_line_id)
5137: SELECT pbls.budget_line_id,
5138: pblt.budget_line_id
5139: FROM pa_budget_lines pblt,
5140: pa_budget_lines pbls,
5141: pa_resource_assignments prat
5142: WHERE pblt.budget_version_id=p_target_plan_version_id
5143: AND prat.budget_version_id=p_target_plan_version_id
5144: AND prat.project_id = l_target_project_id -- Bug 4493425.

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

6529: END IF;
6530: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6531: END IF;
6532:
6533: --Calling populate_display_qty for populating display_quantity in pa_budget_lines
6534: PA_BUDGET_LINES_UTILS.populate_display_qty
6535: (p_budget_version_id => l_target_version_id,
6536: p_context => 'FINANCIAL',
6537: p_use_temp_table_flag => 'N',

Line 6534: PA_BUDGET_LINES_UTILS.populate_display_qty

6530: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6531: END IF;
6532:
6533: --Calling populate_display_qty for populating display_quantity in pa_budget_lines
6534: PA_BUDGET_LINES_UTILS.populate_display_qty
6535: (p_budget_version_id => l_target_version_id,
6536: p_context => 'FINANCIAL',
6537: p_use_temp_table_flag => 'N',
6538: x_return_status => l_return_status);

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

6538: x_return_status => l_return_status);
6539:
6540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6541: IF P_PA_debug_mode = 'Y' THEN
6542: pa_debug.g_err_stage:= 'Error in PA_BUDGET_LINES_UTILS.populate_display_qty';
6543: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level5);
6544: END IF;
6545: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6546: END IF;

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

6574: rac.budget_version_id = l_source_version_id and
6575: pra.parent_assignment_id = rac.resource_assignment_id;
6576:
6577: /*Calling the maintain_data api for the 2nd time to do the rollup from
6578: pa_budget_lines. Note: This keeps the override rates copied in the
6579: previous call, intact */
6580: pa_res_asg_currency_pub.maintain_data
6581: (p_fp_cols_rec => l_fp_cols_rec,
6582: p_calling_module => 'COPY_PLAN',

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

7215: /* Bug# 2634726 -
7216: Private procedure (not available in specification) used by COPY_BUDGET_LINES
7217: (with shift days logic) to insert shifted periods data into pa_fp_cpy_period_tmp */
7218:
7219: PROCEDURE populate_cpy_periods_tmp(p_budget_version_id PA_BUDGET_LINES.budget_version_id%type,
7220: p_period_type PA_PROJ_FP_OPTIONS.cost_time_phased_code%TYPE,
7221: p_shift_periods number) AS
7222: cursor bl_periods is
7223: SELECT distinct bl.period_name,bl.start_date

Line 7224: FROM pa_budget_lines bl

7220: p_period_type PA_PROJ_FP_OPTIONS.cost_time_phased_code%TYPE,
7221: p_shift_periods number) AS
7222: cursor bl_periods is
7223: SELECT distinct bl.period_name,bl.start_date
7224: FROM pa_budget_lines bl
7225: WHERE budget_version_id = p_budget_version_id;
7226:
7227: l_err_code NUMBER;
7228: l_err_stage VARCHAR2(2000);

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

7400: pa_debug.g_err_stage:='Time Phased Code ='|| l_target_time_phased_code;
7401: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
7402: pa_debug.g_err_stage:='Budget Entry Level ='|| l_target_budget_entry_level;
7403: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
7404: pa_debug.g_err_stage:='Inserting into pa_budget_lines';
7405: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
7406: END IF;
7407:
7408: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 7457: FROM pa_budget_lines bl

7453: END IF;
7454:
7455: SELECT min(bl.start_date)
7456: INTO l_start_Date
7457: FROM pa_budget_lines bl
7458: WHERE bl.budget_version_id = p_source_plan_version_id;
7459:
7460: -- If l_start_date is null after the above select it implies
7461: -- there are no budget lines. So return immediately as nothing

Line 7512: INSERT INTO PA_BUDGET_LINES(

7508: start and end dates for budget line start and end dates
7509: */
7510: --Display_quantity is being set in copy_version and copy_finplans_from_project api as well
7511:
7512: INSERT INTO PA_BUDGET_LINES(
7513: budget_line_id /* FPB2 */
7514: ,budget_version_id /* FPB2 */
7515: ,resource_assignment_id
7516: ,start_date

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

7628: ,pc_cur_conv_rejection_code
7629: ,pfc_cur_conv_rejection_code
7630:
7631: )
7632: SELECT pa_budget_lines_s.nextval /* FPB2 */
7633: ,p_target_plan_version_id /* FPB2 */
7634: ,pra.resource_assignment_id
7635: ,DECODE(l_target_time_phased_code,
7636: 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 7766: FROM PA_BUDGET_LINES pbl

7762: ,nvl(burden_cost_rate_override,burden_cost_rate) -- burden_cost_rate_override
7763: ,NULL -- pc_cur_conv_rejection_code
7764: ,NULL -- pfc_cur_conv_rejection_code
7765:
7766: FROM PA_BUDGET_LINES pbl
7767: ,pa_resource_assignments pra
7768: WHERE pbl.resource_assignment_id = pra.parent_assignment_id
7769: AND pbl.budget_version_id = p_source_plan_version_id
7770: AND pra.budget_version_id=p_target_plan_version_id;

Line 7786: FROM pa_budget_lines bl

7782: greatest(pra.planning_end_date + l_shift_days,
7783: nvl(max(bl.end_date) , pra.planning_end_date + l_shift_days)),
7784: greatest(least(pra.sp_fixed_date + l_shift_days , pra.planning_end_date + l_shift_days),
7785: pra.planning_start_date + l_shift_days)
7786: FROM pa_budget_lines bl
7787: WHERE bl.resource_assignment_id = pra.resource_assignment_id
7788: )
7789: WHERE pra.budget_version_id = p_target_plan_version_id;
7790: */

Line 7798: from pa_budget_lines bl

7794: set (pra.planning_start_date, pra.planning_end_date,pra.sp_fixed_date)
7795: = ( select nvl(min(bl.start_date),nvl(l_target_proj_start_date, pra.planning_start_date + l_shift_days)),
7796: nvl(min(bl.end_date),nvl(l_target_proj_completion_date, pra.planning_end_date + l_shift_days)),
7797: 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)))
7798: from pa_budget_lines bl
7799: where bl.resource_assignment_id = pra.resource_assignment_id
7800: )
7801: where pra.budget_version_id = p_target_plan_version_id;
7802:

Line 7822: INSERT INTO PA_BUDGET_LINES(

7818: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7819: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7820: -- pa_fp_cpy_periods_tmp
7821:
7822: INSERT INTO PA_BUDGET_LINES(
7823: budget_line_id /* FPB2 */
7824: ,budget_version_id /* FPB2 */
7825: ,resource_assignment_id
7826: ,start_date

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

7937: ,burden_cost_rate_override
7938: ,pc_cur_conv_rejection_code
7939: ,pfc_cur_conv_rejection_code
7940: )
7941: SELECT pa_budget_lines_s.nextval /* FPB2 */
7942: ,p_target_plan_version_id /* FPB2 */
7943: ,pra.resource_assignment_id
7944: ,pptmp.start_date
7945: ,sysdate

Line 8057: FROM PA_BUDGET_LINES pbl

8053: ,NULL -- burden_cost_rate
8054: ,nvl(burden_cost_rate_override,burden_cost_rate) -- burden_cost_rate_override
8055: ,NULL -- pc_cur_conv_rejection_code
8056: ,NULL -- pfc_cur_conv_rejection_code
8057: FROM PA_BUDGET_LINES pbl
8058: ,pa_resource_assignments pra
8059: ,PA_FP_CPY_PERIODS_TMP pptmp /* Bug# 2634726 */
8060: WHERE pra.parent_assignment_id = pbl.resource_assignment_id
8061: AND decode(l_target_time_phased_code,

Line 8081: from pa_budget_lines bl

8077: greatest(pra.planning_end_date+l_shift_days,
8078: nvl(max(bl.end_date),pra.planning_end_date+l_shift_days)),
8079: greatest(least(pra.sp_fixed_date + l_shift_days, pra.planning_end_date+ l_shift_days),
8080: pra.planning_start_date+ l_shift_days)
8081: from pa_budget_lines bl
8082: where bl.resource_assignment_id = pra.resource_assignment_id
8083: )
8084: where pra.budget_version_id = p_target_plan_version_id;
8085:

Line 9387: FROM pa_budget_lines pbl, pa_resource_assignments pra

9383: l_period_nameTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9384:
9385: CURSOR Cur_group_source_budget_lines IS
9386: SELECT distinct pbl.resource_assignment_id resource_assignment_id, pbl.start_date start_date,pra.rate_based_flag
9387: FROM pa_budget_lines pbl, pa_resource_assignments pra
9388: WHERE pbl.budget_version_id = p_source_plan_version_id
9389: AND pra.resource_assignment_id = pbl.resource_assignment_id;
9390:
9391: CURSOR Cur_source_budget_lines(p_resource_assignment_id IN NUMBER, p_start_date IN DATE

Line 9425: FROM pa_budget_lines

9421: ,projfunc_currency_code
9422: ,project_currency_code
9423: ,end_date
9424: ,period_name
9425: FROM pa_budget_lines
9426: WHERE resource_assignment_id = p_resource_assignment_id
9427: AND start_date = p_start_date
9428: AND cost_rejection_code is null
9429: AND burden_rejection_code is null

Line 9584: SELECT pa_budget_lines_s.nextval

9580: l_project_burdened_cost_tot := 0;
9581: l_project_revenue_tot := 0;
9582: l_rate_based_flag := rec_group_source_budget_lines.rate_based_flag;
9583:
9584: SELECT pa_budget_lines_s.nextval
9585: INTO l_target_budget_line_id
9586: FROM dual;
9587:
9588: Open Cur_source_budget_lines(rec_group_source_budget_lines.resource_assignment_id,

Line 9697: INSERT INTO PA_BUDGET_LINES(

9693: l_txn_bill_rate_override := l_revenue_tot/l_quantity_tot;
9694: l_burden_cost_rate_override := l_burdened_cost_tot/l_quantity_tot;
9695: END IF;
9696:
9697: INSERT INTO PA_BUDGET_LINES(
9698: budget_line_id
9699: ,budget_version_id
9700: ,resource_assignment_id
9701: ,start_date