APPS.IEM_LOCAL_MESSAGE_STORE_PVT SQL Statements

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

Line: 15

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

Line: 16

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

Line: 58

    insert_arch_dtl_error	EXCEPTION;

Line: 88

	-- Insert Record into IEM_ARCH_MSG_DTLS
	IEM_ARCH_MSGDTLS_PVT.create_item(
		P_API_VERSION_NUMBER=>p_api_version_number,
 		P_INIT_MSG_LIST=>p_init_msg_list,
 		P_COMMIT=>p_commit,
		p_MESSAGE_ID =>FND_API.G_MISS_NUM,
 		P_INBOUND_MESSAGE_ID=>p_inbound_message_id,
 		P_EMAIL_ACCOUNT_ID=>p_email_account_id,
 		P_MAILPROC_STATUS=>p_mailproc_status,
 		P_RT_CLASSIFICATION_ID=>p_rt_classification_id,
 		P_MAIL_TYPE=>p_mail_type,
 		P_FROM_STR=>p_from_str,
 		P_REPLY_TO_STR=>p_reply_to_str,
 		P_TO_STR=>p_to_str,
		P_CC_STR=>p_cc_str,
		P_BCC_STR=>p_bcc_str,
 		P_SENT_DATE=>p_sent_date,
 		P_RECEIVED_DATE=>p_received_date,
 		P_SUBJECT=>p_subject,
 		P_AGENT_ID=>p_agent_id,
 		P_GROUP_ID=>p_group_id,
 		P_IH_MEDIA_ITEM_ID=>p_ih_media_item_id,
 		P_CUSTOMER_ID=>p_customer_id,
 		P_MESSAGE_SIZE=>p_message_size,
 		P_CONTACT_ID=>p_contact_id,
 		P_RELATIONSHIP_ID=>p_relationship_id,
 		P_TOP_INTENT=>p_top_intent,
 		P_MESSAGE_TEXT=>p_message_text,
    		p_ATTRIBUTE1   =>null,
    		p_ATTRIBUTE2   =>null,
    		p_ATTRIBUTE3   =>null,
    		p_ATTRIBUTE4   =>null,
    		p_ATTRIBUTE5   =>null,
    		p_ATTRIBUTE6   =>null,
    		p_ATTRIBUTE7   =>null,
    		p_ATTRIBUTE8   =>null,
    		p_ATTRIBUTE9   =>null,
    		p_ATTRIBUTE10  =>null,
    		p_ATTRIBUTE11  =>null,
    		p_ATTRIBUTE12  =>null,
    		p_ATTRIBUTE13  =>null,
    		p_ATTRIBUTE14  =>null,
    		p_ATTRIBUTE15  =>null,
		x_message_id=>l_message_id,
 		X_RETURN_STATUS=>l_return_status,
 		X_MSG_COUNT=>l_msg_count,
		 X_MSG_DATA=>l_msg_data);

Line: 137

		raise insert_arch_dtl_error;

Line: 212

 PROCEDURE delete_message (
                 p_api_version_number  IN   NUMBER,
		 p_init_msg_list       IN   VARCHAR2 := null,
		 p_commit              IN   VARCHAR2 := null,
		 p_message_id		IN	NUMBER,
	         p_action_flag		IN	VARCHAR2,
                 x_return_status	OUT     NOCOPY VARCHAR2,
  		 x_msg_count	        OUT	NOCOPY NUMBER,
	  	 x_msg_data	        OUT	NOCOPY VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='delete_message';

Line: 228

    delete_message_error	EXCEPTION;

Line: 265

			raise delete_message_error;

Line: 284

	ROLLBACK TO delete_message_PVT;

Line: 293

	   ROLLBACK TO delete_message_PVT;

Line: 301

	ROLLBACK TO delete_message_PVT;

Line: 318

 END delete_message;