The following lines contain the word 'select', 'insert', 'update' or 'delete':
fnd_msg_pub.delete_msg();
select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;
EXECUTE immediate 'INSERT INTO IEU_UWQ_NONMEDIA_ACTIONS '||
'( NONMEDIA_ACTION_ID, ' ||
' CREATED_BY, ' ||
' CREATION_DATE, ' ||
' LAST_UPDATED_BY,' ||
' LAST_UPDATE_DATE, ' ||
' LAST_UPDATE_LOGIN, ' ||
' ACTION_OBJECT_CODE, ' ||
' MACTION_DEF_ID, ' ||
' APPLICATION_ID, ' ||
' RESPONSIBILITY_ID, ' ||
' SOURCE_FOR_TASK_FLAG, ' ||
' OBJECT_VERSION_NUMBER,' ||
' SECURITY_GROUP_ID ' ||
' )VALUES ' ||
'(:1 ,' ||
' :2, '||
' :3, '||
' :4, '||
' :5, '||
' :6, '||
' :7, '||
' :8, '||
' :9, '||
' :10, '||
' :11, '||
' :12, '||
' :13 '||
') '
USING l_nmedia_id,
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.LOGIN_ID,
LTRIM(RTRIM(p_docname)),
p_mdef_id,
696,
p_resp_id,
p_tflag,
0,
0;
PROCEDURE Update_NMediaAction( x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_nmedia_id IN NUMBER,
p_docname IN VARCHAR2,
p_resp_id IN NUMBER,
p_tflag IN VARCHAR2,
p_mdef_id IN NUMBER
)as
l_language VARCHAR2(4);
fnd_msg_pub.delete_msg();
update IEU_UWQ_NONMEDIA_ACTIONS set
LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
MACTION_DEF_ID = p_mdef_id,
RESPONSIBILITY_ID = p_resp_id,
SOURCE_FOR_TASK_FLAG = p_tflag,
ACTION_OBJECT_CODE= p_docname
where
NONMEDIA_ACTION_ID = p_nmedia_id;
select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;
EXECUTE immediate 'INSERT INTO IEU_UWQ_NONMEDIA_ACTIONS '||
'( NONMEDIA_ACTION_ID, ' ||
' CREATED_BY, ' ||
' CREATION_DATE, ' ||
' LAST_UPDATED_BY,' ||
' LAST_UPDATE_DATE, ' ||
' LAST_UPDATE_LOGIN, ' ||
' ACTION_OBJECT_CODE, ' ||
' MACTION_DEF_ID, ' ||
' APPLICATION_ID, ' ||
' RESPONSIBILITY_ID, ' ||
' SOURCE_FOR_TASK_FLAG, ' ||
' OBJECT_VERSION_NUMBER,' ||
' SECURITY_GROUP_ID ' ||
' )VALUES ' ||
'(:1 ,' ||
' :2, '||
' :3, '||
' :4, '||
' :5, '||
' :6, '||
' :7, '||
' :8, '||
' :9, '||
' :10, '||
' :11, '||
' :12, '||
' :13 '||
') '
USING l_nmedia_id,
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.LOGIN_ID,
LTRIM(RTRIM(p_docname)),
p_mdef_id,
696,
p_resp_id,
p_tflag,
0,
0;
END Update_NMediaAction;
PROCEDURE Delete_NMediaAction( x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_nmedia_id IN NUMBER
)as
l_language VARCHAR2(4);
fnd_msg_pub.delete_msg();
'delete from IEU_UWQ_NONMEDIA_ACTIONS '||
' where NONMEDIA_ACTION_ID = :1'
USING x_nmedia_id;
END Delete_NMediaAction;