63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_pyp_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_pay_proposals Row
68: --
69: update per_pay_proposals
70: set
71: pay_proposal_id = p_rec.pay_proposal_id,
65: per_pyp_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_pay_proposals Row
68: --
69: update per_pay_proposals
70: set
71: pay_proposal_id = p_rec.pay_proposal_id,
72: event_id = null,
73: change_date = p_rec.change_date,
330: l_old_rec.approved = 'N' and p_rec.approved = 'Y' and
331: l_old_rec.change_date = p_rec.change_date)
332: then
333: begin
334: select proposed_salary_n into l_old_salary from per_pay_proposals
335: where assignment_id = p_rec.ASSIGNMENT_ID and
336: change_date = (select max(change_date) from per_pay_proposals where
337: change_date < p_rec.change_date and assignment_id = p_rec.ASSIGNMENT_ID );
338: l_ext_old_rec.PROPOSED_SALARY_N := l_old_salary;
332: then
333: begin
334: select proposed_salary_n into l_old_salary from per_pay_proposals
335: where assignment_id = p_rec.ASSIGNMENT_ID and
336: change_date = (select max(change_date) from per_pay_proposals where
337: change_date < p_rec.change_date and assignment_id = p_rec.ASSIGNMENT_ID );
338: l_ext_old_rec.PROPOSED_SALARY_N := l_old_salary;
339: exception
340: when no_data_found
523:
524: exception
525: when hr_api.cannot_find_prog_unit then
526: hr_api.cannot_find_prog_unit_error
527: (p_module_name => 'PER_PAY_PROPOSALS'
528: ,p_hook_type => 'AU'
529: );
530: end;
531: -- End of API User Hook for post_update.