The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT mc_header_id, name
FROM ahl_mc_headers_b
WHERE mc_header_id = p_mc_header_id and
object_version_number = nvl(p_object_version_number, object_version_number);
PROCEDURE UPDATE_STATUS
(
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,resultout OUT NOCOPY VARCHAR2
)
IS
l_error_msg VARCHAR2(4000);
'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS.begin',
'At the start of PLSQL procedure'
);
,aname => 'UPDATE_GEN_STATUS'
);
'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
'UPDATE_GEN_STATUS='||l_next_status||' -- OBJECT_VER='||l_object_version_number|| ' -- OBJECT_ID='||l_object_id
);
'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
false
);
UPDATE ahl_mc_headers_b
SET config_status_code = l_next_status,
object_version_number = l_object_version_number + 1,
last_update_date = sysdate,
last_updated_by = to_number(fnd_global.login_id),
last_update_login = to_number(fnd_global.login_id)
WHERE mc_header_id = l_object_id;
'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
'Successfully completed the MC with mc_header_id='||l_object_id
);
'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS.end',
'At the end of PLSQL procedure'
);
'UPDATE_STATUS',
itemtype,
itemkey,
actid,
funcmode,
l_error_msg
);
'UPDATE_STATUS',
itemtype,
itemkey,
actid,
funcmode,
l_error_msg
);
END UPDATE_STATUS;
'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
'ORG_STATUS_ID='||l_next_status||' -- OBJECT_VER='||l_object_version_number|| ' -- OBJECT_ID='||l_object_id
);
UPDATE ahl_mc_headers_b
SET config_status_code = l_next_status,
object_version_number = l_object_version_number + 1,
last_update_date = sysdate,
last_updated_by = to_number(fnd_global.login_id),
last_update_login = to_number(fnd_global.login_id)
WHERE mc_header_id = l_object_id;
'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
'Successfully reverted status of the MC with mc_header_id='||l_object_id
);