DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_FP_FCST_GEN_AMT_UTILS

Line 1530: l_est_remaining_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_planned_effort,l_actual_effort); --5726773

1526: AND l_element_struc_type = 'WORKPLAN'
1527: AND l_est_remaining_eff_flag <> 'N'
1528: THEN
1529: ----5726773 l_est_remaining_effort := l_planned_effort - l_actual_effort;
1530: l_est_remaining_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_planned_effort,l_actual_effort); --5726773
1531: END IF;
1532: ----------end added by rtarway for bug 3630743-----
1533:
1534: IF NVL( l_lowest_level_task, 'N' ) = 'Y'

Line 7365: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_quantity,0),nvl(l_c1rec.oth_quantity_to_date,0));

7361: IF l_c1rec.oth_etc_quantity IS NOT NULL THEN
7362: l_etc := l_c1rec.oth_etc_quantity;
7363: ELSE
7364: ---5726773
7365: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_quantity,0),nvl(l_c1rec.oth_quantity_to_date,0));
7366: END IF;
7367: l_planned_qty_tbl_assgn(l_planned_qty_tbl_assgn.count) := nvl(l_c1rec.oth_quantity_to_date,0) + l_etc;
7368:
7369: IF l_c1rec.oth_etc_cost_tc IS NOT NULL THEN

Line 7373: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_bur_cost_txn_cur,0),nvl(l_c1rec.oth_act_cost_to_date_tc,0));

7369: IF l_c1rec.oth_etc_cost_tc IS NOT NULL THEN
7370: l_etc := l_c1rec.oth_etc_cost_tc;
7371: ELSE
7372: ---5726773
7373: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_bur_cost_txn_cur,0),nvl(l_c1rec.oth_act_cost_to_date_tc,0));
7374: END IF;
7375: l_burdened_cost_tbl_assgn(l_burdened_cost_tbl_assgn.count) := nvl(l_c1rec.oth_act_cost_to_date_tc,0) + l_etc;
7376:
7377: IF l_c1rec.oth_etc_rawcost_tc IS NOT NULL THEN

Line 7381: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_raw_cost_txn_cur,0),nvl(l_c1rec.oth_act_rawcost_to_date_tc,0));

7377: IF l_c1rec.oth_etc_rawcost_tc IS NOT NULL THEN
7378: l_etc := l_c1rec.oth_etc_rawcost_tc;
7379: ELSE
7380: ---5726773
7381: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_raw_cost_txn_cur,0),nvl(l_c1rec.oth_act_rawcost_to_date_tc,0));
7382: END IF;
7383: l_raw_cost_tbl_assgn(l_raw_cost_tbl_assgn.count) := nvl(l_c1rec.oth_act_rawcost_to_date_tc,0) + l_etc;
7384:
7385: ELSIF l_ptav_rec.resource_class_code = 'MATERIAL_ITEMS' THEN

Line 7390: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_quantity,0),nvl(l_c1rec.oth_quantity_to_date,0));

7386: IF l_c1rec.oth_etc_quantity IS NOT NULL THEN
7387: l_etc := l_c1rec.oth_etc_quantity;
7388: ELSE
7389: ---5726773
7390: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_quantity,0),nvl(l_c1rec.oth_quantity_to_date,0));
7391: END IF;
7392: l_planned_qty_tbl_assgn(l_planned_qty_tbl_assgn.count) := nvl(l_c1rec.oth_quantity_to_date,0) + l_etc;
7393:
7394: IF l_c1rec.oth_etc_cost_tc IS NOT NULL THEN

Line 7398: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_bur_cost_txn_cur,0),nvl(l_c1rec.oth_act_cost_to_date_tc,0));

7394: IF l_c1rec.oth_etc_cost_tc IS NOT NULL THEN
7395: l_etc := l_c1rec.oth_etc_cost_tc;
7396: ELSE
7397: ---5726773
7398: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_bur_cost_txn_cur,0),nvl(l_c1rec.oth_act_cost_to_date_tc,0));
7399: END IF;
7400: l_burdened_cost_tbl_assgn(l_burdened_cost_tbl_assgn.count) := nvl(l_c1rec.oth_act_cost_to_date_tc,0) + l_etc;
7401:
7402: IF l_c1rec.oth_etc_rawcost_tc IS NOT NULL THEN

Line 7406: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_raw_cost_txn_cur,0),nvl(l_c1rec.oth_act_rawcost_to_date_tc,0));

7402: IF l_c1rec.oth_etc_rawcost_tc IS NOT NULL THEN
7403: l_etc := l_c1rec.oth_etc_rawcost_tc;
7404: ELSE
7405: ---5726773
7406: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_raw_cost_txn_cur,0),nvl(l_c1rec.oth_act_rawcost_to_date_tc,0));
7407: END IF;
7408: l_raw_cost_tbl_assgn(l_raw_cost_tbl_assgn.count) := nvl(l_c1rec.oth_act_rawcost_to_date_tc,0) + l_etc;
7409:
7410: ELSIF l_ptav_rec.resource_class_code = 'PEOPLE' THEN

Line 7415: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_quantity,0),nvl(l_c1rec.ppl_act_effort_to_date,0));

7411: IF l_c1rec.estimated_remaining_effort IS NOT NULL THEN
7412: l_etc := l_c1rec.estimated_remaining_effort;
7413: ELSE
7414: ---5726773
7415: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_quantity,0),nvl(l_c1rec.ppl_act_effort_to_date,0));
7416: END IF;
7417: l_planned_qty_tbl_assgn(l_planned_qty_tbl_assgn.count) := nvl(l_c1rec.ppl_act_effort_to_date,0) + l_etc;
7418:
7419: IF l_c1rec.ppl_etc_cost_tc IS NOT NULL THEN

Line 7423: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_bur_cost_txn_cur,0),nvl(l_c1rec.ppl_act_cost_to_date_tc,0));

7419: IF l_c1rec.ppl_etc_cost_tc IS NOT NULL THEN
7420: l_etc := l_c1rec.ppl_etc_cost_tc;
7421: ELSE
7422: ---5726773
7423: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_bur_cost_txn_cur,0),nvl(l_c1rec.ppl_act_cost_to_date_tc,0));
7424: END IF;
7425: l_burdened_cost_tbl_assgn(l_burdened_cost_tbl_assgn.count) := nvl(l_c1rec.ppl_act_cost_to_date_tc,0) + l_etc;
7426:
7427: IF l_c1rec.ppl_etc_rawcost_tc IS NOT NULL THEN

Line 7431: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_raw_cost_txn_cur,0),nvl(l_c1rec.ppl_act_rawcost_to_date_tc,0));

7427: IF l_c1rec.ppl_etc_rawcost_tc IS NOT NULL THEN
7428: l_etc := l_c1rec.ppl_etc_rawcost_tc;
7429: ELSE
7430: ---5726773
7431: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_raw_cost_txn_cur,0),nvl(l_c1rec.ppl_act_rawcost_to_date_tc,0));
7432: END IF;
7433: l_raw_cost_tbl_assgn(l_raw_cost_tbl_assgn.count) := nvl(l_c1rec.ppl_act_rawcost_to_date_tc,0) + l_etc;
7434:
7435: ELSIF l_ptav_rec.resource_class_code = 'EQUIPMENT' THEN

Line 7440: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_quantity,0),nvl(l_c1rec.eqpmt_act_effort_to_date,0));

7436: IF l_c1rec.eqpmt_etc_effort IS NOT NULL THEN
7437: l_etc := l_c1rec.eqpmt_etc_effort;
7438: ELSE
7439: ---5726773
7440: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_quantity,0),nvl(l_c1rec.eqpmt_act_effort_to_date,0));
7441: END IF;
7442: l_planned_qty_tbl_assgn(l_planned_qty_tbl_assgn.count) := nvl(l_c1rec.eqpmt_act_effort_to_date,0) + l_etc;
7443:
7444: IF l_c1rec.eqpmt_etc_cost_tc IS NOT NULL THEN

Line 7448: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_bur_cost_txn_cur,0),nvl(l_c1rec.eqpmt_act_cost_to_date_tc,0));

7444: IF l_c1rec.eqpmt_etc_cost_tc IS NOT NULL THEN
7445: l_etc := l_c1rec.eqpmt_etc_cost_tc;
7446: ELSE
7447: ---5726773
7448: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_bur_cost_txn_cur,0),nvl(l_c1rec.eqpmt_act_cost_to_date_tc,0));
7449: END IF;
7450: l_burdened_cost_tbl_assgn(l_burdened_cost_tbl_assgn.count) := nvl(l_c1rec.eqpmt_act_cost_to_date_tc,0) + l_etc;
7451:
7452: IF l_c1rec.eqpmt_etc_rawcost_tc IS NOT NULL THEN

Line 7456: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_raw_cost_txn_cur,0),nvl(l_c1rec.eqpmt_act_rawcost_to_date_tc,0));

7452: IF l_c1rec.eqpmt_etc_rawcost_tc IS NOT NULL THEN
7453: l_etc := l_c1rec.eqpmt_etc_rawcost_tc;
7454: ELSE
7455: ---5726773
7456: l_etc := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(nvl(l_ptav_rec.planned_raw_cost_txn_cur,0),nvl(l_c1rec.eqpmt_act_rawcost_to_date_tc,0));
7457: END IF;
7458: l_raw_cost_tbl_assgn(l_raw_cost_tbl_assgn.count) := nvl(l_c1rec.eqpmt_act_rawcost_to_date_tc,0) + l_etc;
7459:
7460: END IF; -- l_ptav_rec.resource_class_code

Line 11979: l_oth_etc_quantity := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_ptav_rec.planned_quantity,l_last_ppr_rec.oth_quantity_to_date);

11975: END IF;
11976:
11977: IF l_ptav_rec.resource_class_code = 'FINANCIAL_ELEMENTS' THEN
11978: --5726773
11979: l_oth_etc_quantity := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_ptav_rec.planned_quantity,l_last_ppr_rec.oth_quantity_to_date);
11980: /* 5726773 l_oth_etc_quantity := nvl(l_ptav_rec.planned_quantity,0)-nvl(l_last_ppr_rec.oth_quantity_to_date,0);
11981: IF l_oth_etc_quantity < 0 THEN
11982: l_oth_etc_quantity := 0;
11983: END IF; */

Line 11986: l_oth_etc_quantity := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_ptav_rec.planned_quantity,l_last_ppr_rec.oth_quantity_to_date);

11982: l_oth_etc_quantity := 0;
11983: END IF; */
11984: ELSIF l_ptav_rec.resource_class_code = 'MATERIAL_ITEMS' THEN
11985: --5726773
11986: l_oth_etc_quantity := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_ptav_rec.planned_quantity,l_last_ppr_rec.oth_quantity_to_date);
11987: /* 5726773 l_oth_etc_quantity := nvl(l_ptav_rec.planned_quantity,0)-nvl(l_last_ppr_rec.oth_quantity_to_date,0);
11988: IF l_oth_etc_quantity < 0 THEN
11989: l_oth_etc_quantity := 0;
11990: END IF; */

Line 11993: l_estimated_remaining_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_ptav_rec.planned_quantity,l_last_ppr_rec.ppl_act_effort_to_date);

11989: l_oth_etc_quantity := 0;
11990: END IF; */
11991: ELSIF l_ptav_rec.resource_class_code = 'PEOPLE' THEN
11992: --5726773
11993: l_estimated_remaining_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_ptav_rec.planned_quantity,l_last_ppr_rec.ppl_act_effort_to_date);
11994: /*5726773 l_estimated_remaining_effort := nvl(l_ptav_rec.planned_quantity,0)-nvl(l_last_ppr_rec.ppl_act_effort_to_date,0);
11995: IF l_estimated_remaining_effort < 0 THEN
11996: l_estimated_remaining_effort := 0;
11997: END IF; */

Line 12000: l_eqpmt_etc_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_ptav_rec.planned_quantity,l_last_ppr_rec.eqpmt_act_effort_to_date);

11996: l_estimated_remaining_effort := 0;
11997: END IF; */
11998: ELSIF l_ptav_rec.resource_class_code = 'EQUIPMENT' THEN
11999: --5726773
12000: l_eqpmt_etc_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_ptav_rec.planned_quantity,l_last_ppr_rec.eqpmt_act_effort_to_date);
12001: /* 5726773 l_eqpmt_etc_effort := nvl(l_ptav_rec.planned_quantity,0)-nvl(l_last_ppr_rec.eqpmt_act_effort_to_date,0);
12002: IF l_eqpmt_etc_effort < 0 THEN
12003: l_eqpmt_etc_effort := 0;
12004: END IF; */

Line 12036: -- Used PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act to calculate

12032: IF l_estimated_remaining_effort < 0 THEN
12033: l_estimated_remaining_effort := 0;
12034: END IF; */
12035: -- Commented above and added below for Bug# 6713712
12036: -- Used PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act to calculate
12037: -- l_estimated_remaining_effort.
12038: l_estimated_remaining_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(NVL(l_ptav_rec.planned_quantity,0),NVL(l_last_ppr_rec.ppl_act_effort_to_date,0));
12039: END IF;
12040: --bug 3906362

Line 12038: l_estimated_remaining_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(NVL(l_ptav_rec.planned_quantity,0),NVL(l_last_ppr_rec.ppl_act_effort_to_date,0));

12034: END IF; */
12035: -- Commented above and added below for Bug# 6713712
12036: -- Used PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act to calculate
12037: -- l_estimated_remaining_effort.
12038: l_estimated_remaining_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(NVL(l_ptav_rec.planned_quantity,0),NVL(l_last_ppr_rec.ppl_act_effort_to_date,0));
12039: END IF;
12040: --bug 3906362
12041:
12042: l_BASE_PERCENT_COMP_DERIV_CODE := null;

Line 15046: u_oth_etc_qty(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_oth_qty(l_index3));

15042: if l_object_type = 'PA_ASSIGNMENTS' and
15043: l_res_class_code in ('FINANCIAL_ELEMENTS', 'MATERIAL_ITEMS') then
15044: ---5726773
15045: if (pa_progress_utils.check_etc_overridden(l_asgn_plan_quantity,l_w_rollup_rec_asofdate.oth_quantity_to_date,l_w_rollup_rec_asofdate.oth_etc_quantity) = 'N') then
15046: u_oth_etc_qty(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_oth_qty(l_index3));
15047: if (u_oth_etc_qty(l_index3) <> 0) then
15048: u_oth_etc_qty(l_index3) := l_asgn_plan_quantity - u_oth_qty(l_index3);
15049: pa_progress_utils.get_plan_costs_for_qty
15050: ( p_resource_list_mem_id => l_object_id

Line 15118: u_ppl_etc_effort_to_date(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_ppl_act_effort_to_date(l_index3));

15114: if l_object_type = 'PA_ASSIGNMENTS' and
15115: l_res_class_code = 'PEOPLE' then
15116: ---5726773
15117: if (pa_progress_utils.check_etc_overridden(l_asgn_plan_quantity,l_w_rollup_rec_asofdate.ppl_act_effort_to_date,l_w_rollup_rec_asofdate.estimated_remaining_effort) = 'N') then
15118: u_ppl_etc_effort_to_date(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_ppl_act_effort_to_date(l_index3));
15119: if (u_ppl_etc_effort_to_date(l_index3) <> 0) then
15120: pa_progress_utils.get_plan_costs_for_qty
15121: (p_resource_list_mem_id => l_object_id
15122: ,p_project_id => l_project_id

Line 15189: u_eqpmt_etc_effort_to_date(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_eqpmt_act_effort_to_date(l_index3));

15185: if l_object_type = 'PA_ASSIGNMENTS' and
15186: l_res_class_code = 'EQUIPMENT' then
15187: ---5726773
15188: if (pa_progress_utils.check_etc_overridden(l_asgn_plan_quantity,l_w_rollup_rec_asofdate.eqpmt_act_effort_to_date,l_w_rollup_rec_asofdate.eqpmt_etc_effort) = 'N') then
15189: u_eqpmt_etc_effort_to_date(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_eqpmt_act_effort_to_date(l_index3));
15190: if (u_eqpmt_etc_effort_to_date(l_index3) <> 0) then
15191: pa_progress_utils.get_plan_costs_for_qty
15192: (p_resource_list_mem_id => l_object_id
15193: ,p_project_id => l_project_id

Line 15349: oth_etc_qty(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,oth_qty(l_index2));

15345: OTH_ETC_COST_PC(l_index2) := to_number(null);
15346: OTH_ETC_RAWCOST_PC(l_index2) := to_number(null);
15347: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code in ('FINANCIAL_ELEMENTS', 'MATERIAL_ITEMS') then
15348: ---5726773
15349: oth_etc_qty(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,oth_qty(l_index2));
15350: if (oth_etc_qty(l_index2) <> 0) then
15351: oth_etc_qty(l_index2) := l_asgn_plan_quantity - oth_qty(l_index2);
15352: pa_progress_utils.get_plan_costs_for_qty
15353: ( p_resource_list_mem_id => l_object_id

Line 15440: ESTIMATED_REMAINING_EFFORT(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,ppl_act_effort_to_date(l_index2));

15436: PPL_ETC_COST_FC(l_index2) := to_number(null);
15437: PPL_ETC_RAWCOST_FC(l_index2) := to_number(null);
15438: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code = 'PEOPLE' then
15439: ---5726773
15440: ESTIMATED_REMAINING_EFFORT(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,ppl_act_effort_to_date(l_index2));
15441: if (ESTIMATED_REMAINING_EFFORT(l_index2) <> 0) then
15442: pa_progress_utils.get_plan_costs_for_qty
15443: ( p_resource_list_mem_id => l_object_id
15444: ,p_project_id => l_project_id

Line 15529: EQPMT_ETC_EFFORT(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,eqpmt_act_effort_to_date(l_index2));

15525: EQPMT_ETC_COST_FC(l_index2) := to_number(null);
15526: EQPMT_ETC_RAWCOST_FC(l_index2) := to_number(null);
15527: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code = 'EQUIPMENT' then
15528: ---5726773
15529: EQPMT_ETC_EFFORT(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,eqpmt_act_effort_to_date(l_index2));
15530: if (EQPMT_ETC_EFFORT(l_index2) <> 0) then
15531: pa_progress_utils.get_plan_costs_for_qty
15532: ( p_resource_list_mem_id => l_object_id
15533: ,p_project_id => l_project_id

Line 15725: u_oth_etc_qty(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_oth_qty(l_index3));

15721: if (l_object_type = 'PA_ASSIGNMENTS' and
15722: l_res_class_code in ('FINANCIAL_ELEMENTS', 'MATERIAL_ITEMS')) then
15723: ---5726773
15724: if (pa_progress_utils.check_etc_overridden(l_asgn_plan_quantity,l_rollup_rec_asofdate.oth_quantity_to_date,l_rollup_rec_asofdate.oth_etc_quantity) = 'N') then
15725: u_oth_etc_qty(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_oth_qty(l_index3));
15726: if (u_oth_etc_qty(l_index3) <> 0) then
15727: pa_progress_utils.get_plan_costs_for_qty
15728: ( p_resource_list_mem_id => l_object_id
15729: ,p_project_id => l_project_id

Line 15883: u_ppl_etc_effort_to_date(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_ppl_act_effort_to_date(l_index3));

15879: if l_object_type = 'PA_ASSIGNMENTS' and
15880: l_res_class_code = 'PEOPLE' then
15881: ---5726773
15882: if (pa_progress_utils.check_etc_overridden(l_asgn_plan_quantity,l_rollup_rec_asofdate.ppl_act_effort_to_date,l_rollup_rec_asofdate.estimated_remaining_effort) = 'N') then
15883: u_ppl_etc_effort_to_date(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_ppl_act_effort_to_date(l_index3));
15884: if (u_ppl_etc_effort_to_date(l_index3) <> 0) then
15885: pa_progress_utils.get_plan_costs_for_qty
15886: (p_resource_list_mem_id => l_object_id
15887: ,p_project_id => l_project_id

Line 16041: u_eqpmt_etc_effort_to_date(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_eqpmt_act_effort_to_date(l_index3));

16037: if l_object_type = 'PA_ASSIGNMENTS' and
16038: l_res_class_code = 'EQUIPMENT' then
16039: ---5726773
16040: if (pa_progress_utils.check_etc_overridden(l_asgn_plan_quantity,l_rollup_rec_asofdate.eqpmt_act_effort_to_date,l_rollup_rec_asofdate.eqpmt_etc_effort) = 'N') then
16041: u_eqpmt_etc_effort_to_date(l_index3) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,u_eqpmt_act_effort_to_date(l_index3));
16042: if (u_eqpmt_etc_effort_to_date(l_index3) <> 0) then
16043: pa_progress_utils.get_plan_costs_for_qty
16044: (p_resource_list_mem_id => l_object_id
16045: ,p_project_id => l_project_id

Line 16282: oth_etc_qty(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,oth_qty(l_index2));

16278: if l_object_type = 'PA_ASSIGNMENTS' and
16279: l_res_class_code in ('FINANCIAL_ELEMENTS', 'MATERIAL_ITEMS') then
16280: ---5726773
16281: if (pa_progress_utils.check_etc_overridden(l_asgn_plan_quantity,l_rollup_rec_asofdate.oth_quantity_to_date,l_rollup_rec_asofdate.OTH_ETC_QUANTITY) = 'N') then
16282: oth_etc_qty(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,oth_qty(l_index2));
16283: if (oth_etc_qty(l_index2) <> 0) then
16284: pa_progress_utils.get_plan_costs_for_qty
16285: ( p_resource_list_mem_id => l_object_id
16286: ,p_project_id => l_project_id

Line 16439: ESTIMATED_REMAINING_EFFORT(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,ppl_act_effort_to_date(l_index2));

16435: PPL_ETC_RAWCOST_FC(l_index2) := l_rollup_rec_asofdate.PPL_ETC_RAWCOST_FC;
16436: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code = 'PEOPLE' then
16437: ---5726773
16438: if (pa_progress_utils.check_etc_overridden(l_asgn_plan_quantity,l_rollup_rec_asofdate.ppl_act_effort_to_date,l_rollup_rec_asofdate.estimated_remaining_effort) = 'N') then
16439: ESTIMATED_REMAINING_EFFORT(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,ppl_act_effort_to_date(l_index2));
16440: if (ESTIMATED_REMAINING_EFFORT(l_index2) <> 0) then
16441: pa_progress_utils.get_plan_costs_for_qty
16442: ( p_resource_list_mem_id => l_object_id
16443: ,p_project_id => l_project_id

Line 16597: EQPMT_ETC_EFFORT(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,eqpmt_act_effort_to_date(l_index2));

16593: EQPMT_ETC_RAWCOST_FC(l_index2) := l_rollup_rec_asofdate.EQPMT_ETC_RAWCOST_FC;
16594: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code = 'EQUIPMENT' then
16595: ---5726773
16596: if (pa_progress_utils.check_etc_overridden(l_asgn_plan_quantity,l_rollup_rec_asofdate.eqpmt_act_effort_to_date,l_rollup_rec_asofdate.eqpmt_etc_effort) = 'N') then
16597: EQPMT_ETC_EFFORT(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,eqpmt_act_effort_to_date(l_index2));
16598: if (EQPMT_ETC_EFFORT(l_index2) <> 0) then
16599: pa_progress_utils.get_plan_costs_for_qty
16600: ( p_resource_list_mem_id => l_object_id
16601: ,p_project_id => l_project_id