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 10287: pa_res_asgmts_temp rat,

10283: rat.schedule_start_date,
10284: rat.schedule_end_date,
10285: decode(pr.structure_version_id, NULL, 'Y', 'N')
10286: FROM
10287: pa_res_asgmts_temp rat,
10288: pa_resource_assignments ra,
10289: pa_proj_element_versions pev,
10290: pa_progress_rollup pr
10291: WHERE

Line 10362: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);

10358:
10359: -- Manually seed the statistics for the temporary table.
10360: -- Need to do it before populating the table otherwise the table will be emptied.
10361: -- Bug 8261905 : Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
10362: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);
10363:
10364: -- Populate the temporary table with the parameters passed in.
10365: DELETE pa_res_asgmts_temp;
10366: FORALL j IN 1..p_task_assignment_tbl.COUNT

Line 10365: DELETE pa_res_asgmts_temp;

10361: -- Bug 8261905 : Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
10362: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);
10363:
10364: -- Populate the temporary table with the parameters passed in.
10365: DELETE pa_res_asgmts_temp;
10366: FORALL j IN 1..p_task_assignment_tbl.COUNT
10367: INSERT INTO pa_res_asgmts_temp VALUES
10368: (l_res_asgmt_id_tbl(j), l_new_rlm_id_tbl(j), l_override_cur_tbl(j), l_new_project_role_id_tbl(j),
10369: l_new_total_qty_tbl(j), l_new_sched_start_date_tbl(j), l_new_sched_finish_date_tbl(j));

Line 10367: INSERT INTO pa_res_asgmts_temp VALUES

10363:
10364: -- Populate the temporary table with the parameters passed in.
10365: DELETE pa_res_asgmts_temp;
10366: FORALL j IN 1..p_task_assignment_tbl.COUNT
10367: INSERT INTO pa_res_asgmts_temp VALUES
10368: (l_res_asgmt_id_tbl(j), l_new_rlm_id_tbl(j), l_override_cur_tbl(j), l_new_project_role_id_tbl(j),
10369: l_new_total_qty_tbl(j), l_new_sched_start_date_tbl(j), l_new_sched_finish_date_tbl(j));
10370:
10371: -- Initialize the arrays.