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_PROGRESS_PUB dependencies on PA_FP_FCST_GEN_AMT_UTILS

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

1757: AND l_element_struc_type = 'WORKPLAN'
1758: AND l_est_remaining_eff_flag <> 'N'
1759: THEN
1760: ----5726773 l_est_remaining_effort := l_planned_effort - l_actual_effort;
1761: l_est_remaining_effort := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_planned_effort,l_actual_effort); --5726773
1762: END IF;
1763: ----------end added by rtarway for bug 3630743-----
1764:
1765: IF NVL( l_lowest_level_task, 'N' ) = 'Y'

Line 7777: 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));

7773: IF l_c1rec.oth_etc_quantity IS NOT NULL THEN
7774: l_etc := l_c1rec.oth_etc_quantity;
7775: ELSE
7776: ---5726773
7777: 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));
7778: END IF;
7779: l_planned_qty_tbl_assgn(l_planned_qty_tbl_assgn.count) := nvl(l_c1rec.oth_quantity_to_date,0) + l_etc;
7780:
7781: IF l_c1rec.oth_etc_cost_tc IS NOT NULL THEN

Line 7785: 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));

7781: IF l_c1rec.oth_etc_cost_tc IS NOT NULL THEN
7782: l_etc := l_c1rec.oth_etc_cost_tc;
7783: ELSE
7784: ---5726773
7785: 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));
7786: END IF;
7787: l_burdened_cost_tbl_assgn(l_burdened_cost_tbl_assgn.count) := nvl(l_c1rec.oth_act_cost_to_date_tc,0) + l_etc;
7788:
7789: IF l_c1rec.oth_etc_rawcost_tc IS NOT NULL THEN

Line 7793: 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));

7789: IF l_c1rec.oth_etc_rawcost_tc IS NOT NULL THEN
7790: l_etc := l_c1rec.oth_etc_rawcost_tc;
7791: ELSE
7792: ---5726773
7793: 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));
7794: END IF;
7795: l_raw_cost_tbl_assgn(l_raw_cost_tbl_assgn.count) := nvl(l_c1rec.oth_act_rawcost_to_date_tc,0) + l_etc;
7796:
7797: ELSIF l_ptav_rec.resource_class_code = 'MATERIAL_ITEMS' THEN

Line 7802: 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));

7798: IF l_c1rec.oth_etc_quantity IS NOT NULL THEN
7799: l_etc := l_c1rec.oth_etc_quantity;
7800: ELSE
7801: ---5726773
7802: 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));
7803: END IF;
7804: l_planned_qty_tbl_assgn(l_planned_qty_tbl_assgn.count) := nvl(l_c1rec.oth_quantity_to_date,0) + l_etc;
7805:
7806: IF l_c1rec.oth_etc_cost_tc IS NOT NULL THEN

Line 7810: 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));

7806: IF l_c1rec.oth_etc_cost_tc IS NOT NULL THEN
7807: l_etc := l_c1rec.oth_etc_cost_tc;
7808: ELSE
7809: ---5726773
7810: 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));
7811: END IF;
7812: l_burdened_cost_tbl_assgn(l_burdened_cost_tbl_assgn.count) := nvl(l_c1rec.oth_act_cost_to_date_tc,0) + l_etc;
7813:
7814: IF l_c1rec.oth_etc_rawcost_tc IS NOT NULL THEN

Line 7818: 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));

7814: IF l_c1rec.oth_etc_rawcost_tc IS NOT NULL THEN
7815: l_etc := l_c1rec.oth_etc_rawcost_tc;
7816: ELSE
7817: ---5726773
7818: 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));
7819: END IF;
7820: l_raw_cost_tbl_assgn(l_raw_cost_tbl_assgn.count) := nvl(l_c1rec.oth_act_rawcost_to_date_tc,0) + l_etc;
7821:
7822: ELSIF l_ptav_rec.resource_class_code = 'PEOPLE' THEN

Line 7827: 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));

7823: IF l_c1rec.estimated_remaining_effort IS NOT NULL THEN
7824: l_etc := l_c1rec.estimated_remaining_effort;
7825: ELSE
7826: ---5726773
7827: 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));
7828: END IF;
7829: l_planned_qty_tbl_assgn(l_planned_qty_tbl_assgn.count) := nvl(l_c1rec.ppl_act_effort_to_date,0) + l_etc;
7830:
7831: IF l_c1rec.ppl_etc_cost_tc IS NOT NULL THEN

Line 7835: 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));

7831: IF l_c1rec.ppl_etc_cost_tc IS NOT NULL THEN
7832: l_etc := l_c1rec.ppl_etc_cost_tc;
7833: ELSE
7834: ---5726773
7835: 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));
7836: END IF;
7837: l_burdened_cost_tbl_assgn(l_burdened_cost_tbl_assgn.count) := nvl(l_c1rec.ppl_act_cost_to_date_tc,0) + l_etc;
7838:
7839: IF l_c1rec.ppl_etc_rawcost_tc IS NOT NULL THEN

Line 7843: 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));

7839: IF l_c1rec.ppl_etc_rawcost_tc IS NOT NULL THEN
7840: l_etc := l_c1rec.ppl_etc_rawcost_tc;
7841: ELSE
7842: ---5726773
7843: 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));
7844: END IF;
7845: l_raw_cost_tbl_assgn(l_raw_cost_tbl_assgn.count) := nvl(l_c1rec.ppl_act_rawcost_to_date_tc,0) + l_etc;
7846:
7847: ELSIF l_ptav_rec.resource_class_code = 'EQUIPMENT' THEN

Line 7852: 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));

7848: IF l_c1rec.eqpmt_etc_effort IS NOT NULL THEN
7849: l_etc := l_c1rec.eqpmt_etc_effort;
7850: ELSE
7851: ---5726773
7852: 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));
7853: END IF;
7854: l_planned_qty_tbl_assgn(l_planned_qty_tbl_assgn.count) := nvl(l_c1rec.eqpmt_act_effort_to_date,0) + l_etc;
7855:
7856: IF l_c1rec.eqpmt_etc_cost_tc IS NOT NULL THEN

Line 7860: 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));

7856: IF l_c1rec.eqpmt_etc_cost_tc IS NOT NULL THEN
7857: l_etc := l_c1rec.eqpmt_etc_cost_tc;
7858: ELSE
7859: ---5726773
7860: 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));
7861: END IF;
7862: l_burdened_cost_tbl_assgn(l_burdened_cost_tbl_assgn.count) := nvl(l_c1rec.eqpmt_act_cost_to_date_tc,0) + l_etc;
7863:
7864: IF l_c1rec.eqpmt_etc_rawcost_tc IS NOT NULL THEN

Line 7868: 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));

7864: IF l_c1rec.eqpmt_etc_rawcost_tc IS NOT NULL THEN
7865: l_etc := l_c1rec.eqpmt_etc_rawcost_tc;
7866: ELSE
7867: ---5726773
7868: 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));
7869: END IF;
7870: l_raw_cost_tbl_assgn(l_raw_cost_tbl_assgn.count) := nvl(l_c1rec.eqpmt_act_rawcost_to_date_tc,0) + l_etc;
7871:
7872: END IF; -- l_ptav_rec.resource_class_code

Line 12434: l_oth_etc_quantity := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(NVL(l_ptav_rec.planned_quantity,0),NVL(l_last_ppr_rec.oth_quantity_to_date,0));

12430:
12431: IF l_ptav_rec.resource_class_code = 'FINANCIAL_ELEMENTS' THEN
12432: --5726773
12433: --adding the below code for Bug 7185549
12434: l_oth_etc_quantity := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(NVL(l_ptav_rec.planned_quantity,0),NVL(l_last_ppr_rec.oth_quantity_to_date,0));
12435:
12436: /* 5726773 l_oth_etc_quantity := nvl(l_ptav_rec.planned_quantity,0)-nvl(l_last_ppr_rec.oth_quantity_to_date,0);
12437: IF l_oth_etc_quantity < 0 THEN
12438: l_oth_etc_quantity := 0;

Line 12442: 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);

12438: l_oth_etc_quantity := 0;
12439: END IF; */
12440: ELSIF l_ptav_rec.resource_class_code = 'MATERIAL_ITEMS' THEN
12441: --5726773
12442: 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);
12443: /* 5726773 l_oth_etc_quantity := nvl(l_ptav_rec.planned_quantity,0)-nvl(l_last_ppr_rec.oth_quantity_to_date,0);
12444: IF l_oth_etc_quantity < 0 THEN
12445: l_oth_etc_quantity := 0;
12446: END IF; */

Line 12449: 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);

12445: l_oth_etc_quantity := 0;
12446: END IF; */
12447: ELSIF l_ptav_rec.resource_class_code = 'PEOPLE' THEN
12448: --5726773
12449: 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);
12450: /*5726773 l_estimated_remaining_effort := nvl(l_ptav_rec.planned_quantity,0)-nvl(l_last_ppr_rec.ppl_act_effort_to_date,0);
12451: IF l_estimated_remaining_effort < 0 THEN
12452: l_estimated_remaining_effort := 0;
12453: END IF; */

Line 12456: 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);

12452: l_estimated_remaining_effort := 0;
12453: END IF; */
12454: ELSIF l_ptav_rec.resource_class_code = 'EQUIPMENT' THEN
12455: --5726773
12456: 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);
12457: /* 5726773 l_eqpmt_etc_effort := nvl(l_ptav_rec.planned_quantity,0)-nvl(l_last_ppr_rec.eqpmt_act_effort_to_date,0);
12458: IF l_eqpmt_etc_effort < 0 THEN
12459: l_eqpmt_etc_effort := 0;
12460: END IF; */

Line 12492: -- Used PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act to calculate

12488: IF l_estimated_remaining_effort < 0 THEN
12489: l_estimated_remaining_effort := 0;
12490: END IF; */
12491: -- Commented above and added below for Bug# 6713712
12492: -- Used PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act to calculate
12493: -- l_estimated_remaining_effort.
12494: 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));
12495: END IF;
12496: --bug 3906362

Line 12494: 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));

12490: END IF; */
12491: -- Commented above and added below for Bug# 6713712
12492: -- Used PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act to calculate
12493: -- l_estimated_remaining_effort.
12494: 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));
12495: END IF;
12496: --bug 3906362
12497:
12498: l_BASE_PERCENT_COMP_DERIV_CODE := null;

Line 15683: 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));

15679: if l_object_type = 'PA_ASSIGNMENTS' and
15680: l_res_class_code in ('FINANCIAL_ELEMENTS', 'MATERIAL_ITEMS') then
15681: ---5726773
15682: 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
15683: 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));
15684: if (u_oth_etc_qty(l_index3) <> 0) then
15685: u_oth_etc_qty(l_index3) := l_asgn_plan_quantity - u_oth_qty(l_index3);
15686: pa_progress_utils.get_plan_costs_for_qty
15687: ( p_resource_list_mem_id => l_object_id

Line 15778: 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));

15774: if l_object_type = 'PA_ASSIGNMENTS' and
15775: l_res_class_code = 'PEOPLE' then
15776: ---5726773
15777: 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
15778: 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));
15779: if (u_ppl_etc_effort_to_date(l_index3) <> 0) then
15780: pa_progress_utils.get_plan_costs_for_qty
15781: (p_resource_list_mem_id => l_object_id
15782: ,p_project_id => l_project_id

Line 15871: 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));

15867: if l_object_type = 'PA_ASSIGNMENTS' and
15868: l_res_class_code = 'EQUIPMENT' then
15869: ---5726773
15870: 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
15871: 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));
15872: if (u_eqpmt_etc_effort_to_date(l_index3) <> 0) then
15873: pa_progress_utils.get_plan_costs_for_qty
15874: (p_resource_list_mem_id => l_object_id
15875: ,p_project_id => l_project_id

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

16047: OTH_ETC_COST_PC(l_index2) := to_number(null);
16048: OTH_ETC_RAWCOST_PC(l_index2) := to_number(null);
16049: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code in ('FINANCIAL_ELEMENTS', 'MATERIAL_ITEMS') then
16050: ---5726773
16051: oth_etc_qty(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,oth_qty(l_index2));
16052: if (oth_etc_qty(l_index2) <> 0) then
16053: oth_etc_qty(l_index2) := l_asgn_plan_quantity - oth_qty(l_index2);
16054: pa_progress_utils.get_plan_costs_for_qty
16055: ( p_resource_list_mem_id => l_object_id

Line 16180: 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));

16176: end if;
16177: --Bug 13823145 changes end here
16178: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code = 'PEOPLE' then
16179: ---5726773
16180: 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));
16181: if (ESTIMATED_REMAINING_EFFORT(l_index2) <> 0) then
16182: pa_progress_utils.get_plan_costs_for_qty
16183: ( p_resource_list_mem_id => l_object_id
16184: ,p_project_id => l_project_id

Line 16309: 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));

16305: end if;
16306: --Bug 13823145 changes end here
16307: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code = 'EQUIPMENT' then
16308: ---5726773
16309: 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));
16310: if (EQPMT_ETC_EFFORT(l_index2) <> 0) then
16311: pa_progress_utils.get_plan_costs_for_qty
16312: ( p_resource_list_mem_id => l_object_id
16313: ,p_project_id => l_project_id

Line 16538: 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));

16534: if (l_object_type = 'PA_ASSIGNMENTS' and
16535: l_res_class_code in ('FINANCIAL_ELEMENTS', 'MATERIAL_ITEMS')) then
16536: ---5726773
16537: 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
16538: 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));
16539: if (u_oth_etc_qty(l_index3) <> 0) then
16540: pa_progress_utils.get_plan_costs_for_qty
16541: ( p_resource_list_mem_id => l_object_id
16542: ,p_project_id => l_project_id

Line 16752: 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));

16748: if l_object_type = 'PA_ASSIGNMENTS' and
16749: l_res_class_code = 'PEOPLE' then
16750: ---5726773
16751: 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
16752: 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));
16753: if (u_ppl_etc_effort_to_date(l_index3) <> 0) then
16754: pa_progress_utils.get_plan_costs_for_qty
16755: (p_resource_list_mem_id => l_object_id
16756: ,p_project_id => l_project_id

Line 16969: 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));

16965: if l_object_type = 'PA_ASSIGNMENTS' and
16966: l_res_class_code = 'EQUIPMENT' then
16967: ---5726773
16968: 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
16969: 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));
16970: if (u_eqpmt_etc_effort_to_date(l_index3) <> 0) then
16971: pa_progress_utils.get_plan_costs_for_qty
16972: (p_resource_list_mem_id => l_object_id
16973: ,p_project_id => l_project_id

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

17257: if l_object_type = 'PA_ASSIGNMENTS' and
17258: l_res_class_code in ('FINANCIAL_ELEMENTS', 'MATERIAL_ITEMS') then
17259: ---5726773
17260: 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
17261: oth_etc_qty(l_index2) := PA_FP_FCST_GEN_AMT_UTILS.get_etc_from_plan_act(l_asgn_plan_quantity,oth_qty(l_index2));
17262: if (oth_etc_qty(l_index2) <> 0) then
17263: pa_progress_utils.get_plan_costs_for_qty
17264: ( p_resource_list_mem_id => l_object_id
17265: ,p_project_id => l_project_id

Line 17473: 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));

17469: --Bug 13823145 changes end here
17470: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code = 'PEOPLE' then
17471: ---5726773
17472: 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
17473: 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));
17474: if (ESTIMATED_REMAINING_EFFORT(l_index2) <> 0) then
17475: pa_progress_utils.get_plan_costs_for_qty
17476: ( p_resource_list_mem_id => l_object_id
17477: ,p_project_id => l_project_id

Line 17687: 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));

17683: --Bug 13823145 changes end here
17684: if l_object_type = 'PA_ASSIGNMENTS' and l_res_class_code = 'EQUIPMENT' then
17685: ---5726773
17686: 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
17687: 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));
17688: if (EQPMT_ETC_EFFORT(l_index2) <> 0) then
17689: pa_progress_utils.get_plan_costs_for_qty
17690: ( p_resource_list_mem_id => l_object_id
17691: ,p_project_id => l_project_id