APPS.IEM_MAILITEM_PUB dependencies on IEM_TAGPROCESS_PUB

Line 601: l_tag_key_value IEM_TAGPROCESS_PUB.keyVals_tbl_type;

597: l_count number;
598: l_msg_data varchar2(500);
599: l_encrypted_id varchar2(500);
600: IEM_NO_DATA EXCEPTION;
601: l_tag_key_value IEM_TAGPROCESS_PUB.keyVals_tbl_type;
602: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
603: e_nowait EXCEPTION;
604: PRAGMA EXCEPTION_INIT(e_nowait, -54);
605: l_time number;

Line 674: IEM_TAGPROCESS_PUB.getTagValues_on_MsgId(

670: close email_dtl_cur;
671: END IF;
672: IF x_email_data.message_id IS NOT NULL THEN
673: l_tag_key_value.delete;
674: IEM_TAGPROCESS_PUB.getTagValues_on_MsgId(
675: P_Api_Version_Number=>1.0,
676: p_message_id => x_email_data.message_id,
677: x_key_value=>l_tag_key_value,
678: x_encrypted_id=>l_encrypted_id,

Line 1295: l_tag_key_value IEM_TAGPROCESS_PUB.keyVals_tbl_type;

1291: x_msg_count OUT NOCOPY NUMBER,
1292: x_msg_data OUT NOCOPY VARCHAR2) IS
1293: l_api_version_number number:=1.0;
1294: l_api_name varchar2(30):='GetQueueItemData';
1295: l_tag_key_value IEM_TAGPROCESS_PUB.keyVals_tbl_type;
1296: l_msg_count number;
1297: l_msg_data varchar2(500);
1298: l_ret_status varchar2(50);
1299: l_encrypted_id varchar2(500);

Line 1322: IEM_TAGPROCESS_PUB.getTagValues_on_MsgId(

1318: resource_id=p_to_agent_id,
1319: mail_item_status=p_mail_item_status
1320: where message_id=p_message_id;
1321: l_tag_key_value.delete;
1322: IEM_TAGPROCESS_PUB.getTagValues_on_MsgId(
1323: P_Api_Version_Number=>1.0,
1324: p_message_id => x_email_data.message_id,
1325: x_key_value=>l_tag_key_value,
1326: x_encrypted_id=>l_encrypted_id,