APPS.IEM_ARCH_MSGDTLS_PVT SQL Statements

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

Line: 7

G_created_updated_by   NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

Line: 8

G_LAST_UPDATE_LOGIN    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;

Line: 67

    l_created_updated_by   NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));

Line: 68

    L_LAST_UPDATE_LOGIN    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;

Line: 99

   	SELECT IEM_MS_BASE_HEADERS_S1.nextval
	INTO l_seq_id
	FROM dual;

Line: 106

	INSERT INTO IEM_ARCH_MSGDTLS
	(
	MESSAGE_ID,
	INBOUND_MESSAGE_ID,
	EMAIL_ACCOUNT_ID,
	MAILPROC_STATUS,
	RT_CLASSIFICATION_ID,
	MAIL_TYPE,
	FROM_STR,
	REPLY_TO_STR,
	TO_STR,
	CC_STR,
	BCC_STR,
	SENT_DATE,
	RECEIVED_DATE,
	SUBJECT,
	resource_id,
	GROUP_ID,
	IH_MEDIA_ITEM_ID,
	CUSTOMER_ID,
	MESSAGE_SIZE,
	CONTACT_ID,
	RELATIONSHIP_ID,
	TOP_INTENT,
	MESSAGE_TEXT,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
	)
	VALUES
	(
	l_seq_id,
	decode(p_inbound_message_id, FND_API.G_MISS_NUM, null, p_inbound_message_id),
	p_email_account_id,
	p_mailproc_status,
	decode(p_rt_classification_id, FND_API.G_MISS_NUM, null, p_rt_classification_id),
	p_mail_type,
	p_from_str,
	decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),
	p_to_str,
	decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
	decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
	p_sent_date,
	decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
	decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
	decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
	decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
	decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
	decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
	p_message_size,
	decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
	decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
	decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
	decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
	decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
     decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
     decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
     decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
     decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
     decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
     decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
     decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
     decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
     decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
     decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
     decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
     decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
     decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
     decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
    --Changes for Bug no 7293941
    decode(l_created_updated_by,null,-1,l_created_updated_by),
	sysdate,
    decode(l_created_updated_by,null,-1,l_created_updated_by),
    sysdate,
    decode(L_LAST_UPDATE_LOGIN,null,-1,L_LAST_UPDATE_LOGIN)
	);