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_STRUCTURE_PVT1 dependencies on PA_PROJ_ELEMENTS_TMP

Line 8509: FROM PA_PROJ_ELEMENTS_TMP r

8505: SCHEDULED_FINISH_DATE, ELEMENT_VERSION_ID, DURATION, WBS_NUMBER,
8506: OLD_LEVEL , DISPLAY_SEQUENCE, LEVEL WBS_LEVEL ,
8507: SYS_CONNECT_BY_PATH(task_id, '/') connect_path,
8508: connect_by_isleaf leaf_node
8509: FROM PA_PROJ_ELEMENTS_TMP r
8510: START WITH r.PARENT_TASK_ID IS NULL CONNECT BY
8511: PRIOR r.TASK_ID = r.PARENT_TASK_ID ORDER SIBLINGS BY DISPLAY_SEQUENCE , LEVEL_SEQUENCE;
8512:
8513:

Line 8521: PA_PROJ_ELEMENTS_TMP.PROJ_ELEMENT_ID%TYPE;

8517: /* Code change for bug#14765516 - Starts */
8518: l_plsql_max_array_size CONSTANT NUMBER := 100;
8519:
8520: TYPE PROJ_ELEMENT_ID_t IS TABLE OF
8521: PA_PROJ_ELEMENTS_TMP.PROJ_ELEMENT_ID%TYPE;
8522: TYPE SCHEDULED_START_DATE_t IS TABLE OF
8523: PA_PROJ_ELEMENTS_TMP.SCHEDULED_START_DATE%TYPE;
8524: TYPE SCHEDULED_FINISH_DATE_t IS TABLE OF
8525: PA_PROJ_ELEMENTS_TMP.SCHEDULED_FINISH_DATE%TYPE;

Line 8523: PA_PROJ_ELEMENTS_TMP.SCHEDULED_START_DATE%TYPE;

8519:
8520: TYPE PROJ_ELEMENT_ID_t IS TABLE OF
8521: PA_PROJ_ELEMENTS_TMP.PROJ_ELEMENT_ID%TYPE;
8522: TYPE SCHEDULED_START_DATE_t IS TABLE OF
8523: PA_PROJ_ELEMENTS_TMP.SCHEDULED_START_DATE%TYPE;
8524: TYPE SCHEDULED_FINISH_DATE_t IS TABLE OF
8525: PA_PROJ_ELEMENTS_TMP.SCHEDULED_FINISH_DATE%TYPE;
8526: TYPE ELEMENT_VERSION_ID_t IS TABLE OF
8527: PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

Line 8525: PA_PROJ_ELEMENTS_TMP.SCHEDULED_FINISH_DATE%TYPE;

8521: PA_PROJ_ELEMENTS_TMP.PROJ_ELEMENT_ID%TYPE;
8522: TYPE SCHEDULED_START_DATE_t IS TABLE OF
8523: PA_PROJ_ELEMENTS_TMP.SCHEDULED_START_DATE%TYPE;
8524: TYPE SCHEDULED_FINISH_DATE_t IS TABLE OF
8525: PA_PROJ_ELEMENTS_TMP.SCHEDULED_FINISH_DATE%TYPE;
8526: TYPE ELEMENT_VERSION_ID_t IS TABLE OF
8527: PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
8528: TYPE duration_t IS TABLE OF PA_PROJ_ELEMENTS_TMP.duration%TYPE;
8529:

Line 8528: TYPE duration_t IS TABLE OF PA_PROJ_ELEMENTS_TMP.duration%TYPE;

8524: TYPE SCHEDULED_FINISH_DATE_t IS TABLE OF
8525: PA_PROJ_ELEMENTS_TMP.SCHEDULED_FINISH_DATE%TYPE;
8526: TYPE ELEMENT_VERSION_ID_t IS TABLE OF
8527: PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
8528: TYPE duration_t IS TABLE OF PA_PROJ_ELEMENTS_TMP.duration%TYPE;
8529:
8530: TYPE WBS_NUMBER_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.WBS_NUMBER%TYPE;
8531: TYPE OLD_LEVEL_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.OLD_LEVEL%TYPE;
8532: TYPE DISPLAY_SEQUENCE_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.DISPLAY_SEQUENCE%TYPE;

Line 8530: TYPE WBS_NUMBER_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.WBS_NUMBER%TYPE;

8526: TYPE ELEMENT_VERSION_ID_t IS TABLE OF
8527: PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
8528: TYPE duration_t IS TABLE OF PA_PROJ_ELEMENTS_TMP.duration%TYPE;
8529:
8530: TYPE WBS_NUMBER_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.WBS_NUMBER%TYPE;
8531: TYPE OLD_LEVEL_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.OLD_LEVEL%TYPE;
8532: TYPE DISPLAY_SEQUENCE_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.DISPLAY_SEQUENCE%TYPE;
8533: TYPE WBS_LEVEL_T IS TABLE OF PA_PROJ_ELEMENT_VERSIONS.WBS_LEVEL%TYPE;
8534:

Line 8531: TYPE OLD_LEVEL_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.OLD_LEVEL%TYPE;

8527: PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
8528: TYPE duration_t IS TABLE OF PA_PROJ_ELEMENTS_TMP.duration%TYPE;
8529:
8530: TYPE WBS_NUMBER_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.WBS_NUMBER%TYPE;
8531: TYPE OLD_LEVEL_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.OLD_LEVEL%TYPE;
8532: TYPE DISPLAY_SEQUENCE_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.DISPLAY_SEQUENCE%TYPE;
8533: TYPE WBS_LEVEL_T IS TABLE OF PA_PROJ_ELEMENT_VERSIONS.WBS_LEVEL%TYPE;
8534:
8535: TYPE connect_path_t IS TABLE OF VARCHAR2(4000);

Line 8532: TYPE DISPLAY_SEQUENCE_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.DISPLAY_SEQUENCE%TYPE;

8528: TYPE duration_t IS TABLE OF PA_PROJ_ELEMENTS_TMP.duration%TYPE;
8529:
8530: TYPE WBS_NUMBER_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.WBS_NUMBER%TYPE;
8531: TYPE OLD_LEVEL_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.OLD_LEVEL%TYPE;
8532: TYPE DISPLAY_SEQUENCE_T IS TABLE OF PA_PROJ_ELEMENTS_TMP.DISPLAY_SEQUENCE%TYPE;
8533: TYPE WBS_LEVEL_T IS TABLE OF PA_PROJ_ELEMENT_VERSIONS.WBS_LEVEL%TYPE;
8534:
8535: TYPE connect_path_t IS TABLE OF VARCHAR2(4000);
8536: TYPE leaf_node_t IS TABLE OF NUMBER;

Line 8580: delete PA_PROJ_ELEMENTS_TMP;

8576: p_msg_name => 'PA_INVALID_STR_VERSION_ID');
8577: RAISE FND_API.G_EXC_ERROR;
8578: END IF;
8579: /* Added below code to improve performance */
8580: delete PA_PROJ_ELEMENTS_TMP;
8581:
8582: INSERT INTO PA_PROJ_ELEMENTS_TMP(PROJECT_ID, TASK_ID, PARENT_TASK_ID, DISPLAY_SEQUENCE, LEVEL_SEQUENCE, PARENT_STRUCTURE_VERSION_ID,
8583: PROJ_ELEMENT_ID, SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE, ELEMENT_VERSION_ID, DURATION, WBS_NUMBER, OLD_LEVEL, DEFER_CODE, TOP_TASK_ID) /* Modified insert statement for bug#14765516 */
8584: SELECT /*+ ordered use_nl(b a t) index(t pa_tasks_n8) index(a PA_PROJ_ELEMENT_VERSIONS_N1) index(t PA_PROJ_ELEM_VER_SCHEDULE_U2) */

Line 8582: INSERT INTO PA_PROJ_ELEMENTS_TMP(PROJECT_ID, TASK_ID, PARENT_TASK_ID, DISPLAY_SEQUENCE, LEVEL_SEQUENCE, PARENT_STRUCTURE_VERSION_ID,

8578: END IF;
8579: /* Added below code to improve performance */
8580: delete PA_PROJ_ELEMENTS_TMP;
8581:
8582: INSERT INTO PA_PROJ_ELEMENTS_TMP(PROJECT_ID, TASK_ID, PARENT_TASK_ID, DISPLAY_SEQUENCE, LEVEL_SEQUENCE, PARENT_STRUCTURE_VERSION_ID,
8583: PROJ_ELEMENT_ID, SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE, ELEMENT_VERSION_ID, DURATION, WBS_NUMBER, OLD_LEVEL, DEFER_CODE, TOP_TASK_ID) /* Modified insert statement for bug#14765516 */
8584: SELECT /*+ ordered use_nl(b a t) index(t pa_tasks_n8) index(a PA_PROJ_ELEMENT_VERSIONS_N1) index(t PA_PROJ_ELEM_VER_SCHEDULE_U2) */
8585: t.project_id , t.task_id , t.parent_task_id , a.display_sequence ,
8586: a.level_sequence, a.parent_structure_version_id , B.PROJ_ELEMENT_ID,