APPS.OE_BULK_MSG_PUB SQL Statements

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

Line: 36

PROCEDURE Delete_tbl(p_count NUMBER := NULL)
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 43

        g_msg_tbl.MESSAGE.DELETE;

Line: 44

        g_msg_tbl.ENTITY_CODE.DELETE;

Line: 45

        g_msg_tbl.ENTITY_ID.DELETE;

Line: 46

        g_msg_tbl.HEADER_ID.DELETE;

Line: 47

        g_msg_tbl.LINE_ID.DELETE;

Line: 48

        g_msg_tbl.ORDER_SOURCE_ID.DELETE;

Line: 49

        g_msg_tbl.ORIG_SYS_DOCUMENT_REF.DELETE;

Line: 50

        g_msg_tbl.ORIG_SYS_DOCUMENT_LINE_REF.DELETE;

Line: 51

        g_msg_tbl.SOURCE_DOCUMENT_TYPE_ID.DELETE;

Line: 52

        g_msg_tbl.SOURCE_DOCUMENT_ID.DELETE;

Line: 53

        g_msg_tbl.SOURCE_DOCUMENT_LINE_ID.DELETE;

Line: 54

        g_msg_tbl.ATTRIBUTE_CODE.DELETE;

Line: 55

        g_msg_tbl.CONSTRAINT_ID.DELETE;

Line: 56

        g_msg_tbl.PROCESS_ACTIVITY.DELETE;

Line: 57

        g_msg_tbl.NOTIFICATION_FLAG.DELETE;

Line: 58

        g_msg_tbl.MESSAGE_TEXT.DELETE;

Line: 59

        g_msg_tbl.TYPE.DELETE;

Line: 60

        g_msg_tbl.ENTITY_REF.DELETE;

Line: 61

        g_msg_tbl.ORIG_SYS_SHIPMENT_REF.DELETE;

Line: 62

        g_msg_tbl.CHANGE_SEQUENCE.DELETE;

Line: 64

        g_msg_tbl.MESSAGE.DELETE(p_count);

Line: 65

        g_msg_tbl.ENTITY_CODE.DELETE(p_count);

Line: 66

        g_msg_tbl.ENTITY_ID.DELETE(p_count);

Line: 67

        g_msg_tbl.HEADER_ID.DELETE(p_count);

Line: 68

        g_msg_tbl.LINE_ID.DELETE(p_count);

Line: 69

        g_msg_tbl.ORDER_SOURCE_ID.DELETE(p_count);

Line: 70

        g_msg_tbl.ORIG_SYS_DOCUMENT_REF.DELETE(p_count);

Line: 71

        g_msg_tbl.ORIG_SYS_DOCUMENT_LINE_REF.DELETE(p_count);

Line: 72

        g_msg_tbl.SOURCE_DOCUMENT_TYPE_ID.DELETE(p_count);

Line: 73

        g_msg_tbl.SOURCE_DOCUMENT_ID.DELETE(p_count);

Line: 74

        g_msg_tbl.SOURCE_DOCUMENT_LINE_ID.DELETE(p_count);

Line: 75

        g_msg_tbl.ATTRIBUTE_CODE.DELETE(p_count);

Line: 76

        g_msg_tbl.CONSTRAINT_ID.DELETE(p_count);

Line: 77

        g_msg_tbl.PROCESS_ACTIVITY.DELETE(p_count);

Line: 78

        g_msg_tbl.NOTIFICATION_FLAG.DELETE(p_count);

Line: 79

        g_msg_tbl.MESSAGE_TEXT.DELETE(p_count);

Line: 80

        g_msg_tbl.TYPE.DELETE(p_count);

Line: 81

        g_msg_tbl.ENTITY_REF.DELETE(p_count);

Line: 82

        g_msg_tbl.ORIG_SYS_SHIPMENT_REF.DELETE(p_count);

Line: 83

        g_msg_tbl.CHANGE_SEQUENCE.DELETE(p_count);

Line: 85

END Delete_tbl;

Line: 97

   Delete_tbl(p_count => NULL);

Line: 123

G_msg_context_tbl.DELETE;

Line: 184

PROCEDURE Update_Msg_Context (
     p_entity_code                    IN  VARCHAR2  DEFAULT FND_API.G_MISS_CHAR
    ,p_entity_id                      IN  NUMBER    DEFAULT FND_API.G_MISS_NUM
    ,p_header_id                      IN  NUMBER    DEFAULT FND_API.G_MISS_NUM
    ,p_line_id                        IN  NUMBER    DEFAULT FND_API.G_MISS_NUM
    ,p_order_source_id                IN  NUMBER    DEFAULT FND_API.G_MISS_NUM
    ,p_orig_sys_document_ref          IN  VARCHAR2  DEFAULT FND_API.G_MISS_CHAR
    ,p_orig_sys_document_line_ref     IN  VARCHAR2  DEFAULT FND_API.G_MISS_CHAR
    ,p_source_document_type_id        IN  NUMBER    DEFAULT FND_API.G_MISS_NUM
    ,p_source_document_id             IN  NUMBER    DEFAULT FND_API.G_MISS_NUM
    ,p_source_document_line_id        IN  NUMBER    DEFAULT FND_API.G_MISS_NUM
    ,p_attribute_code                 IN  VARCHAR2  DEFAULT FND_API.G_MISS_CHAR
    ,p_constraint_id                  IN  NUMBER    DEFAULT FND_API.G_MISS_NUM
  ) IS
  --
  l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 237

End Update_Msg_Context;

Line: 248

	  G_msg_context_tbl.delete(G_msg_context_count) ;

Line: 323

         Select type
         Into   l_type
	    from   fnd_new_messages a,
		      fnd_application  b
	    where a.application_id = b.application_id
	    and   a.language_code = USERENV('LANG')
	    and   a.message_name = l_message_name
	    and   b.application_short_name = l_app_id;

Line: 432

PROCEDURE Delete_Msg
(   p_msg_index IN    NUMBER	:=  NULL
)
IS
l_msg_index	NUMBER;

Line: 444

	Delete_tbl(p_count => NULL);

Line: 477

		Delete_tbl(G_msg_count);

Line: 486

END Delete_Msg;

Line: 839

   INSERT INTO OE_PROCESSING_MSGS
   (
      TRANSACTION_ID
   ,  REQUEST_ID
   ,  ENTITY_CODE
   ,  ENTITY_ID
   ,  HEADER_ID
   ,  LINE_ID
   ,  ORIGINAL_SYS_DOCUMENT_REF
   ,  ORIGINAL_SYS_DOCUMENT_LINE_REF
   ,  SOURCE_DOCUMENT_ID
   ,  SOURCE_DOCUMENT_LINE_ID
   ,  ORDER_SOURCE_ID
   ,  SOURCE_DOCUMENT_TYPE_ID
   ,  ATTRIBUTE_CODE
   ,  PROGRAM_UPDATE_DATE
   ,  PROGRAM_APPLICATION_ID
   ,  PROGRAM_ID
   ,  LAST_UPDATE_LOGIN
   ,  LAST_UPDATED_BY
   ,  LAST_UPDATE_DATE
   ,  CREATED_BY
   ,  CREATION_DATE
   ,  CONSTRAINT_ID
   ,  PROCESS_ACTIVITY
   ,  NOTIFICATION_FLAG
   ,  ENTITY_REF
   ,  CHANGE_SEQUENCE
   ,  ORIG_SYS_SHIPMENT_REF
   ,  TYPE
   ,  MESSAGE_SOURCE_CODE
   ,  LANGUAGE
   ,  MESSAGE_TEXT
   )
   VALUES
   (
      OE_MSG_ID_S.NEXTVAL
   ,  p_request_id
   ,  G_msg_tbl.ENTITY_CODE(i)
   ,  G_msg_tbl.ENTITY_ID(i)
   ,  G_msg_tbl.HEADER_ID(i)
   ,  G_msg_tbl.LINE_ID(i)
   ,  G_msg_tbl.ORIG_SYS_DOCUMENT_REF(i)
   ,  G_msg_tbl.ORIG_SYS_DOCUMENT_LINE_REF(i)
   ,  G_msg_tbl.SOURCE_DOCUMENT_ID(i)
   ,  G_msg_tbl.SOURCE_DOCUMENT_LINE_ID(i)
   ,  G_msg_tbl.ORDER_SOURCE_ID(i)
   ,  G_msg_tbl.SOURCE_DOCUMENT_TYPE_ID(i)
   ,  G_msg_tbl.ATTRIBUTE_CODE(i)
   ,  NULL
   ,  660
   ,  NULL
   ,  FND_GLOBAL.USER_ID
   ,  FND_GLOBAL.USER_ID
   ,  sysdate
   ,  FND_GLOBAL.USER_ID
   ,  sysdate
   ,  G_msg_tbl.CONSTRAINT_ID(i)
   ,  G_msg_tbl.PROCESS_ACTIVITY(i)
   ,  G_msg_tbl.NOTIFICATION_FLAG(i)
   ,  G_msg_tbl.ENTITY_REF(i)
   ,  G_msg_tbl.change_sequence(i)
   ,  G_msg_tbl.ORIG_SYS_SHIPMENT_REF(i)
   ,  G_msg_tbl.TYPE(i)
   ,  'C'
   ,  USERENV('LANG')
   ,  G_msg_tbl.message(i)
   );