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_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROGRESS_ROLLUP

Line 12921: /* Assumptions: When resource list changes for published version, pa_progress_rollup would have only task level PEOPLE assignments.

12917: for understanding purpose */
12918: AND resource_class_code = 'PEOPLE'
12919: AND resource_class_flag = 'Y'
12920: AND ta_display_flag = 'N';
12921: /* Assumptions: When resource list changes for published version, pa_progress_rollup would have only task level PEOPLE assignments.
12922: Hence we are updating all records in pa_progress_rollup with the new rlmid petaining to people class rlm for published versions. */
12923: UPDATE pa_progress_rollup
12924: SET object_id = l_people_res_class_rlm_id
12925: WHERE project_id = p_project_id AND

Line 12922: Hence we are updating all records in pa_progress_rollup with the new rlmid petaining to people class rlm for published versions. */

12918: AND resource_class_code = 'PEOPLE'
12919: AND resource_class_flag = 'Y'
12920: AND ta_display_flag = 'N';
12921: /* Assumptions: When resource list changes for published version, pa_progress_rollup would have only task level PEOPLE assignments.
12922: Hence we are updating all records in pa_progress_rollup with the new rlmid petaining to people class rlm for published versions. */
12923: UPDATE pa_progress_rollup
12924: SET object_id = l_people_res_class_rlm_id
12925: WHERE project_id = p_project_id AND
12926: object_type = 'PA_ASSIGNMENTS' AND

Line 12923: UPDATE pa_progress_rollup

12919: AND resource_class_flag = 'Y'
12920: AND ta_display_flag = 'N';
12921: /* Assumptions: When resource list changes for published version, pa_progress_rollup would have only task level PEOPLE assignments.
12922: Hence we are updating all records in pa_progress_rollup with the new rlmid petaining to people class rlm for published versions. */
12923: UPDATE pa_progress_rollup
12924: SET object_id = l_people_res_class_rlm_id
12925: WHERE project_id = p_project_id AND
12926: object_type = 'PA_ASSIGNMENTS' AND
12927: structure_type = 'WORKPLAN' AND

Line 12929: /* Note that we are not updating working wp versions pa_progress_rollup since there is some

12925: WHERE project_id = p_project_id AND
12926: object_type = 'PA_ASSIGNMENTS' AND
12927: structure_type = 'WORKPLAN' AND
12928: structure_Version_id is NULL; /* Only published versions */
12929: /* Note that we are not updating working wp versions pa_progress_rollup since there is some
12930: processing done for working wp versions in the loop below (delete planning transactions etc
12931: and we want to ensure this update is done after the processing */
12932:
12933: /* We also need to update the resource list id in the pa_budget_versions table as well as the

Line 13137: /* Assumptions: When resource list changes for working version, pa_progress_rollup would have

13133: WHERE budget_version_id = l_budget_version_id_tbl(i)
13134: AND resource_class_code = 'PEOPLE'
13135: AND resource_class_flag = 'Y';
13136:
13137: /* Assumptions: When resource list changes for working version, pa_progress_rollup would have
13138: only task level PEOPLE assignments at this point as ta_display_flag = Y records
13139: would have got deleted above.Hence we are updating all records in pa_progress_rollup
13140: with the new rlmid petaining to people class rlm for working versions. */
13141: UPDATE pa_progress_rollup

Line 13139: would have got deleted above.Hence we are updating all records in pa_progress_rollup

13135: AND resource_class_flag = 'Y';
13136:
13137: /* Assumptions: When resource list changes for working version, pa_progress_rollup would have
13138: only task level PEOPLE assignments at this point as ta_display_flag = Y records
13139: would have got deleted above.Hence we are updating all records in pa_progress_rollup
13140: with the new rlmid petaining to people class rlm for working versions. */
13141: UPDATE pa_progress_rollup
13142: SET object_id = l_people_res_class_rlm_id
13143: WHERE project_id = p_project_id AND

Line 13141: UPDATE pa_progress_rollup

13137: /* Assumptions: When resource list changes for working version, pa_progress_rollup would have
13138: only task level PEOPLE assignments at this point as ta_display_flag = Y records
13139: would have got deleted above.Hence we are updating all records in pa_progress_rollup
13140: with the new rlmid petaining to people class rlm for working versions. */
13141: UPDATE pa_progress_rollup
13142: SET object_id = l_people_res_class_rlm_id
13143: WHERE project_id = p_project_id AND
13144: object_type = 'PA_ASSIGNMENTS' AND
13145: structure_type = 'WORKPLAN' AND