116: l_commit_unit_number number;
117: l_legislation_code varchar2(30);
118: begin
119: hr_utility.set_location('Entering: PSP_EFF_REPORT_APPROVALS_BK2.UPDATE_EFF_REPORT_APPROVALS_B', 10);
120: l_commit_unit_number := hr_api.return_commit_unit;
121: if hr_api.call_app_hooks then
122: PSP_ERA_EXT.UPDATE_EFF_REPORT_APPROVAL_EXT
123: (P_EFFORT_REPORT_APPROVAL_ID => P_EFFORT_REPORT_APPROVAL_ID
124: ,P_EFFORT_REPORT_DETAIL_ID => P_EFFORT_REPORT_DETAIL_ID
117: l_legislation_code varchar2(30);
118: begin
119: hr_utility.set_location('Entering: PSP_EFF_REPORT_APPROVALS_BK2.UPDATE_EFF_REPORT_APPROVALS_B', 10);
120: l_commit_unit_number := hr_api.return_commit_unit;
121: if hr_api.call_app_hooks then
122: PSP_ERA_EXT.UPDATE_EFF_REPORT_APPROVAL_EXT
123: (P_EFFORT_REPORT_APPROVAL_ID => P_EFFORT_REPORT_APPROVAL_ID
124: ,P_EFFORT_REPORT_DETAIL_ID => P_EFFORT_REPORT_DETAIL_ID
125: ,P_WF_ROLE_NAME => P_WF_ROLE_NAME
172: ,P_EFF_INFORMATION15 => P_EFF_INFORMATION15
173: ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
174: );
175: end if;
176: hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EFF_REPORT_APPROVALS', 'BP');
177: hr_utility.set_location(' Leaving: PSP_EFF_REPORT_APPROVALS_BK2.UPDATE_EFF_REPORT_APPROVALS_B', 20);
178: end UPDATE_EFF_REPORT_APPROVALS_B;
179: end PSP_EFF_REPORT_APPROVALS_BK2;