DBA Data[Home] [Help]

APPS.QP_BULK_MSG SQL Statements

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

Line: 44

     INSERT INTO QP_INTERFACE_ERRORS
		 (
		   ERROR_ID
		  ,LAST_UPDATE_DATE
		  ,LAST_UPDATED_BY
		  ,CREATION_DATE
		  ,CREATED_BY
		  ,LAST_UPDATE_LOGIN
		  ,REQUEST_ID
		  ,PROGRAM_APPLICATION_ID
		  ,PROGRAM_ID
		  ,PROGRAM_UPDATE_DATE
		  ,ENTITY_TYPE
		  ,TABLE_NAME
		  ,ORIG_SYS_HEADER_REF
		  ,ORIG_SYS_LINE_REF
		  ,ORIG_SYS_QUALIFIER_REF
		  ,ORIG_SYS_PRICING_ATTR_REF
		  ,ERROR_MESSAGE
		  )
     VALUES
      (
       QP_INTERFACE_ERRORS_S.NEXTVAL
       ,sysdate
       ,FND_GLOBAL.USER_ID
       ,sysdate
       ,FND_GLOBAL.USER_ID
       ,FND_GLOBAL.CONC_LOGIN_ID
       ,G_MSG_REC.REQUEST_ID(I)
       ,660
       ,NULL
       ,NULL
       ,G_MSG_REC.entity_type(I)
       ,G_MSG_REC.table_name(I)
       ,G_MSG_REC.ORIG_SYS_HEADER_REF(I)
       ,G_MSG_REC.ORIG_SYS_LINE_REF(I)
       ,G_MSG_REC.ORIG_SYS_QUALIFIER_REF(I)
       ,G_MSG_REC.ORIG_SYS_PRICING_ATTR_REF(I)
       ,G_MSG_REC.error_message(I)
       );
Line: 85

      G_MSG_REC.entity_type.delete;
Line: 86

      G_MSG_REC.request_id.delete;
Line: 87

      G_MSG_REC.table_name.delete;
Line: 88

      G_MSG_REC.orig_sys_header_ref.delete;
Line: 89

      G_MSG_REC.orig_sys_line_ref.delete;
Line: 90

      G_MSG_REC.orig_sys_qualifier_ref.delete;
Line: 91

      G_MSG_REC.orig_sys_pricing_attr_ref.delete;
Line: 92

      G_MSG_REC.error_message.delete;