APPS.IEM_THEME_DOCS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

     l_LAST_UPDATED_BY    	NUMBER:=-1 ;

Line: 11

     l_LAST_UPDATE_LOGIN      NUMBER:=-1 ;

Line: 15

INSERT INTO IEM_THEME_DOCS (
ACCOUNT_INTENT_DOC_ID,
THEME_ID       ,
CREATED_BY           ,
CREATION_DATE        ,
LAST_UPDATED_BY      ,
LAST_UPDATE_DATE     ,
LAST_UPDATE_LOGIN
)
VALUES
(
p_account_intent_doc_id   ,
p_theme_id,
decode(l_CREATED_BY,null,-1,l_CREATED_BY),
sysdate,
decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
sysdate,
decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN)
 );