DBA Data[Home] [Help]

APPS.PA_TASK_APPROVAL_PKG dependencies on PA_CONTROL_ITEMS

Line 231: UPDATE pa_control_items SET status_code = 'CI_SUBMITTED' WHERE ci_id = p_ci_id;

227: ,p_return_status OUT NOCOPY VARCHAR2) IS
228: BEGIN
229: log_message('Inside PA_TASK_APPROVAL_PKG.Mark_CO_Status',3);
230: p_return_status := 'S';
231: UPDATE pa_control_items SET status_code = 'CI_SUBMITTED' WHERE ci_id = p_ci_id;
232: EXCEPTION
233: WHEN OTHERS THEN
234: log_message('Inside WHEBN OTHERS exception of PA_TASK_APPROVAL_PKG.Mark_CO_Status',3);
235: p_return_status := 'E';