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 1481: l_tag_key_value IEM_TAGPROCESS_PUB.keyVals_tbl_type;

1477: x_msg_count OUT NOCOPY NUMBER,
1478: x_msg_data OUT NOCOPY VARCHAR2) IS
1479: l_api_version_number number:=1.0;
1480: l_api_name varchar2(30):='GetQueueItemData';
1481: l_tag_key_value IEM_TAGPROCESS_PUB.keyVals_tbl_type;
1482: l_msg_count number;
1483: l_msg_data varchar2(500);
1484: l_ret_status varchar2(50);
1485: l_encrypted_id varchar2(500);

Line 1508: IEM_TAGPROCESS_PUB.getTagValues_on_MsgId(

1504: resource_id=p_to_agent_id,
1505: mail_item_status=p_mail_item_status
1506: where message_id=p_message_id;
1507: l_tag_key_value.delete;
1508: IEM_TAGPROCESS_PUB.getTagValues_on_MsgId(
1509: P_Api_Version_Number=>1.0,
1510: p_message_id => x_email_data.message_id,
1511: x_key_value=>l_tag_key_value,
1512: x_encrypted_id=>l_encrypted_id,