[Home] [Help]
9231: --Create records in percent completes and rollup table for new assignment.
9232:
9233:
9234: -- Added update code to set current_flag as N otherwise upon publishinh it will give error
9235: -- ORA-00001: unique constraint (PA.PA_BUDGET_LINES_U1) violated in Package PA_FP_MAINTAIN_ACTUAL_PUB Procedure MAINTAIN_ACTUAL_AMT_RA
9236: -- Patched thru Bug 4183307
9237: IF p_action = 'PUBLISH' THEN
9238: UPDATE pa_percent_completes
9239: SET current_flag = 'N'
9714: ,bl.end_date END_DATE
9715: ,source.resource_list_member_id RESOURCE_LIST_MEMBER_ID
9716: FROM pa_resource_assignments source,
9717: pa_resource_assignments target,
9718: pa_budget_lines bl
9719: WHERE bl.resource_assignment_id = source.resource_assignment_id
9720: and source.budget_version_id = c_budget_version_id
9721: and target.budget_version_id = t_budget_version_id
9722: and target.resource_list_member_id = decode(l_res_list_mismatch_flag, 'N', source.resource_list_member_id, l_target_people_rlm_id)
9841:
9842: -- Delete any existing records from the table first
9843: DELETE FROM PA_PROG_ACT_BY_PERIOD_TEMP;
9844:
9845: -- Populate the PA_PROG_ACT_BY_PERIOD_TEMP table from pa_budget_lines init columns data
9846: -- Using task_id and resource list member id fetch mapping target resource assignment id
9847:
9848: /* Begin code to fix Bug # 4144300. */
9849:
9997: ,NULL ATTRIBUTE4
9998: ,NULL ATTRIBUTE5
9999: ,NULL ATTRIBUTE6
10000: FROM pa_resource_assignments source,
10001: pa_budget_lines bl,
10002: pa_resource_assignments target
10003: WHERE bl.budget_version_id = l_source_str_ver_info_rec.budget_version_id
10004: and bl.resource_assignment_id = source.resource_assignment_id
10005: AND target.budget_version_id = l_target_str_ver_info_rec.budget_version_id