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_PVT1 dependencies on PA_PROJ_ELEM_RELATIONSHIP_T

Line 4985: DELETE FROM PA_PROJ_ELEM_RELATIONSHIP_T;

4981:
4982: -- START Sridhar Huawei 18-Sept add the below if statement and the code . Moved the below DELETE and insert to here
4983: IF p_Action = 'MOVE' THEN
4984:
4985: DELETE FROM PA_PROJ_ELEM_RELATIONSHIP_T;
4986:
4987: INSERT INTO PA_PROJ_ELEM_RELATIONSHIP_T (PARENT_STRUCTURE_VERSION_ID, CHILD_VER_ID,
4988: PARENT_VER_ID, DISPLAY_SEQUENCE, OBJECT_ID_TO1, OBJECT_TYPE_TO, RELATIONSHIP_TYPE,
4989: OBJECT_ID_FROM1, OBJECT_TYPE_FROM)

Line 4987: INSERT INTO PA_PROJ_ELEM_RELATIONSHIP_T (PARENT_STRUCTURE_VERSION_ID, CHILD_VER_ID,

4983: IF p_Action = 'MOVE' THEN
4984:
4985: DELETE FROM PA_PROJ_ELEM_RELATIONSHIP_T;
4986:
4987: INSERT INTO PA_PROJ_ELEM_RELATIONSHIP_T (PARENT_STRUCTURE_VERSION_ID, CHILD_VER_ID,
4988: PARENT_VER_ID, DISPLAY_SEQUENCE, OBJECT_ID_TO1, OBJECT_TYPE_TO, RELATIONSHIP_TYPE,
4989: OBJECT_ID_FROM1, OBJECT_TYPE_FROM)
4990: SELECT pev.parent_structure_version_id,
4991: pev.element_version_id child_ver_id,

Line 5031: -- populating data in PA_PROJ_ELEM_RELATIONSHIP_T temp table.

5027: ' WBS NUMBER: '||cur_print_wbs_rec.wbs_number );
5028: END LOOP;
5029: END; */
5030: --Bug 13895419 start
5031: -- populating data in PA_PROJ_ELEM_RELATIONSHIP_T temp table.
5032: -- Sridhar Huawei 18-Sept Moved the DELETE and insert above.
5033: /*DELETE FROM PA_PROJ_ELEM_RELATIONSHIP_T;
5034:
5035: INSERT INTO PA_PROJ_ELEM_RELATIONSHIP_T (PARENT_STRUCTURE_VERSION_ID, CHILD_VER_ID,

Line 5033: /*DELETE FROM PA_PROJ_ELEM_RELATIONSHIP_T;

5029: END; */
5030: --Bug 13895419 start
5031: -- populating data in PA_PROJ_ELEM_RELATIONSHIP_T temp table.
5032: -- Sridhar Huawei 18-Sept Moved the DELETE and insert above.
5033: /*DELETE FROM PA_PROJ_ELEM_RELATIONSHIP_T;
5034:
5035: INSERT INTO PA_PROJ_ELEM_RELATIONSHIP_T (PARENT_STRUCTURE_VERSION_ID, CHILD_VER_ID,
5036: PARENT_VER_ID, DISPLAY_SEQUENCE, OBJECT_ID_TO1, OBJECT_TYPE_TO, RELATIONSHIP_TYPE,
5037: OBJECT_ID_FROM1, OBJECT_TYPE_FROM)

Line 5035: INSERT INTO PA_PROJ_ELEM_RELATIONSHIP_T (PARENT_STRUCTURE_VERSION_ID, CHILD_VER_ID,

5031: -- populating data in PA_PROJ_ELEM_RELATIONSHIP_T temp table.
5032: -- Sridhar Huawei 18-Sept Moved the DELETE and insert above.
5033: /*DELETE FROM PA_PROJ_ELEM_RELATIONSHIP_T;
5034:
5035: INSERT INTO PA_PROJ_ELEM_RELATIONSHIP_T (PARENT_STRUCTURE_VERSION_ID, CHILD_VER_ID,
5036: PARENT_VER_ID, DISPLAY_SEQUENCE, OBJECT_ID_TO1, OBJECT_TYPE_TO, RELATIONSHIP_TYPE,
5037: OBJECT_ID_FROM1, OBJECT_TYPE_FROM)
5038: SELECT pev.parent_structure_version_id,
5039: pev.element_version_id child_ver_id,

Line 5112: UPDATE PA_PROJ_ELEM_RELATIONSHIP_T

5108: WHERE element_version_id = cur_affected_tasks_rec.element_version_id;
5109:
5110: --Bug 13895419 start
5111: -- Update new display sequence
5112: UPDATE PA_PROJ_ELEM_RELATIONSHIP_T
5113: SET display_sequence = l_new_display_sequence
5114: WHERE child_ver_id = cur_affected_tasks_rec.element_version_id;
5115:
5116: --update wbs number for affected tasks

Line 5171: UPDATE PA_PROJ_ELEM_RELATIONSHIP_T

5167: WHERE element_version_id = cur_actual_tasks_rec.element_version_id;
5168:
5169: --Bug 13895419 start
5170: -- Update new display sequence
5171: UPDATE PA_PROJ_ELEM_RELATIONSHIP_T
5172: SET display_sequence = l_new_display_sequence
5173: WHERE child_ver_id = cur_actual_tasks_rec.element_version_id;
5174:
5175: --update wbs number for actual tasks