APPS.IGW_PROP_CHECKLIST_TBH SQL Statements

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

Line: 5

PROCEDURE UPDATE_ROW (
 X_ROWID 		     in 	VARCHAR2,
 P_PROPOSAL_ID               in	 	NUMBER,
 P_DOCUMENT_TYPE_CODE        in		VARCHAR2,
 P_CHECKLIST_ORDER	     in         NUMBER,
 P_COMPLETE 		     in         VARCHAR2,
 P_NOT_APPLICABLE	     in		VARCHAR2,
 P_MODE 		     in 	VARCHAR2 default 'R',
 P_RECORD_VERSION_NUMBER     in         NUMBER,
 X_RETURN_STATUS             out  	VARCHAR2) is

    l_last_update_date 		DATE;

Line: 17

    l_last_updated_by 		NUMBER;

Line: 18

    l_last_update_login 	NUMBER;

Line: 24

     l_last_update_date := SYSDATE;

Line: 26

          l_last_updated_by := 1;

Line: 27

          l_last_update_login := 0;

Line: 29

          l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 31

          if l_last_updated_by is NULL then
                l_last_updated_by := -1;

Line: 35

          l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 37

          if l_last_update_login is NULL then
                l_last_update_login := -1;

Line: 45

      update IGW_PROP_CHECKLIST set
    	     	 PROPOSAL_ID  			=	P_PROPOSAL_ID
 		,DOCUMENT_TYPE_CODE  		=	P_DOCUMENT_TYPE_CODE
 		,CHECKLIST_ORDER 		=	P_CHECKLIST_ORDER
 		,COMPLETE			=	P_COMPLETE
 		,NOT_APPLICABLE			=       P_NOT_APPLICABLE
 	        ,last_update_date 		= 	l_last_update_date
 	        ,last_updated_by 		= 	l_last_updated_by
 	        ,last_update_login 		= 	l_last_update_login
 	        ,record_version_number 		= 	record_version_number + 1
      where rowid = x_rowid
      and record_version_number = p_record_version_number;

Line: 67

         			 p_procedure_name	=> 	'UPDATE_ROW',
         			 p_error_text  		=>  	 SUBSTRB(SQLERRM, 1, 240));

Line: 72

END UPDATE_ROW;