APPS.IGW_PROP_NARRATIVES_TBH SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW (
 X_ROWID 		       OUT NOCOPY 	VARCHAR2,
 P_PROPOSAL_ID                 in	 NUMBER,
 P_MODULE_TITLE                in	VARCHAR2,
 P_MODULE_STATUS               in	VARCHAR2,
 P_CONTACT_NAME                in        VARCHAR2,
 P_PHONE_NUMBER                in        VARCHAR2,
 P_EMAIL_ADDRESS               in        VARCHAR2,
 P_COMMENTS                    in        VARCHAR2,
 P_MODE 		       IN 	VARCHAR2,
 X_RETURN_STATUS               OUT NOCOPY  	VARCHAR2) is

L_MODULE_ID  NUMBER;

Line: 18

cursor c is select ROWID from IGW_PROP_NARRATIVES
      where proposal_id = p_proposal_id
      and module_id = l_module_id;

Line: 22

      l_last_update_date 	DATE;

Line: 23

      l_last_updated_by 	NUMBER;

Line: 24

      l_last_update_login 	NUMBER;

Line: 30

  l_last_update_date := SYSDATE;

Line: 33

      l_last_updated_by := 1;

Line: 34

      l_last_update_login := 0;

Line: 36

       l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 38

       if l_last_updated_by is NULL then
            l_last_updated_by := -1;

Line: 42

       l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 44

       if l_last_update_login is NULL then
            l_last_update_login := -1;

Line: 53

insert into igw_prop_narratives (
  PROPOSAL_ID
 ,MODULE_ID
 ,MODULE_TITLE
 ,MODULE_STATUS
 ,CONTACT_NAME
 ,PHONE_NUMBER
 ,EMAIL_ADDRESS
 ,COMMENTS
 ,LAST_UPDATE_DATE
 ,LAST_UPDATED_BY
 ,CREATION_DATE
 ,CREATED_BY
 ,LAST_UPDATE_LOGIN
 ,RECORD_VERSION_NUMBER
  ) values (
  P_PROPOSAL_ID
 ,IGW_PROP_NARRATIVES_S.NEXTVAL
 ,P_MODULE_TITLE
 ,P_MODULE_STATUS
 ,P_CONTACT_NAME
 ,P_PHONE_NUMBER
 ,P_EMAIL_ADDRESS
 ,P_COMMENTS
 ,l_last_update_date
 ,l_last_updated_by
 ,l_last_update_date
 ,l_last_updated_by
 ,l_last_update_login
 ,1
 )
 RETURNING MODULE_ID INTO L_MODULE_ID;

Line: 97

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

Line: 102

END INSERT_ROW;

Line: 105

PROCEDURE UPDATE_ROW (
 X_ROWID 		       IN  	VARCHAR2,
 P_PROPOSAL_ID                 in	 NUMBER,
 P_MODULE_ID                   in 	NUMBER,
 P_MODULE_TITLE                in	VARCHAR2,
 P_MODULE_STATUS               in	VARCHAR2,
 P_CONTACT_NAME                in        VARCHAR2,
 P_PHONE_NUMBER                in        VARCHAR2,
 P_EMAIL_ADDRESS               in        VARCHAR2,
 P_COMMENTS                    in        VARCHAR2,
 P_MODE 		       IN 		VARCHAR2,
 P_RECORD_VERSION_NUMBER       IN            NUMBER,
 X_RETURN_STATUS               OUT NOCOPY  		VARCHAR2
	) is

    l_last_update_date 		DATE;

Line: 121

    l_last_updated_by 		NUMBER;

Line: 122

    l_last_update_login 	NUMBER;

Line: 128

     l_last_update_date := SYSDATE;

Line: 130

          l_last_updated_by := 1;

Line: 131

          l_last_update_login := 0;

Line: 133

          l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 135

          if l_last_updated_by is NULL then
                l_last_updated_by := -1;

Line: 139

          l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 141

          if l_last_update_login is NULL then
                l_last_update_login := -1;

Line: 149

      update IGW_PROP_NARRATIVES set
    	     	 PROPOSAL_ID  			=	P_PROPOSAL_ID
 		,MODULE_ID  			=	P_MODULE_ID
 		,MODULE_TITLE 			=	P_MODULE_TITLE
 		,MODULE_STATUS			=	P_MODULE_STATUS
 		,CONTACT_NAME			=	P_CONTACT_NAME
 		,PHONE_NUMBER 			=	P_PHONE_NUMBER
 		,EMAIL_ADDRESS			=	P_EMAIL_ADDRESS
 		,COMMENTS 			=	P_COMMENTS
 	        ,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: 174

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

Line: 179

END UPDATE_ROW;

Line: 183

PROCEDURE DELETE_ROW (
  x_rowid 			in	VARCHAR2,
  p_record_version_number 	in 	NUMBER,
  x_return_status       	out NOCOPY  	VARCHAR2
) is

BEGIN
x_return_status := fnd_api.g_ret_sts_success;

Line: 192

       delete from IGW_PROP_NARRATIVES
       where rowid = x_rowid
       and record_version_number = p_record_version_number;

Line: 206

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

Line: 211

END DELETE_ROW;

Line: 229

  cursor c1 is select rowid from IGW_BUSINESS_RULES_ALL
     where RULE_ID = X_RULE_ID
  ;

Line: 238

    INSERT_ROW (
     X_ROWID,
     X_RULE_ID,
     X_RULE_SEQUENCE_NUMBER,
     X_ORGANIZATION_ID,
     X_RULE_NAME,
     X_RULE_TYPE,
     X_MAP_ID,
     X_VALID_FLAG,
     X_START_DATE_ACTIVE,
     X_END_DATE_ACTIVE,
     X_MODE);

Line: 253

  UPDATE_ROW (
   X_RULE_ID,
   X_RULE_SEQUENCE_NUMBER,
   X_ORGANIZATION_ID,
   X_RULE_NAME,
   X_RULE_TYPE,
   X_MAP_ID,
   X_VALID_FLAG,
   X_START_DATE_ACTIVE,
   X_END_DATE_ACTIVE,
   X_MODE);

Line: 280

  cursor c1 is select *
    from IGW_BUSINESS_RULES_ALL
    where ROWID = X_ROWID
    for update of RULE_ID nowait;

Line: 290

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');