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_ASSIGNMENTS_PUB dependencies on PA_COPY_ASGMTS_TEMP

Line 1589: FROM pa_resource_assignments ra, pa_copy_asgmts_temp cat

1585: CURSOR C_Get_Default_Res_Asgmt(p_project_id IN NUMBER,
1586: p_budget_version_id IN NUMBER)
1587: IS
1588: SELECT resource_assignment_id, wbs_element_version_id
1589: FROM pa_resource_assignments ra, pa_copy_asgmts_temp cat
1590: WHERE ra.wbs_element_version_id = cat.src_elem_ver_id
1591: AND ra.project_id = p_project_id
1592: AND ra.budget_version_id = p_budget_version_id
1593: AND ra.ta_display_flag = 'N';

Line 2683: * 1. Insert the task version ids into an existing temp table, PA_COPY_ASGMTS_TEMP

2679: --Changes for Bug 3910882 Begin
2680: /* Updates from the Bug
2681: The UPDATE does not perform very well in volume env. My suggestion to improve
2682: this is to replace the FORALL UPDATE by 2 operations:
2683: * 1. Insert the task version ids into an existing temp table, PA_COPY_ASGMTS_TEMP
2684: * 2. Select resource assignments from pa_resource_assignments joining to the temp table
2685: */
2686:
2687: -- dynamically computing the statistics for the Temporary table

Line 2699: pa_task_assignment_utils.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP',

2695: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
2696:
2697: -- Manually seed the statistics for the temporary table.
2698: -- Bug 8261905, Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
2699: pa_task_assignment_utils.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP',
2700: l_num_of_tasks, l_num_blocks, 75);
2701:
2702: -- delete content from temp table before inserting
2703: DELETE pa_copy_asgmts_temp;

Line 2703: DELETE pa_copy_asgmts_temp;

2699: pa_task_assignment_utils.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP',
2700: l_num_of_tasks, l_num_blocks, 75);
2701:
2702: -- delete content from temp table before inserting
2703: DELETE pa_copy_asgmts_temp;
2704:
2705: -- bulk inserting the task version ids into the temp table
2706: -- Changed due to bug 4153366
2707: FORALL i IN 1..l_task_elem_version_id_tbl.COUNT

Line 2708: INSERT INTO pa_copy_asgmts_temp VALUES

2704:
2705: -- bulk inserting the task version ids into the temp table
2706: -- Changed due to bug 4153366
2707: FORALL i IN 1..l_task_elem_version_id_tbl.COUNT
2708: INSERT INTO pa_copy_asgmts_temp VALUES
2709: (l_task_elem_version_id_tbl(i), -1, null, null, null, null);
2710:
2711: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2712: pa_debug.g_err_stage:='Successfully inserted task version ids into the temp table';

Line 4221: FROM pa_resource_assignments ra, pa_copy_asgmts_temp cat

4217: CURSOR C_Get_Default_Res_Asgmt(p_project_id IN NUMBER,
4218: p_budget_version_id IN NUMBER)
4219: IS
4220: SELECT resource_assignment_id, wbs_element_version_id
4221: FROM pa_resource_assignments ra, pa_copy_asgmts_temp cat
4222: WHERE ra.wbs_element_version_id = cat.src_elem_ver_id
4223: AND ra.project_id = p_project_id
4224: AND ra.budget_version_id = p_budget_version_id
4225: AND ra.ta_display_flag = 'N';

Line 6116: * 1. Insert the task version ids into an existing temp table, PA_COPY_ASGMTS_TEMP

6112: --Changes for Bug 3910882 Begin
6113: /* Updates from the Bug
6114: The UPDATE does not perform very well in volume env. My suggestion to improve
6115: this is to replace the FORALL UPDATE by 2 operations:
6116: * 1. Insert the task version ids into an existing temp table, PA_COPY_ASGMTS_TEMP
6117: * 2. Select resource assignments from pa_resource_assignments joining to the temp table
6118: */
6119:
6120: -- dynamically computing the statistics for the Temporary table

Line 6132: pa_task_assignment_utils.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP',

6128: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
6129:
6130: -- Manually seed the statistics for the temporary table.
6131: -- Bug 8261905, Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
6132: pa_task_assignment_utils.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP',
6133: l_num_of_tasks, l_num_blocks, 75);
6134:
6135: -- delete content from temp table before inserting
6136: DELETE pa_copy_asgmts_temp;

Line 6136: DELETE pa_copy_asgmts_temp;

6132: pa_task_assignment_utils.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP',
6133: l_num_of_tasks, l_num_blocks, 75);
6134:
6135: -- delete content from temp table before inserting
6136: DELETE pa_copy_asgmts_temp;
6137:
6138: -- bulk inserting the task version ids into the temp table
6139: FORALL i IN 1..l_task_elem_version_id_tbl.COUNT
6140: -- Changed due to bug 4153366

Line 6141: INSERT INTO pa_copy_asgmts_temp VALUES

6137:
6138: -- bulk inserting the task version ids into the temp table
6139: FORALL i IN 1..l_task_elem_version_id_tbl.COUNT
6140: -- Changed due to bug 4153366
6141: INSERT INTO pa_copy_asgmts_temp VALUES
6142: (l_task_elem_version_id_tbl(i), -1, null, null, null, null);
6143:
6144: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
6145: pa_debug.g_err_stage:='Successfully inserted task version ids into the temp table';