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

Line 478: INSERT INTO pa_copy_asgmts_temp

474:
475: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
476: to remove the GSCC Warning File.Sql.33 */
477:
478: INSERT INTO pa_copy_asgmts_temp
479: (
480: SRC_ELEM_VER_ID,
481: TARG_ELEM_VER_ID,
482: OLD_TASK_SCH_START,

Line 501: FROM pa_copy_asgmts_temp;

497: IF p_context = 'UPDATE' OR p_context = 'COPY' THEN
498:
499: SELECT count(SRC_ELEM_VER_ID)
500: INTO l_num_of_tasks
501: FROM pa_copy_asgmts_temp;
502:
503: IF l_num_of_tasks > 0 THEN
504:
505: x_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE() ;

Line 529: set_table_stats('PA','PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);

525:
526: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
527:
528: -- Manually seed the statistics for the temporary table.
529: set_table_stats('PA','PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);
530:
531: --Get all task assignments in the given task with '
532: --Assignment same as Task Duration' flag checked
533: --Bug 4153366: Select task versions from temp table.

Line 538: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks

534: SELECT ra.resource_assignment_id, ra.total_plan_quantity,
535: tasks.src_elem_ver_id, tasks.new_task_sch_start, tasks.new_task_sch_end
536: BULK COLLECT INTO l_use_task_sch_asgmt_tbl, l_use_task_quantity_tbl,
537: l_use_task_task_ver_tbl, l_use_task_new_sch_start, l_use_task_new_sch_end --Bug 4153366
538: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks
539: WHERE ra.use_task_schedule_flag = 'Y'
540: AND ra.ta_display_flag is not null
541: AND ra.budget_version_id = l_budget_ver_id -- Bug 4229020
542: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;

Line 569: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks

565: tasks.src_elem_ver_id
566: BULK COLLECT INTO
567: l_adj_dates_asgmt_tbl, l_adj_task_quantity_tbl, l_delay_tbl, l_duration_tbl,
568: l_new_start_tbl, l_new_end_tbl, l_finish_flg_tbl, l_new_task_sch_start, l_new_task_sch_finish, l_adj_task_task_ver_tbl
569: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks
570: WHERE nvl(ra.use_task_schedule_flag, 'N') <> 'Y'
571: AND ra.ta_display_flag is not null
572: AND ra.budget_version_id = l_budget_ver_id
573: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;

Line 687: DELETE pa_copy_asgmts_temp;

683: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
684: END IF;
685:
686: -- Bug 4153366 - clear the temp table
687: DELETE pa_copy_asgmts_temp;
688:
689: ELSIF p_context = 'COPY' THEN
690:
691: x_res_assignment_id_tbl := l_resource_assignment_id_tbl ;

Line 697: DELETE pa_copy_asgmts_temp;

693: x_planning_end_tbl := l_schedule_end_date_tbl ;
694:
695: -- Bug 4153366 - clear the temp table
696: -- Bug 4164909 - Should also empty the temp table upon copy
697: DELETE pa_copy_asgmts_temp;
698:
699: END IF; -- p_context
700:
701: END IF; -- IF (l_use_task_sch_asgmt_tbl is not null...

Line 732: DELETE pa_copy_asgmts_temp;

728: x_planning_start_tbl := NULL ;
729: x_planning_end_tbl := NULL ;
730: -- 4537865
731: -- Bug 4153366 - clear the temp table
732: DELETE pa_copy_asgmts_temp;
733:
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
736: PA_DEBUG.write_log (x_module => L_Module,

Line 749: DELETE pa_copy_asgmts_temp;

745: x_planning_start_tbl := NULL ;
746: x_planning_end_tbl := NULL ;
747: -- 4537865
748: -- Bug 4153366 - clear the temp table
749: DELETE pa_copy_asgmts_temp;
750:
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
753: PA_DEBUG.write_log (x_module => L_Module,

Line 2909: pa_copy_asgmts_temp temp,

2905: ra.bom_resource_id,
2906: ra.non_labor_resource,
2907: ra.inventory_item_id
2908: FROM
2909: pa_copy_asgmts_temp temp,
2910: pa_proj_element_versions pev,
2911: pa_resource_assignments ra,
2912: pa_project_assignments asgn,
2913: pa_budget_lines bl,

Line 3002: pa_copy_asgmts_temp temp,

2998: ra.bom_resource_id,
2999: ra.non_labor_resource,
3000: ra.inventory_item_id
3001: FROM
3002: pa_copy_asgmts_temp temp,
3003: pa_proj_element_versions pev,
3004: pa_resource_assignments ra,
3005: pa_project_assignments asgn,
3006: pa_resource_list_members rlm,

Line 3065: pa_copy_asgmts_temp temp,

3061: ra.bom_resource_id,
3062: ra.non_labor_resource,
3063: ra.inventory_item_id
3064: FROM
3065: pa_copy_asgmts_temp temp,
3066: pa_proj_element_versions pev,
3067: pa_resource_assignments ra,
3068: pa_project_assignments asgn,
3069: pa_budget_lines bl,

Line 3165: pa_copy_asgmts_temp temp,

3161: ra.bom_resource_id,
3162: ra.non_labor_resource,
3163: ra.inventory_item_id
3164: FROM
3165: pa_copy_asgmts_temp temp,
3166: pa_proj_element_versions pev,
3167: pa_resource_assignments ra,
3168: pa_project_assignments asgn,
3169: pa_resource_list_members source_rlm,

Line 3196: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs

3192: l_num_blocks NUMBER;
3193:
3194: CURSOR c_get_src_sched_dates IS
3195: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3196: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3197: WHERE pev.element_version_id = pevs.element_version_id
3198: AND pev.element_version_id = temp.src_elem_ver_id;
3199:
3200: CURSOR c_get_targ_sched_dates IS

Line 3202: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs

3198: AND pev.element_version_id = temp.src_elem_ver_id;
3199:
3200: CURSOR c_get_targ_sched_dates IS
3201: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3202: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3203: WHERE pev.element_version_id = pevs.element_version_id
3204: AND pev.element_version_id = temp.targ_elem_ver_id;
3205:
3206: CURSOR get_rl_proj_specific_flag(c_resource_list_id NUMBER) IS

Line 3417: set_table_stats('PA','PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);

3413:
3414: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
3415:
3416: -- Manually seed the statistics for the temporary table.
3417: set_table_stats('PA','PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);
3418:
3419: DELETE pa_copy_asgmts_temp;
3420: FORALL i IN 1..p_src_elem_ver_id_tbl.COUNT
3421:

Line 3419: DELETE pa_copy_asgmts_temp;

3415:
3416: -- Manually seed the statistics for the temporary table.
3417: set_table_stats('PA','PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);
3418:
3419: DELETE pa_copy_asgmts_temp;
3420: FORALL i IN 1..p_src_elem_ver_id_tbl.COUNT
3421:
3422: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
3423: to remove the GSCC Warning File.Sql.33 */

Line 3425: INSERT INTO pa_copy_asgmts_temp

3421:
3422: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
3423: to remove the GSCC Warning File.Sql.33 */
3424: -- Changed due to bug 4153366
3425: INSERT INTO pa_copy_asgmts_temp
3426: (
3427: SRC_ELEM_VER_ID,
3428: TARG_ELEM_VER_ID,
3429: OLD_TASK_SCH_START,

Line 4315: DELETE pa_copy_asgmts_temp;

4311:
4312:
4313: -- Clear pa_copy_asgmt_temp before calling Adjust_Asgmt_Dates
4314: -- since this temp table is also being used.
4315: DELETE pa_copy_asgmts_temp;
4316:
4317: Adjust_Asgmt_Dates(
4318: p_context => 'COPY',
4319: p_element_version_id => p_src_elem_ver_id_tbl(k),

Line 4602: DELETE pa_copy_asgmts_temp;

4598:
4599: -- should clear this temporary table after being used since the table will be
4600: -- reused in adjust_asgmt_date right away in the same session in publishing flow.
4601: -- Otherwise, publishing flow may error out.
4602: DELETE pa_copy_asgmts_temp;
4603:
4604: EXCEPTION
4605:
4606: WHEN FND_API.G_EXC_ERROR THEN

Line 4608: DELETE pa_copy_asgmts_temp;

4604: EXCEPTION
4605:
4606: WHEN FND_API.G_EXC_ERROR THEN
4607: x_return_status := FND_API.G_RET_STS_ERROR;
4608: DELETE pa_copy_asgmts_temp;
4609: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
4610: PA_DEBUG.write_log (x_module => L_Module,
4611: x_msg => 'Error:' || L_FuncProc || SQLERRM,
4612: x_log_level => 5);

Line 4617: DELETE pa_copy_asgmts_temp;

4613: END IF;
4614:
4615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4617: DELETE pa_copy_asgmts_temp;
4618: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
4619: PA_DEBUG.write_log (x_module => L_Module,
4620: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,
4621: x_log_level => 6);

Line 4627: DELETE pa_copy_asgmts_temp;

4623: RAISE;
4624:
4625: WHEN OTHERS THEN
4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4627: DELETE pa_copy_asgmts_temp;
4628: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
4629: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
4630: PA_DEBUG.write_log (x_module => L_Module,
4631: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,