[Home] [Help]
9297: --Create records in percent completes and rollup table for new assignment.
9298:
9299:
9300: -- Added update code to set current_flag as N otherwise upon publishinh it will give error
9301: -- ORA-00001: unique constraint (PA.PA_BUDGET_LINES_U1) violated in Package PA_FP_MAINTAIN_ACTUAL_PUB Procedure MAINTAIN_ACTUAL_AMT_RA
9302: -- Patched thru Bug 4183307
9303: IF p_action = 'PUBLISH' THEN
9304: UPDATE pa_percent_completes
9305: SET current_flag = 'N'
9781: ,source.resource_list_member_id RESOURCE_LIST_MEMBER_ID
9782: ,source.cbs_element_id CBS_ELEMENT_ID
9783: FROM pa_resource_assignments source,
9784: pa_resource_assignments target,
9785: pa_budget_lines bl
9786: WHERE bl.resource_assignment_id = source.resource_assignment_id
9787: and source.budget_version_id = c_budget_version_id
9788: and target.budget_version_id = t_budget_version_id
9789: and target.resource_list_member_id = decode(l_res_list_mismatch_flag, 'N', source.resource_list_member_id, l_target_people_rlm_id)
9909:
9910: -- Delete any existing records from the table first
9911: DELETE FROM PA_PROG_ACT_BY_PERIOD_TEMP;
9912:
9913: -- Populate the PA_PROG_ACT_BY_PERIOD_TEMP table from pa_budget_lines init columns data
9914: -- Using task_id and resource list member id fetch mapping target resource assignment id
9915:
9916: /* Begin code to fix Bug # 4144300. */
9917:
10065: ,NULL ATTRIBUTE4
10066: ,NULL ATTRIBUTE5
10067: ,NULL ATTRIBUTE6
10068: FROM pa_resource_assignments source,
10069: pa_budget_lines bl,
10070: pa_resource_assignments target
10071: WHERE bl.budget_version_id = l_source_str_ver_info_rec.budget_version_id
10072: and bl.resource_assignment_id = source.resource_assignment_id
10073: AND target.budget_version_id = l_target_str_ver_info_rec.budget_version_id