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 13231: from pa_progress_rollup ppr

13227:
13228: cursor cur_progress (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER,
13229: p_structure_version_id NUMBER) is
13230: select *
13231: from pa_progress_rollup ppr
13232: where ppr.project_id = p_project_id
13233: and ppr.object_id = p_object_id
13234: and ppr.object_version_id = p_object_version_id
13235: and ppr.structure_version_id = p_structure_version_id

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

13234: and ppr.object_version_id = p_object_version_id
13235: and ppr.structure_version_id = p_structure_version_id
13236: and ppr.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES') -- 4498610 : Added PA_STRUCTURES also
13237: and ppr.current_flag = 'Y'
13238: and ppr.as_of_date = (select max(as_of_date) from pa_progress_rollup ppr2
13239: where ppr2.project_id = p_project_id
13240: and ppr2.object_id = p_object_id
13241: and ppr2.object_version_id = p_object_version_id
13242: and ppr2.structure_version_id = p_structure_version_id

Line 13251: from pa_progress_rollup ppr

13247:
13248: cursor cur_progress2 (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER,
13249: p_structure_version_id NUMBER, p_current_flag VARCHAR2) is
13250: select *
13251: from pa_progress_rollup ppr
13252: where ppr.project_id = p_project_id
13253: and ppr.object_id = p_object_id
13254: and ppr.object_version_id = p_object_version_id
13255: and ppr.structure_version_id IS NULL

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

13255: and ppr.structure_version_id IS NULL
13256: and ppr.current_flag = p_current_flag
13257: and ppr.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES'); -- 4498610 : Added PA_STRUCTURES also
13258: --bug 3959087, following code is commented as it is not needed
13259: /*and ppr.as_of_date = (select max(as_of_date) from pa_progress_rollup ppr2
13260: where ppr2.project_id = p_project_id
13261: and ppr2.object_id = p_object_id
13262: and ppr2.object_version_id = p_object_version_id
13263: and ppr2.structure_version_id IS NULL

Line 13291: from pa_progress_rollup

13287: cursor cur_prev_etc_effort (p_project_id NUMBER, p_object_id NUMBER
13288: , p_structure_version_id NUMBER) is
13289: select (nvl(estimated_remaining_effort,0)+nvl(eqpmt_etc_effort,0)
13290: +nvl(subprj_ppl_etc_effort,0)+nvl(subprj_eqpmt_etc_effort,0))
13291: from pa_progress_rollup
13292: where project_id = p_project_id
13293: and object_id = p_object_id
13294: and structure_version_id = p_structure_version_id
13295: and structure_type = 'WORKPLAN';

Line 13302: from pa_progress_rollup

13298: cursor cur_prev_etc_effort2 (p_project_id NUMBER, p_object_id NUMBER
13299: ) is
13300: select (nvl(estimated_remaining_effort,0)+nvl(eqpmt_etc_effort,0)
13301: +nvl(subprj_ppl_etc_effort,0)+nvl(subprj_eqpmt_etc_effort,0))
13302: from pa_progress_rollup
13303: where project_id = p_project_id
13304: and object_id = p_object_id
13305: and structure_version_id is null
13306: and current_flag = 'Y'

Line 13362: from pa_progress_rollup

13358: l_rollup_as_of_date DATE;
13359:
13360: cursor c_max_as_of_date_wkg is
13361: select max(as_of_date)
13362: from pa_progress_rollup
13363: where project_id = p_project_id
13364: -- and object_version_id = p_task_ver_id Bug 3856161 : It shd always do rollup if record exists
13365: -- and object_type = p_object_type
13366: and structure_type = 'WORKPLAN'

Line 13417: from pa_progress_rollup ppr

13413:
13414: cursor cur_rollup_percent (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER,
13415: p_structure_version_id NUMBER) is
13416: 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
13417: from pa_progress_rollup ppr
13418: where ppr.project_id = p_project_id
13419: and ppr.object_id = p_object_id
13420: and ppr.object_version_id = p_object_version_id
13421: and ppr.structure_version_id = p_structure_version_id

Line 13429: from pa_progress_rollup ppr

13425:
13426: cursor cur_rollup_percent2 (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER,
13427: p_structure_version_id NUMBER) is
13428: 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
13429: from pa_progress_rollup ppr
13430: where ppr.project_id = p_project_id
13431: and ppr.object_id = p_object_id
13432: and ppr.object_version_id = p_object_version_id
13433: and ppr.structure_version_id IS NULL

Line 13443: from pa_progress_rollup ppr

13439:
13440: -- Bug 3976633 : Added cursor cur_progress_exists
13441: cursor cur_progress_exists (c_project_id NUMBER, c_object_id NUMBER, c_structure_version_id NUMBER, c_version_enabled_flag VARCHAR2) is
13442: select 'Y'
13443: from pa_progress_rollup ppr
13444: where ppr.project_id = c_project_id
13445: and ppr.object_id = c_object_id
13446: 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))
13447: and ppr.object_type = 'PA_TASKS'

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

13775: END IF; --<< l_planned_effort >>
13776:
13777: -- Progress Management Changes, Bug # 3420093.
13778:
13779: -- The following code inserts progress records into the pa_progress_rollup_table.
13780: -- this is required if only any of: p_etc_effort, p_etc_cost and p_percent_complete is not null
13781:
13782:
13783: --if ((nvl(p_etc_effort,0) > 0 and p_etc_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

13792:
13793: IF (nvl(p_percent_complete,0) > 0 AND p_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
13794: THEN
13795: -- Progress Management Changes, Bug # 3420093.
13796: -- Begin logic to create pa_progress_rollup record for the Task / Assignment:
13797: -- Get the next progress cycle id.
13798: -- Bug 3856161 : Moving this code outside
13799: --l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id
13800: -- , p_task_id => l_task_id);

Line 13980: update pa_progress_rollup set

13976: open cur_progress2(p_project_id,l_object_id,p_task_ver_id,null,'Y');
13977: fetch cur_progress2 into cur_progress_rec;
13978: IF cur_progress2%found THEN
13979:
13980: update pa_progress_rollup set
13981: --as_of_date = l_next_prog_cycle_date,
13982: estimated_remaining_effort = null --l_etc_effort
13983: ,completed_percentage = l_percent_complete
13984: ,eff_rollup_percent_comp = l_eff_rollup_pc

Line 14017: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

14013: close cur_progress_status;
14014:
14015: -- End modifications for Bug # 3879658.
14016:
14017: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
14018: X_PROGRESS_ROLLUP_ID => l_progress_rollup_id
14019: ,X_PROJECT_ID => p_project_id
14020: ,X_OBJECT_ID => l_object_id
14021: ,X_OBJECT_TYPE => p_object_type

Line 14164: update pa_progress_rollup set

14160: open cur_progress(p_project_id,l_object_id,p_task_ver_id,p_structure_version_id);
14161: fetch cur_progress into cur_progress_rec;
14162: if cur_progress%found then
14163:
14164: update pa_progress_rollup set
14165: --as_of_date = l_next_prog_cycle_date,
14166: estimated_remaining_effort = null --l_etc_effort
14167: ,completed_percentage = l_percent_complete
14168: ,eff_rollup_percent_comp = l_eff_rollup_pc

Line 14227: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

14223: close cur_progress_status;
14224:
14225: -- End modifications for Bug # 3879658.
14226:
14227: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
14228: X_PROGRESS_ROLLUP_ID => l_progress_rollup_id
14229: ,X_PROJECT_ID => p_project_id
14230: ,X_OBJECT_ID => l_object_id
14231: ,X_OBJECT_TYPE => p_object_type

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

14443: END IF ;--IF NVL(l_progress_exists, 'N') = 'Y' THEN
14444: END IF;-- p_object_type = 'PA_TASKS' THEN-- Bug 4498610 : Added END IF
14445: END IF; -- if (p_object_type ='PA_TASKS') then
14446:
14447: -- Code to insert progress records nto the pa_progress_rollup_table.
14448:
14449: /* END: The above actions are to be performed only when p_object_type = 'PA_TASKS'. */
14450:
14451:

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

14539: ,p_as_of_date => l_rollup_as_of_date
14540: ,x_return_status => l_return_status
14541: ,x_msg_count => l_msg_count
14542: ,x_msg_data => l_msg_data);
14543: -- Code to insert progress records nto the pa_progress_rollup_table.
14544:
14545: end if;
14546: close c_max_as_of_date_wkg;
14547: END IF; -- IF NVL(l_progress_exists, 'N') = 'Y'