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 12034: /* Assumptions: When resource list changes for published version, pa_progress_rollup would have only task level PEOPLE assignments.

12030: for understanding purpose */
12031: AND resource_class_code = 'PEOPLE'
12032: AND resource_class_flag = 'Y'
12033: AND ta_display_flag = 'N';
12034: /* Assumptions: When resource list changes for published version, pa_progress_rollup would have only task level PEOPLE assignments.
12035: Hence we are updating all records in pa_progress_rollup with the new rlmid petaining to people class rlm for published versions. */
12036: UPDATE pa_progress_rollup
12037: SET object_id = l_people_res_class_rlm_id
12038: WHERE project_id = p_project_id AND

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

12031: AND resource_class_code = 'PEOPLE'
12032: AND resource_class_flag = 'Y'
12033: AND ta_display_flag = 'N';
12034: /* Assumptions: When resource list changes for published version, pa_progress_rollup would have only task level PEOPLE assignments.
12035: Hence we are updating all records in pa_progress_rollup with the new rlmid petaining to people class rlm for published versions. */
12036: UPDATE pa_progress_rollup
12037: SET object_id = l_people_res_class_rlm_id
12038: WHERE project_id = p_project_id AND
12039: object_type = 'PA_ASSIGNMENTS' AND

Line 12036: UPDATE pa_progress_rollup

12032: AND resource_class_flag = 'Y'
12033: AND ta_display_flag = 'N';
12034: /* Assumptions: When resource list changes for published version, pa_progress_rollup would have only task level PEOPLE assignments.
12035: Hence we are updating all records in pa_progress_rollup with the new rlmid petaining to people class rlm for published versions. */
12036: UPDATE pa_progress_rollup
12037: SET object_id = l_people_res_class_rlm_id
12038: WHERE project_id = p_project_id AND
12039: object_type = 'PA_ASSIGNMENTS' AND
12040: structure_type = 'WORKPLAN' AND

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

12038: WHERE project_id = p_project_id AND
12039: object_type = 'PA_ASSIGNMENTS' AND
12040: structure_type = 'WORKPLAN' AND
12041: structure_Version_id is NULL; /* Only published versions */
12042: /* Note that we are not updating working wp versions pa_progress_rollup since there is some
12043: processing done for working wp versions in the loop below (delete planning transactions etc
12044: and we want to ensure this update is done after the processing */
12045:
12046: /* We also need to update the resource list id in the pa_budget_versions table as well as the

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

12232: WHERE budget_version_id = l_budget_version_id_tbl(i)
12233: AND resource_class_code = 'PEOPLE'
12234: AND resource_class_flag = 'Y';
12235:
12236: /* Assumptions: When resource list changes for working version, pa_progress_rollup would have
12237: only task level PEOPLE assignments at this point as ta_display_flag = Y records
12238: would have got deleted above.Hence we are updating all records in pa_progress_rollup
12239: with the new rlmid petaining to people class rlm for working versions. */
12240: UPDATE pa_progress_rollup

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

12234: AND resource_class_flag = 'Y';
12235:
12236: /* Assumptions: When resource list changes for working version, pa_progress_rollup would have
12237: only task level PEOPLE assignments at this point as ta_display_flag = Y records
12238: would have got deleted above.Hence we are updating all records in pa_progress_rollup
12239: with the new rlmid petaining to people class rlm for working versions. */
12240: UPDATE pa_progress_rollup
12241: SET object_id = l_people_res_class_rlm_id
12242: WHERE project_id = p_project_id AND

Line 12240: UPDATE pa_progress_rollup

12236: /* Assumptions: When resource list changes for working version, pa_progress_rollup would have
12237: only task level PEOPLE assignments at this point as ta_display_flag = Y records
12238: would have got deleted above.Hence we are updating all records in pa_progress_rollup
12239: with the new rlmid petaining to people class rlm for working versions. */
12240: UPDATE pa_progress_rollup
12241: SET object_id = l_people_res_class_rlm_id
12242: WHERE project_id = p_project_id AND
12243: object_type = 'PA_ASSIGNMENTS' AND
12244: structure_type = 'WORKPLAN' AND