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 PJI_FM_XBS_ACCUM_TMP1

Line 1648: /+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)/ -- Fix for Bug # 4162534.

1644: IF p_calling_module = 'AMG' THEN
1645: BEGIN
1646: --bug 3824042
1647: SELECT
1648: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1649: nvl(pfxat.prj_brdn_cost,0) planned_cost, nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) planned_effort
1650: INTO l_planned_cost, l_planned_effort
1651: FROM pji_fm_xbs_accum_tmp1 pfxat
1652: WHERE pfxat.project_id = p_project_id

Line 1651: FROM pji_fm_xbs_accum_tmp1 pfxat

1647: SELECT
1648: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1649: nvl(pfxat.prj_brdn_cost,0) planned_cost, nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) planned_effort
1650: INTO l_planned_cost, l_planned_effort
1651: FROM pji_fm_xbs_accum_tmp1 pfxat
1652: WHERE pfxat.project_id = p_project_id
1653: AND pfxat.struct_version_id = p_structure_version_id
1654: AND pfxat.project_element_id = p_object_id
1655: AND pfxat.calendar_type = 'A'

Line 2561: /+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)/ -- Fix for Bug # 4162534.

2557:
2558: /* Begin fix for Bug # 4050324. */
2559: BEGIN
2560: SELECT
2561: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
2562: nvl(pfxat.prj_base_brdn_cost,0)
2563: , (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
2564: INTO l_base_planned_cost
2565: , l_base_planned_effort

Line 2566: FROM pji_fm_xbs_accum_tmp1 pfxat

2562: nvl(pfxat.prj_base_brdn_cost,0)
2563: , (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
2564: INTO l_base_planned_cost
2565: , l_base_planned_effort
2566: FROM pji_fm_xbs_accum_tmp1 pfxat
2567: WHERE pfxat.project_id = p_project_id
2568: AND pfxat.struct_version_id = p_structure_version_id
2569: AND pfxat.project_element_id = p_object_id
2570: AND pfxat.calendar_type = 'A'

Line 8663: -- the temporary table: PJI_FM_XBS_ACCUM_TMP1.This is done once here instead of, for each of the lowest tasks by calling

8659: RAISE FND_API.G_EXC_ERROR;
8660: END IF;
8661:
8662: -- 3.2). Calling PJI API: PJI_FM_XBS_ACCUM_UTILS.POPULATE_WORKPLAN_DATA() to populate
8663: -- the temporary table: PJI_FM_XBS_ACCUM_TMP1.This is done once here instead of, for each of the lowest tasks by calling
8664: -- PA_PROGRESS_PUB.push_workplan_actuals() with p_call_pji_apis_flag = 'Y'.
8665: -- Bug 3834339 : reducing the scope of IF so that populate_workplan_data gets called in version disabled case too
8666: END IF; -- IF (l_version_enabled_flag = 'Y') THEN
8667:

Line 8714: /+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)/ -- Fix for Bug # 4162534.

8710:
8711: DECLARE
8712: CURSOR tmp1 IS
8713: SELECT
8714: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
8715: * FROM pji_fm_xbs_accum_tmp1 WHERE project_id = p_project_id
8716: AND struct_version_id =p_working_str_version_id
8717: ;
8718: BEGIN

Line 8715: * FROM pji_fm_xbs_accum_tmp1 WHERE project_id = p_project_id

8711: DECLARE
8712: CURSOR tmp1 IS
8713: SELECT
8714: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
8715: * FROM pji_fm_xbs_accum_tmp1 WHERE project_id = p_project_id
8716: AND struct_version_id =p_working_str_version_id
8717: ;
8718: BEGIN
8719: FOR tmp1_rec IN tmp1 LOOP

Line 13649: -- BEGIN: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.

13645: ETC_RATE_BASED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
13646: ETC_PRJ_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
13647: ETC_PFC_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
13648:
13649: -- BEGIN: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.
13650:
13651: t_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
13652: t_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
13653: t_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;

Line 13683: -- END: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.

13679: l_period_flag VARCHAR2(1);
13680: l_last_period_flag VARCHAR2(1);
13681: l_extraction_type VARCHAR2(30);
13682:
13683: -- END: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.
13684:
13685: -- cursor to get rollup record for as of date
13686: cursor rollup_rec_asofdate is
13687: select PROGRESS_ROLLUP_ID,

Line 14161: /+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)/ -- Bug # 4162534.

14157:
14158: -- cursor to get all objects from summ temp table
14159: cursor all_objects_in_temp is
14160: select
14161: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Bug # 4162534.
14162: *
14163: from pji_fm_xbs_accum_tmp1
14164: where project_id = l_project_id
14165: and struct_version_id = l_latest_wp_struct_ver_id

Line 14163: from pji_fm_xbs_accum_tmp1

14159: cursor all_objects_in_temp is
14160: select
14161: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Bug # 4162534.
14162: *
14163: from pji_fm_xbs_accum_tmp1
14164: where project_id = l_project_id
14165: and struct_version_id = l_latest_wp_struct_ver_id
14166: and nvl(plan_version_id,-1) = decode(p_plan_res_level,'Y',-1,nvl(plan_version_id,-1))
14167: and project_element_id > 0

Line 14244: /+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)/ -- Fix for Bug # 4162534.

14240: /* Begin: Fix for Bug # 4018249. */
14241:
14242: cursor cur_record_count(l_cur_project_id NUMBER) is
14243: select
14244: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
14245: count(*)
14246: from pji_fm_xbs_accum_tmp1
14247: where project_id = l_cur_project_id;
14248:

Line 14246: from pji_fm_xbs_accum_tmp1

14242: cursor cur_record_count(l_cur_project_id NUMBER) is
14243: select
14244: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
14245: count(*)
14246: from pji_fm_xbs_accum_tmp1
14247: where project_id = l_cur_project_id;
14248:
14249: l_record_count NUMBER := null;
14250:

Line 15175: -- BEGIN: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.

15171: nvl(l_period_flag,'N') <> nvl(l_last_period_flag,'N') or
15172: (l_object_Type = 'PA_ASSIGNMENTS' and (nvl(l_last_res_list_mem_id,-99) <> nvl(l_new_res_list_member_id,-99))) or
15173: (l_object_Type = 'PA_ASSIGNMENTS' and (nvl(l_last_cbs_element_id,-99) <> nvl(l_cbs_element_id,-99)))) then --22 -- CBS Check
15174:
15175: -- BEGIN: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.
15176:
15177: if (l_object_Type = 'PA_ASSIGNMENTS') then
15178:
15179: -- create a new record in the temp table:

Line 15214: -- END: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.

15210: t_max_end_date(l_t_index) := all_objects_in_temp_rec.max_end_date;
15211:
15212: end if;
15213:
15214: -- END: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.
15215:
15216: open w_rollup_rec_asofdate;
15217: fetch w_rollup_rec_asofdate into l_w_rollup_rec_asofdate;
15218: if w_rollup_rec_asofdate%notfound then

Line 19575: -- BEGIN: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.

19571: ,ETC_CBS_ELEMENT_ID(i));
19572: end if;
19573:
19574:
19575: -- BEGIN: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.
19576:
19577: -- Bulk insert into the table: PA_PROG_ACT_BY_PERIOD_TEMP.
19578: pa_debug.log_message('GET_SUMM_ACT: Before inserting records in PA_PROG_ACT_BY_PERIOD_TEMP. Record Count = '||l_t_index, 1);
19579:

Line 19640: -- END: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.

19636: ,to_number(null)
19637: ,t_min_start_date(i)
19638: ,t_max_end_date(i));
19639:
19640: -- END: Changes to take care of period flagged rows from the pji temporary table: pji_fm_xbs_accum_tmp1.
19641:
19642: /* Begin: Fix for Bug # 5526638. */
19643: /* Added If for Bug # 5659575*/
19644: if p_extraction_type <> 'PUBLISH' then