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_PROJECT_DATES_PUB dependencies on PA_TASKS

Line 54: FROM PA_TASKS

50:
51: CURSOR task_csr
52: IS
53: SELECT task_id
54: FROM PA_TASKS
55: WHERE project_id = p_project_id
56: ORDER BY wbs_level;
57:
58: CURSOR latest_published_ver_csr

Line 85: AND object_type = 'PA_TASKS'

81: SELECT estimated_start_date, estimated_finish_date
82: FROM PA_PROGRESS_ROLLUP
83: WHERE project_id = p_project_id
84: AND object_id = c_task_id
85: AND object_type = 'PA_TASKS'
86: AND as_of_date = (
87: select max(as_of_date) from pa_progress_rollup
88: where project_id = p_project_id
89: and object_id = c_task_id

Line 90: and object_type = 'PA_TASKS'

86: AND as_of_date = (
87: select max(as_of_date) from pa_progress_rollup
88: where project_id = p_project_id
89: and object_id = c_task_id
90: and object_type = 'PA_TASKS'
91: );
92:
93: CURSOR get_task_act_dates_csr(c_task_id NUMBER)
94: IS

Line 99: AND object_type = 'PA_TASKS'

95: SELECT actual_start_date, actual_finish_date
96: FROM PA_PROGRESS_ROLLUP
97: WHERE project_id = p_project_id
98: AND object_id = c_task_id
99: AND object_type = 'PA_TASKS'
100: AND as_of_date = (
101: select max(as_of_date) from pa_progress_rollup
102: where project_id = p_project_id
103: and object_id = c_task_id

Line 104: and object_type = 'PA_TASKS'

100: AND as_of_date = (
101: select max(as_of_date) from pa_progress_rollup
102: where project_id = p_project_id
103: and object_id = c_task_id
104: and object_type = 'PA_TASKS'
105: );
106:
107: CURSOR get_task_bas_dates_csr(c_task_id NUMBER)
108: IS

Line 148: FROM PA_TASKS

144:
145: CURSOR get_task_record_ver_number(c_task_id NUMBER)
146: IS
147: SELECT record_version_number
148: FROM PA_TASKS
149: WHERE task_id = c_task_id;
150:
151: CURSOR get_structure
152: IS

Line 194: AND b.object_type_to = 'PA_TASKS'

190: ,pa_proj_elements c --bug 4606475
191: WHERE a.parent_structure_version_id = c_structure_version_id
192: AND a.project_id = p_project_id
193: AND a.element_version_id = b.object_id_to1
194: AND b.object_type_to = 'PA_TASKS'
195: AND b.relationship_type(+) = 'S'
196: --bug 4606475
197: AND c.proj_element_id = a.proj_element_id
198: AND c.project_id=a.project_id

Line 339: UPDATE pa_tasks

335:
336: --bug 4241863
337: IF l_act_fin_date_flag = 'Y'
338: THEN
339: UPDATE pa_tasks
340: set completion_date = NULL
341: WHERE project_id=p_project_id;
342: END IF;
343: --end bug 4241863

Line 432: --first. Else, PA_TASKS_MAINT_UTILS.CHECK_START_DATE results in an error when a buffer value

428: end if;
429:
430: --Bug 3919138 : Sort the rollup table by wbs_level in ascending order.
431: --This is necessary because update_task api below must be called with the parent tasks
432: --first. Else, PA_TASKS_MAINT_UTILS.CHECK_START_DATE results in an error when a buffer value
433: --exists for adjusting task start dates
434: DECLARE
435: l_temp_object_id NUMBER;
436: l_temp_object_type VARCHAR2(30);

Line 536: IF (l_rollup_table(l_cnt).object_type = 'PA_TASKS') THEN

532: LOOP
533: --bug 3716805
534: exit when l_rollup_table.count = 0;
535: --end bug 3716805
536: IF (l_rollup_table(l_cnt).object_type = 'PA_TASKS') THEN
537: /* Not doing anything. Also I checked PA_TASK_MAINT_PUB and PVT.update_task. Its not using record version number
538: so its useless here.
539: OPEN get_task_record_ver_number(l_task_id);
540: FETCH get_task_record_ver_number INTO l_task_record_version_number;

Line 562: FROM pa_tasks pt

558: pt.completion_date
559: INTO l_parent_task_id,
560: l_tstart_date,
561: l_tend_date
562: FROM pa_tasks pt
563: WHERE pt.task_id = l_proj_element_id2;
564:
565: IF ((nvl(l_rollup_table(l_cnt).start_date1,sysdate) <> nvl(l_tstart_date,sysdate))
566: OR (nvl(l_rollup_table(l_cnt).finish_date1,sysdate) <> nvl(l_tend_date,sysdate))) THEN

Line 580: PA_TASKS_MAINT_PUB.Update_Task (

576:
577: END IF;
578:
579: /* End of changes for bug 5665772 */
580: PA_TASKS_MAINT_PUB.Update_Task (
581: p_init_msg_list => p_init_msg_list
582: ,p_commit => FND_API.G_FALSE
583: ,p_validate_only => p_validate_only
584: ,p_calling_module => p_calling_module

Line 637: PA_TASKS_MAINT_UTILS.Check_Start_Date(

633:
634: IF (nvl(l_task_dates(l_tcnt).old_start_date,sysdate) <>
635: nvl(l_task_dates(l_tcnt).new_start_date,sysdate)) THEN
636:
637: PA_TASKS_MAINT_UTILS.Check_Start_Date(
638: p_project_id => p_project_id,
639: p_parent_task_id => l_task_dates(l_tcnt).parent_task_id,
640: p_task_id => NULL,
641: p_start_date => l_task_dates(l_tcnt).new_start_date,

Line 655: PA_TASKS_MAINT_UTILS.Check_End_Date(

651:
652: IF (nvl(l_task_dates(l_tcnt).old_end_date,sysdate) <>
653: nvl(l_task_dates(l_tcnt).new_end_date,sysdate)) THEN
654:
655: PA_TASKS_MAINT_UTILS.Check_End_Date(
656: p_project_id => p_project_id,
657: p_parent_task_id => l_task_dates(l_tcnt).parent_task_id,
658: p_task_id => l_task_dates(l_tcnt).task_id,
659: p_end_date => l_task_dates(l_tcnt).new_end_date,

Line 775: -- PA_TASKS_MAINT_PUB.Update_Task (

771: -- l_task_start_date := l_task_start_date + p_buffer;
772: -- l_task_finish_date := l_task_finish_date + p_buffer;
773: -- end if;
774: --
775: -- PA_TASKS_MAINT_PUB.Update_Task (
776: -- p_init_msg_list => p_init_msg_list
777: -- ,p_commit => FND_API.G_FALSE
778: -- ,p_validate_only => p_validate_only
779: -- ,p_calling_module => p_calling_module