The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Delete_tbl(p_count NUMBER := NULL)
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
g_msg_tbl.MESSAGE.DELETE;
g_msg_tbl.ENTITY_CODE.DELETE;
g_msg_tbl.ENTITY_ID.DELETE;
g_msg_tbl.HEADER_ID.DELETE;
g_msg_tbl.LINE_ID.DELETE;
g_msg_tbl.ORDER_SOURCE_ID.DELETE;
g_msg_tbl.ORIG_SYS_DOCUMENT_REF.DELETE;
g_msg_tbl.ORIG_SYS_DOCUMENT_LINE_REF.DELETE;
g_msg_tbl.SOURCE_DOCUMENT_TYPE_ID.DELETE;
g_msg_tbl.SOURCE_DOCUMENT_ID.DELETE;
g_msg_tbl.SOURCE_DOCUMENT_LINE_ID.DELETE;
g_msg_tbl.ATTRIBUTE_CODE.DELETE;
g_msg_tbl.CONSTRAINT_ID.DELETE;
g_msg_tbl.PROCESS_ACTIVITY.DELETE;
g_msg_tbl.NOTIFICATION_FLAG.DELETE;
g_msg_tbl.MESSAGE_TEXT.DELETE;
g_msg_tbl.TYPE.DELETE;
g_msg_tbl.ENTITY_REF.DELETE;
g_msg_tbl.ORIG_SYS_SHIPMENT_REF.DELETE;
g_msg_tbl.CHANGE_SEQUENCE.DELETE;
g_msg_tbl.MESSAGE.DELETE(p_count);
g_msg_tbl.ENTITY_CODE.DELETE(p_count);
g_msg_tbl.ENTITY_ID.DELETE(p_count);
g_msg_tbl.HEADER_ID.DELETE(p_count);
g_msg_tbl.LINE_ID.DELETE(p_count);
g_msg_tbl.ORDER_SOURCE_ID.DELETE(p_count);
g_msg_tbl.ORIG_SYS_DOCUMENT_REF.DELETE(p_count);
g_msg_tbl.ORIG_SYS_DOCUMENT_LINE_REF.DELETE(p_count);
g_msg_tbl.SOURCE_DOCUMENT_TYPE_ID.DELETE(p_count);
g_msg_tbl.SOURCE_DOCUMENT_ID.DELETE(p_count);
g_msg_tbl.SOURCE_DOCUMENT_LINE_ID.DELETE(p_count);
g_msg_tbl.ATTRIBUTE_CODE.DELETE(p_count);
g_msg_tbl.CONSTRAINT_ID.DELETE(p_count);
g_msg_tbl.PROCESS_ACTIVITY.DELETE(p_count);
g_msg_tbl.NOTIFICATION_FLAG.DELETE(p_count);
g_msg_tbl.MESSAGE_TEXT.DELETE(p_count);
g_msg_tbl.TYPE.DELETE(p_count);
g_msg_tbl.ENTITY_REF.DELETE(p_count);
g_msg_tbl.ORIG_SYS_SHIPMENT_REF.DELETE(p_count);
g_msg_tbl.CHANGE_SEQUENCE.DELETE(p_count);
END Delete_tbl;
Delete_tbl(p_count => NULL);
G_msg_context_tbl.DELETE;
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;
End Update_Msg_Context;
G_msg_context_tbl.delete(G_msg_context_count) ;
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;
PROCEDURE Delete_Msg
( p_msg_index IN NUMBER := NULL
)
IS
l_msg_index NUMBER;
Delete_tbl(p_count => NULL);
Delete_tbl(G_msg_count);
END Delete_Msg;
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)
);