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 1535: FROM pa_resource_assignments ra, pa_copy_asgmts_temp cat

1531: CURSOR C_Get_Default_Res_Asgmt(p_project_id IN NUMBER,
1532: p_budget_version_id IN NUMBER)
1533: IS
1534: SELECT resource_assignment_id, wbs_element_version_id
1535: FROM pa_resource_assignments ra, pa_copy_asgmts_temp cat
1536: WHERE ra.wbs_element_version_id = cat.src_elem_ver_id
1537: AND ra.project_id = p_project_id
1538: AND ra.budget_version_id = p_budget_version_id
1539: AND ra.ta_display_flag = 'N';

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

2476: --Changes for Bug 3910882 Begin
2477: /* Updates from the Bug
2478: The UPDATE does not perform very well in volume env. My suggestion to improve
2479: this is to replace the FORALL UPDATE by 2 operations:
2480: * 1. Insert the task version ids into an existing temp table, PA_COPY_ASGMTS_TEMP
2481: * 2. Select resource assignments from pa_resource_assignments joining to the temp table
2482: */
2483:
2484: -- dynamically computing the statistics for the Temporary table

Line 2495: pa_task_assignment_utils.set_table_stats('PA','PA_COPY_ASGMTS_TEMP',

2491:
2492: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
2493:
2494: -- Manually seed the statistics for the temporary table.
2495: pa_task_assignment_utils.set_table_stats('PA','PA_COPY_ASGMTS_TEMP',
2496: l_num_of_tasks, l_num_blocks, 75);
2497:
2498: -- delete content from temp table before inserting
2499: DELETE pa_copy_asgmts_temp;

Line 2499: DELETE pa_copy_asgmts_temp;

2495: pa_task_assignment_utils.set_table_stats('PA','PA_COPY_ASGMTS_TEMP',
2496: l_num_of_tasks, l_num_blocks, 75);
2497:
2498: -- delete content from temp table before inserting
2499: DELETE pa_copy_asgmts_temp;
2500:
2501: -- bulk inserting the task version ids into the temp table
2502: -- Changed due to bug 4153366
2503: FORALL i IN 1..l_task_elem_version_id_tbl.COUNT

Line 2504: INSERT INTO pa_copy_asgmts_temp VALUES

2500:
2501: -- bulk inserting the task version ids into the temp table
2502: -- Changed due to bug 4153366
2503: FORALL i IN 1..l_task_elem_version_id_tbl.COUNT
2504: INSERT INTO pa_copy_asgmts_temp VALUES
2505: (l_task_elem_version_id_tbl(i), -1, null, null, null, null);
2506:
2507: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2508: pa_debug.g_err_stage:='Successfully inserted task version ids into the temp table';

Line 3943: FROM pa_resource_assignments ra, pa_copy_asgmts_temp cat

3939: CURSOR C_Get_Default_Res_Asgmt(p_project_id IN NUMBER,
3940: p_budget_version_id IN NUMBER)
3941: IS
3942: SELECT resource_assignment_id, wbs_element_version_id
3943: FROM pa_resource_assignments ra, pa_copy_asgmts_temp cat
3944: WHERE ra.wbs_element_version_id = cat.src_elem_ver_id
3945: AND ra.project_id = p_project_id
3946: AND ra.budget_version_id = p_budget_version_id
3947: AND ra.ta_display_flag = 'N';

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

5464: --Changes for Bug 3910882 Begin
5465: /* Updates from the Bug
5466: The UPDATE does not perform very well in volume env. My suggestion to improve
5467: this is to replace the FORALL UPDATE by 2 operations:
5468: * 1. Insert the task version ids into an existing temp table, PA_COPY_ASGMTS_TEMP
5469: * 2. Select resource assignments from pa_resource_assignments joining to the temp table
5470: */
5471:
5472: -- dynamically computing the statistics for the Temporary table

Line 5483: pa_task_assignment_utils.set_table_stats('PA','PA_COPY_ASGMTS_TEMP',

5479:
5480: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
5481:
5482: -- Manually seed the statistics for the temporary table.
5483: pa_task_assignment_utils.set_table_stats('PA','PA_COPY_ASGMTS_TEMP',
5484: l_num_of_tasks, l_num_blocks, 75);
5485:
5486: -- delete content from temp table before inserting
5487: DELETE pa_copy_asgmts_temp;

Line 5487: DELETE pa_copy_asgmts_temp;

5483: pa_task_assignment_utils.set_table_stats('PA','PA_COPY_ASGMTS_TEMP',
5484: l_num_of_tasks, l_num_blocks, 75);
5485:
5486: -- delete content from temp table before inserting
5487: DELETE pa_copy_asgmts_temp;
5488:
5489: -- bulk inserting the task version ids into the temp table
5490: FORALL i IN 1..l_task_elem_version_id_tbl.COUNT
5491: -- Changed due to bug 4153366

Line 5492: INSERT INTO pa_copy_asgmts_temp VALUES

5488:
5489: -- bulk inserting the task version ids into the temp table
5490: FORALL i IN 1..l_task_elem_version_id_tbl.COUNT
5491: -- Changed due to bug 4153366
5492: INSERT INTO pa_copy_asgmts_temp VALUES
5493: (l_task_elem_version_id_tbl(i), -1, null, null, null, null);
5494:
5495: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5496: pa_debug.g_err_stage:='Successfully inserted task version ids into the temp table';