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 543: INSERT INTO pa_copy_asgmts_temp

539:
540: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
541: to remove the GSCC Warning File.Sql.33 */
542:
543: INSERT INTO pa_copy_asgmts_temp
544: (
545: SRC_ELEM_VER_ID,
546: TARG_ELEM_VER_ID,
547: OLD_TASK_SCH_START,

Line 566: FROM pa_copy_asgmts_temp;

562: IF p_context = 'UPDATE' OR p_context = 'COPY' THEN
563:
564: SELECT count(SRC_ELEM_VER_ID)
565: INTO l_num_of_tasks
566: FROM pa_copy_asgmts_temp;
567:
568: IF l_num_of_tasks > 0 THEN
569:
570: x_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE() ;

Line 595: set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);

591: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
592:
593: -- Manually seed the statistics for the temporary table.
594: -- Bug 8261905, Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
595: set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);
596:
597: --Get all task assignments in the given task with '
598: --Assignment same as Task Duration' flag checked
599: --Bug 4153366: Select task versions from temp table.

Line 604: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks

600: SELECT ra.resource_assignment_id, ra.total_plan_quantity,
601: tasks.src_elem_ver_id, tasks.new_task_sch_start, tasks.new_task_sch_end
602: BULK COLLECT INTO l_use_task_sch_asgmt_tbl, l_use_task_quantity_tbl,
603: l_use_task_task_ver_tbl, l_use_task_new_sch_start, l_use_task_new_sch_end --Bug 4153366
604: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks
605: WHERE ra.use_task_schedule_flag = 'Y'
606: AND ra.ta_display_flag is not null
607: AND ra.budget_version_id = l_budget_ver_id -- Bug 4229020
608: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;

Line 635: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks

631: tasks.src_elem_ver_id
632: BULK COLLECT INTO
633: l_adj_dates_asgmt_tbl, l_adj_task_quantity_tbl, l_delay_tbl, l_duration_tbl,
634: 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
635: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks
636: WHERE nvl(ra.use_task_schedule_flag, 'N') <> 'Y'
637: AND ra.ta_display_flag is not null
638: AND ra.budget_version_id = l_budget_ver_id
639: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;

Line 753: DELETE pa_copy_asgmts_temp;

749: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
750: END IF;
751:
752: -- Bug 4153366 - clear the temp table
753: DELETE pa_copy_asgmts_temp;
754:
755: ELSIF p_context = 'COPY' THEN
756:
757: x_res_assignment_id_tbl := l_resource_assignment_id_tbl ;

Line 763: DELETE pa_copy_asgmts_temp;

759: x_planning_end_tbl := l_schedule_end_date_tbl ;
760:
761: -- Bug 4153366 - clear the temp table
762: -- Bug 4164909 - Should also empty the temp table upon copy
763: DELETE pa_copy_asgmts_temp;
764:
765: END IF; -- p_context
766:
767: END IF; -- IF (l_use_task_sch_asgmt_tbl is not null...

Line 798: DELETE pa_copy_asgmts_temp;

794: x_planning_start_tbl := NULL ;
795: x_planning_end_tbl := NULL ;
796: -- 4537865
797: -- Bug 4153366 - clear the temp table
798: DELETE pa_copy_asgmts_temp;
799:
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
802: PA_DEBUG.write_log (x_module => L_Module,

Line 815: DELETE pa_copy_asgmts_temp;

811: x_planning_start_tbl := NULL ;
812: x_planning_end_tbl := NULL ;
813: -- 4537865
814: -- Bug 4153366 - clear the temp table
815: DELETE pa_copy_asgmts_temp;
816:
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
819: PA_DEBUG.write_log (x_module => L_Module,

Line 3024: pa_copy_asgmts_temp temp,

3020: ra.bom_resource_id,
3021: ra.non_labor_resource,
3022: ra.inventory_item_id
3023: FROM
3024: pa_copy_asgmts_temp temp,
3025: pa_proj_element_versions pev,
3026: pa_resource_assignments ra,
3027: pa_project_assignments asgn,
3028: pa_budget_lines bl,

Line 3117: pa_copy_asgmts_temp temp,

3113: ra.bom_resource_id,
3114: ra.non_labor_resource,
3115: ra.inventory_item_id
3116: FROM
3117: pa_copy_asgmts_temp temp,
3118: pa_proj_element_versions pev,
3119: pa_resource_assignments ra,
3120: pa_project_assignments asgn,
3121: pa_resource_list_members rlm,

Line 3180: pa_copy_asgmts_temp temp,

3176: ra.bom_resource_id,
3177: ra.non_labor_resource,
3178: ra.inventory_item_id
3179: FROM
3180: pa_copy_asgmts_temp temp,
3181: pa_proj_element_versions pev,
3182: pa_resource_assignments ra,
3183: pa_project_assignments asgn,
3184: pa_budget_lines bl,

Line 3280: pa_copy_asgmts_temp temp,

3276: ra.bom_resource_id,
3277: ra.non_labor_resource,
3278: ra.inventory_item_id
3279: FROM
3280: pa_copy_asgmts_temp temp,
3281: pa_proj_element_versions pev,
3282: pa_resource_assignments ra,
3283: pa_project_assignments asgn,
3284: pa_resource_list_members source_rlm,

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

3307: l_num_blocks NUMBER;
3308:
3309: CURSOR c_get_src_sched_dates IS
3310: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3311: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3312: WHERE pev.element_version_id = pevs.element_version_id
3313: AND pev.element_version_id = temp.src_elem_ver_id;
3314:
3315: CURSOR c_get_targ_sched_dates IS

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

3313: AND pev.element_version_id = temp.src_elem_ver_id;
3314:
3315: CURSOR c_get_targ_sched_dates IS
3316: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3317: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3318: WHERE pev.element_version_id = pevs.element_version_id
3319: AND pev.element_version_id = temp.targ_elem_ver_id;
3320:
3321: CURSOR get_rl_proj_specific_flag(c_resource_list_id NUMBER) IS

Line 3533: set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);

3529: l_num_blocks := 1.25 * (l_num_of_tasks * 75) / l_db_block_size;
3530:
3531: -- Manually seed the statistics for the temporary table.
3532: -- Bug 8261905, Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
3533: set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);
3534:
3535: DELETE pa_copy_asgmts_temp;
3536: FORALL i IN 1..p_src_elem_ver_id_tbl.COUNT
3537:

Line 3535: DELETE pa_copy_asgmts_temp;

3531: -- Manually seed the statistics for the temporary table.
3532: -- Bug 8261905, Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
3533: set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_COPY_ASGMTS_TEMP', l_num_of_tasks, l_num_blocks, 75);
3534:
3535: DELETE pa_copy_asgmts_temp;
3536: FORALL i IN 1..p_src_elem_ver_id_tbl.COUNT
3537:
3538: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
3539: to remove the GSCC Warning File.Sql.33 */

Line 3541: INSERT INTO pa_copy_asgmts_temp

3537:
3538: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
3539: to remove the GSCC Warning File.Sql.33 */
3540: -- Changed due to bug 4153366
3541: INSERT INTO pa_copy_asgmts_temp
3542: (
3543: SRC_ELEM_VER_ID,
3544: TARG_ELEM_VER_ID,
3545: OLD_TASK_SCH_START,

Line 4431: DELETE pa_copy_asgmts_temp;

4427:
4428:
4429: -- Clear pa_copy_asgmt_temp before calling Adjust_Asgmt_Dates
4430: -- since this temp table is also being used.
4431: DELETE pa_copy_asgmts_temp;
4432:
4433: Adjust_Asgmt_Dates(
4434: p_context => 'COPY',
4435: p_element_version_id => p_src_elem_ver_id_tbl(k),

Line 4718: DELETE pa_copy_asgmts_temp;

4714:
4715: -- should clear this temporary table after being used since the table will be
4716: -- reused in adjust_asgmt_date right away in the same session in publishing flow.
4717: -- Otherwise, publishing flow may error out.
4718: DELETE pa_copy_asgmts_temp;
4719:
4720: EXCEPTION
4721:
4722: WHEN FND_API.G_EXC_ERROR THEN

Line 4724: DELETE pa_copy_asgmts_temp;

4720: EXCEPTION
4721:
4722: WHEN FND_API.G_EXC_ERROR THEN
4723: x_return_status := FND_API.G_RET_STS_ERROR;
4724: DELETE pa_copy_asgmts_temp;
4725: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
4726: PA_DEBUG.write_log (x_module => L_Module,
4727: x_msg => 'Error:' || L_FuncProc || SQLERRM,
4728: x_log_level => 5);

Line 4733: DELETE pa_copy_asgmts_temp;

4729: END IF;
4730:
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4733: DELETE pa_copy_asgmts_temp;
4734: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
4735: PA_DEBUG.write_log (x_module => L_Module,
4736: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,
4737: x_log_level => 6);

Line 4743: DELETE pa_copy_asgmts_temp;

4739: RAISE;
4740:
4741: WHEN OTHERS THEN
4742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4743: DELETE pa_copy_asgmts_temp;
4744: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
4745: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
4746: PA_DEBUG.write_log (x_module => L_Module,
4747: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,