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_PROGRESS_UTILS dependencies on PA_RES_ASGMTS_TEMP

Line 10213: pa_res_asgmts_temp rat,

10209: rat.schedule_start_date,
10210: rat.schedule_end_date,
10211: decode(pr.structure_version_id, NULL, 'Y', 'N')
10212: FROM
10213: pa_res_asgmts_temp rat,
10214: pa_resource_assignments ra,
10215: pa_proj_element_versions pev,
10216: pa_progress_rollup pr
10217: WHERE

Line 10287: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);

10283: END LOOP;
10284:
10285: -- Manually seed the statistics for the temporary table.
10286: -- Need to do it before populating the table otherwise the table will be emptied.
10287: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);
10288:
10289: -- Populate the temporary table with the parameters passed in.
10290: DELETE pa_res_asgmts_temp;
10291: FORALL j IN 1..p_task_assignment_tbl.COUNT

Line 10290: DELETE pa_res_asgmts_temp;

10286: -- Need to do it before populating the table otherwise the table will be emptied.
10287: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);
10288:
10289: -- Populate the temporary table with the parameters passed in.
10290: DELETE pa_res_asgmts_temp;
10291: FORALL j IN 1..p_task_assignment_tbl.COUNT
10292: INSERT INTO pa_res_asgmts_temp VALUES
10293: (l_res_asgmt_id_tbl(j), l_new_rlm_id_tbl(j), l_override_cur_tbl(j), l_new_project_role_id_tbl(j),
10294: l_new_total_qty_tbl(j), l_new_sched_start_date_tbl(j), l_new_sched_finish_date_tbl(j));

Line 10292: INSERT INTO pa_res_asgmts_temp VALUES

10288:
10289: -- Populate the temporary table with the parameters passed in.
10290: DELETE pa_res_asgmts_temp;
10291: FORALL j IN 1..p_task_assignment_tbl.COUNT
10292: INSERT INTO pa_res_asgmts_temp VALUES
10293: (l_res_asgmt_id_tbl(j), l_new_rlm_id_tbl(j), l_override_cur_tbl(j), l_new_project_role_id_tbl(j),
10294: l_new_total_qty_tbl(j), l_new_sched_start_date_tbl(j), l_new_sched_finish_date_tbl(j));
10295:
10296: -- Initialize the arrays.