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_TASK_PUB1 dependencies on PA_PROGRESS_ROLLUP

Line 13755: from pa_progress_rollup ppr

13751:
13752: cursor cur_progress (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER,
13753: p_structure_version_id NUMBER) is
13754: select *
13755: from pa_progress_rollup ppr
13756: where ppr.project_id = p_project_id
13757: and ppr.object_id = p_object_id
13758: and ppr.object_version_id = p_object_version_id
13759: and ppr.structure_version_id = p_structure_version_id

Line 13762: and ppr.as_of_date = (select max(as_of_date) from pa_progress_rollup ppr2

13758: and ppr.object_version_id = p_object_version_id
13759: and ppr.structure_version_id = p_structure_version_id
13760: and ppr.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES') -- 4498610 : Added PA_STRUCTURES also
13761: and ppr.current_flag = 'Y'
13762: and ppr.as_of_date = (select max(as_of_date) from pa_progress_rollup ppr2
13763: where ppr2.project_id = p_project_id
13764: and ppr2.object_id = p_object_id
13765: and ppr2.object_version_id = p_object_version_id
13766: and ppr2.structure_version_id = p_structure_version_id

Line 13775: from pa_progress_rollup ppr

13771:
13772: cursor cur_progress2 (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER,
13773: p_structure_version_id NUMBER, p_current_flag VARCHAR2) is
13774: select *
13775: from pa_progress_rollup ppr
13776: where ppr.project_id = p_project_id
13777: and ppr.object_id = p_object_id
13778: and ppr.object_version_id = p_object_version_id
13779: and ppr.structure_version_id IS NULL

Line 13783: /*and ppr.as_of_date = (select max(as_of_date) from pa_progress_rollup ppr2

13779: and ppr.structure_version_id IS NULL
13780: and ppr.current_flag = p_current_flag
13781: and ppr.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES'); -- 4498610 : Added PA_STRUCTURES also
13782: --bug 3959087, following code is commented as it is not needed
13783: /*and ppr.as_of_date = (select max(as_of_date) from pa_progress_rollup ppr2
13784: where ppr2.project_id = p_project_id
13785: and ppr2.object_id = p_object_id
13786: and ppr2.object_version_id = p_object_version_id
13787: and ppr2.structure_version_id IS NULL

Line 13815: from pa_progress_rollup

13811: cursor cur_prev_etc_effort (p_project_id NUMBER, p_object_id NUMBER
13812: , p_structure_version_id NUMBER) is
13813: select (nvl(estimated_remaining_effort,0)+nvl(eqpmt_etc_effort,0)
13814: +nvl(subprj_ppl_etc_effort,0)+nvl(subprj_eqpmt_etc_effort,0))
13815: from pa_progress_rollup
13816: where project_id = p_project_id
13817: and object_id = p_object_id
13818: and structure_version_id = p_structure_version_id
13819: and structure_type = 'WORKPLAN';

Line 13826: from pa_progress_rollup

13822: cursor cur_prev_etc_effort2 (p_project_id NUMBER, p_object_id NUMBER
13823: ) is
13824: select (nvl(estimated_remaining_effort,0)+nvl(eqpmt_etc_effort,0)
13825: +nvl(subprj_ppl_etc_effort,0)+nvl(subprj_eqpmt_etc_effort,0))
13826: from pa_progress_rollup
13827: where project_id = p_project_id
13828: and object_id = p_object_id
13829: and structure_version_id is null
13830: and current_flag = 'Y'

Line 13886: from pa_progress_rollup

13882: l_rollup_as_of_date DATE;
13883:
13884: cursor c_max_as_of_date_wkg is
13885: select max(as_of_date)
13886: from pa_progress_rollup
13887: where project_id = p_project_id
13888: -- and object_version_id = p_task_ver_id Bug 3856161 : It shd always do rollup if record exists
13889: -- and object_type = p_object_type
13890: and structure_type = 'WORKPLAN'

Line 13941: from pa_progress_rollup ppr

13937:
13938: cursor cur_rollup_percent (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER,
13939: p_structure_version_id NUMBER) is
13940: select ppr.EFF_ROLLUP_PERCENT_COMP,ppr.completed_percentage, actual_start_date, actual_finish_date -- 4498610 : Added completed_percentage, actual_start_date, actual_finish_date
13941: from pa_progress_rollup ppr
13942: where ppr.project_id = p_project_id
13943: and ppr.object_id = p_object_id
13944: and ppr.object_version_id = p_object_version_id
13945: and ppr.structure_version_id = p_structure_version_id

Line 13953: from pa_progress_rollup ppr

13949:
13950: cursor cur_rollup_percent2 (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER,
13951: p_structure_version_id NUMBER) is
13952: select ppr.EFF_ROLLUP_PERCENT_COMP,ppr.completed_percentage, actual_start_date, actual_finish_date -- 4498610 : Added completed_percentage, actual_start_date, actual_finish_date
13953: from pa_progress_rollup ppr
13954: where ppr.project_id = p_project_id
13955: and ppr.object_id = p_object_id
13956: and ppr.object_version_id = p_object_version_id
13957: and ppr.structure_version_id IS NULL

Line 13967: from pa_progress_rollup ppr

13963:
13964: -- Bug 3976633 : Added cursor cur_progress_exists
13965: cursor cur_progress_exists (c_project_id NUMBER, c_object_id NUMBER, c_structure_version_id NUMBER, c_version_enabled_flag VARCHAR2) is
13966: select 'Y'
13967: from pa_progress_rollup ppr
13968: where ppr.project_id = c_project_id
13969: and ppr.object_id = c_object_id
13970: and ((c_version_enabled_flag = 'N' AND ppr.structure_version_id IS NULL) OR (c_version_enabled_flag = 'Y' AND ppr.structure_version_id = p_structure_version_id))
13971: and ppr.object_type = 'PA_TASKS'

Line 14303: -- The following code inserts progress records into the pa_progress_rollup_table.

14299: END IF; --<< l_planned_effort >>
14300:
14301: -- Progress Management Changes, Bug # 3420093.
14302:
14303: -- The following code inserts progress records into the pa_progress_rollup_table.
14304: -- this is required if only any of: p_etc_effort, p_etc_cost and p_percent_complete is not null
14305:
14306:
14307: --if ((nvl(p_etc_effort,0) > 0 and p_etc_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 14320: -- Begin logic to create pa_progress_rollup record for the Task / Assignment:

14316:
14317: IF (nvl(p_percent_complete,0) > 0 AND p_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14318: THEN
14319: -- Progress Management Changes, Bug # 3420093.
14320: -- Begin logic to create pa_progress_rollup record for the Task / Assignment:
14321: -- Get the next progress cycle id.
14322: -- Bug 3856161 : Moving this code outside
14323: --l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id
14324: -- , p_task_id => l_task_id);

Line 14504: update pa_progress_rollup set

14500: open cur_progress2(p_project_id,l_object_id,p_task_ver_id,null,'Y');
14501: fetch cur_progress2 into cur_progress_rec;
14502: IF cur_progress2%found THEN
14503:
14504: update pa_progress_rollup set
14505: --as_of_date = l_next_prog_cycle_date,
14506: estimated_remaining_effort = null --l_etc_effort
14507: ,completed_percentage = l_percent_complete
14508: ,eff_rollup_percent_comp = l_eff_rollup_pc

Line 14541: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

14537: close cur_progress_status;
14538:
14539: -- End modifications for Bug # 3879658.
14540:
14541: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
14542: X_PROGRESS_ROLLUP_ID => l_progress_rollup_id
14543: ,X_PROJECT_ID => p_project_id
14544: ,X_OBJECT_ID => l_object_id
14545: ,X_OBJECT_TYPE => p_object_type

Line 14688: update pa_progress_rollup set

14684: open cur_progress(p_project_id,l_object_id,p_task_ver_id,p_structure_version_id);
14685: fetch cur_progress into cur_progress_rec;
14686: if cur_progress%found then
14687:
14688: update pa_progress_rollup set
14689: --as_of_date = l_next_prog_cycle_date,
14690: estimated_remaining_effort = null --l_etc_effort
14691: ,completed_percentage = l_percent_complete
14692: ,eff_rollup_percent_comp = l_eff_rollup_pc

Line 14751: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

14747: close cur_progress_status;
14748:
14749: -- End modifications for Bug # 3879658.
14750:
14751: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
14752: X_PROGRESS_ROLLUP_ID => l_progress_rollup_id
14753: ,X_PROJECT_ID => p_project_id
14754: ,X_OBJECT_ID => l_object_id
14755: ,X_OBJECT_TYPE => p_object_type

Line 14974: -- Code to insert progress records nto the pa_progress_rollup_table.

14970: END IF ;--IF NVL(l_progress_exists, 'N') = 'Y' THEN
14971: END IF;-- p_object_type = 'PA_TASKS' THEN-- Bug 4498610 : Added END IF
14972: END IF; -- if (p_object_type ='PA_TASKS') then
14973:
14974: -- Code to insert progress records nto the pa_progress_rollup_table.
14975:
14976: /* END: The above actions are to be performed only when p_object_type = 'PA_TASKS'. */
14977:
14978:

Line 15072: -- Code to insert progress records nto the pa_progress_rollup_table.

15068: ,p_as_of_date => l_rollup_as_of_date
15069: ,x_return_status => l_return_status
15070: ,x_msg_count => l_msg_count
15071: ,x_msg_data => l_msg_data);
15072: -- Code to insert progress records nto the pa_progress_rollup_table.
15073: END IF;
15074: end if;
15075: close c_max_as_of_date_wkg;
15076: END IF; -- IF NVL(l_progress_exists, 'N') = 'Y'