eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_EMAIL_PROC_PVT dependencies on JTF_IH_PUB

Line 62: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

58: l_tag_keyval IEM_TAGPROCESS_PUB.keyVals_tbl_type;
59: l_action varchar2(50);
60: l_counter number:=1;
61: l_uid number;
62: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
63: l_milcs_id NUMBER;
64: l_mp_milcs_id NUMBER; -- MLCS ID for MAIL PROCESSINGS
65: l_message_id number;
66: l_email_rec iem_rt_preproc_emails%ROWTYPE;

Line 119: l_media_rec JTF_IH_PUB.media_rec_type;

115: l_noti_flag varchar2(1);
116: l_auto_value varchar2(20);
117: l_dflt_sender varchar2(200);
118: l_wf_custom_val varchar2(200);
119: l_media_rec JTF_IH_PUB.media_rec_type;
120: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
121: l_activity_rec JTF_IH_PUB.activity_rec_type;
122: l_interaction_id number;
123: l_activity_id number;

Line 120: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

116: l_auto_value varchar2(20);
117: l_dflt_sender varchar2(200);
118: l_wf_custom_val varchar2(200);
119: l_media_rec JTF_IH_PUB.media_rec_type;
120: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
121: l_activity_rec JTF_IH_PUB.activity_rec_type;
122: l_interaction_id number;
123: l_activity_id number;
124: l_param_index number;

Line 121: l_activity_rec JTF_IH_PUB.activity_rec_type;

117: l_dflt_sender varchar2(200);
118: l_wf_custom_val varchar2(200);
119: l_media_rec JTF_IH_PUB.media_rec_type;
120: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
121: l_activity_rec JTF_IH_PUB.activity_rec_type;
122: l_interaction_id number;
123: l_activity_id number;
124: l_param_index number;
125: l_cust_search_id number;

Line 3103: l_logmessage:='calling JTF_IH_PUB.Update_Interaction ';

3099: l_interaction_rec.resource_id:=l_agentid;
3100:
3101:
3102: if g_statement_log then
3103: l_logmessage:='calling JTF_IH_PUB.Update_Interaction ';
3104: iem_logger(l_logmessage);
3105: end if;
3106:
3107: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,

Line 3107: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,

3103: l_logmessage:='calling JTF_IH_PUB.Update_Interaction ';
3104: iem_logger(l_logmessage);
3105: end if;
3106:
3107: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
3108: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3109: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3110: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3111: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

Line 3119: l_logmessage:='end JTF_IH_PUB.Update_Interaction status'||l_ret_status || ' txt : '||l_msg_data;

3115: p_interaction_rec => l_interaction_rec
3116: );
3117:
3118: if g_statement_log then
3119: l_logmessage:='end JTF_IH_PUB.Update_Interaction status'||l_ret_status || ' txt : '||l_msg_data;
3120: iem_logger(l_logmessage);
3121: end if;
3122:
3123: IF l_ret_status<>'S' THEN

Line 4008: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,

4004:
4005: PROCEDURE IEM_PROC_IH(
4006: p_type in varchar2, -- MEDIA/ACTIVITY/MLCS/INTERACTION
4007: p_action in varchar2, -- ADD/UPDATE/CLOSE
4008: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,
4009: p_activity_rec IN JTF_IH_PUB.activity_rec_type,
4010: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,
4011: p_media_rec IN JTF_IH_PUB.media_rec_type,
4012: x_id OUT NOCOPY NUMBER,

Line 4009: p_activity_rec IN JTF_IH_PUB.activity_rec_type,

4005: PROCEDURE IEM_PROC_IH(
4006: p_type in varchar2, -- MEDIA/ACTIVITY/MLCS/INTERACTION
4007: p_action in varchar2, -- ADD/UPDATE/CLOSE
4008: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,
4009: p_activity_rec IN JTF_IH_PUB.activity_rec_type,
4010: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,
4011: p_media_rec IN JTF_IH_PUB.media_rec_type,
4012: x_id OUT NOCOPY NUMBER,
4013: x_status out NOCOPY varchar2,

Line 4010: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,

4006: p_type in varchar2, -- MEDIA/ACTIVITY/MLCS/INTERACTION
4007: p_action in varchar2, -- ADD/UPDATE/CLOSE
4008: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,
4009: p_activity_rec IN JTF_IH_PUB.activity_rec_type,
4010: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,
4011: p_media_rec IN JTF_IH_PUB.media_rec_type,
4012: x_id OUT NOCOPY NUMBER,
4013: x_status out NOCOPY varchar2,
4014: x_out_text out NOCOPY varchar2) IS

Line 4011: p_media_rec IN JTF_IH_PUB.media_rec_type,

4007: p_action in varchar2, -- ADD/UPDATE/CLOSE
4008: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,
4009: p_activity_rec IN JTF_IH_PUB.activity_rec_type,
4010: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,
4011: p_media_rec IN JTF_IH_PUB.media_rec_type,
4012: x_id OUT NOCOPY NUMBER,
4013: x_status out NOCOPY varchar2,
4014: x_out_text out NOCOPY varchar2) IS
4015: l_media_id number;

Line 4018: l_activity_rec JTF_IH_PUB.activity_rec_type;

4014: x_out_text out NOCOPY varchar2) IS
4015: l_media_id number;
4016: l_milcs_id number;
4017: l_interaction_id number;
4018: l_activity_rec JTF_IH_PUB.activity_rec_type;
4019: l_activity_id number;
4020: l_ret_status varchar2(10);
4021: l_msg_data varchar2(1500);
4022: l_data varchar2(1500);

Line 4030: JTF_IH_PUB.Open_MediaItem(1.0,

4026: IH_EXCEPTION EXCEPTION;
4027: BEGIN
4028: if p_type='MEDIA' THEN
4029: if p_action='ADD' THEN
4030: JTF_IH_PUB.Open_MediaItem(1.0,
4031: 'T',
4032: 'F',
4033: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4034: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

Line 4051: JTF_IH_PUB.Update_MediaItem( 1.0,

4047: end if;
4048:
4049: elsif p_action='UPDATE' THEN
4050:
4051: JTF_IH_PUB.Update_MediaItem( 1.0,
4052: 'T',
4053: 'F',
4054: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4055: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

Line 4068: JTF_IH_PUB.Close_MediaItem( 1.0,

4064: raise IH_EXCEPTION;
4065: end if;
4066: elsif p_action='CLOSE' THEN
4067:
4068: JTF_IH_PUB.Close_MediaItem( 1.0,
4069: 'T',
4070: 'F',
4071: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4072: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

Line 4086: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,

4082: end if;
4083: end if;
4084: elsif p_type='MLCS' THEN
4085: if p_action='ADD' THEN
4086: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
4087: 'T',
4088: 'F',
4089: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4090: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

Line 4106: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,

4102: else
4103: x_id:=l_milcs_id;
4104: end if;
4105: elsif p_action='UPDATE' THEN
4106: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,
4107: 'T',
4108: 'F',
4109: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4110: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

Line 4125: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,

4121: end if;
4122: elsif p_type='INTERACTION' THEN
4123: IF p_action='ADD' THEN
4124:
4125: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
4126: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4127: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4128: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4129: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

Line 4143: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,

4139: else
4140: x_id:=l_interaction_id;
4141: end if;
4142: ELSIF p_action='UPDATE' THEN
4143: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4144: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4145: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4146: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4147: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

Line 4158: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,

4154: x_out_text:='Error While Updating Interaction ';
4155: raise IH_EXCEPTION;
4156: END IF;
4157: ELSIF p_action='CLOSE' THEN
4158: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,
4159: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4160: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4161: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4162: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

Line 4185: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,

4181: and aa.default_wrap_id = wu.wrap_id;
4182: EXCEPTION WHEN OTHERS THEN
4183: NULL;
4184: END;
4185: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
4186: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4187: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4188: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4189: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

Line 4231: l_media_rec JTF_IH_PUB.media_rec_type;

4227: p_action_id in number,
4228: x_out_text out NOCOPY varchar2,
4229: x_status out NOCOPY varchar2) IS
4230:
4231: l_media_rec JTF_IH_PUB.media_rec_type;
4232: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
4233: l_stat varchar2(10);
4234: l_out_text varchar2(500);
4235: l_uid number;

Line 4232: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

4228: x_out_text out NOCOPY varchar2,
4229: x_status out NOCOPY varchar2) IS
4230:
4231: l_media_rec JTF_IH_PUB.media_rec_type;
4232: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
4233: l_stat varchar2(10);
4234: l_out_text varchar2(500);
4235: l_uid number;
4236: l_milcs_id number;

Line 4238: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

4234: l_out_text varchar2(500);
4235: l_uid number;
4236: l_milcs_id number;
4237: l_interaction_id number;
4238: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
4239: l_action_id number;
4240: l_activity_rec JTF_IH_PUB.activity_rec_type;
4241: WRAPUP_ERROR EXCEPTION;
4242: l_ret_status varchar2(10);

Line 4240: l_activity_rec JTF_IH_PUB.activity_rec_type;

4236: l_milcs_id number;
4237: l_interaction_id number;
4238: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
4239: l_action_id number;
4240: l_activity_rec JTF_IH_PUB.activity_rec_type;
4241: WRAPUP_ERROR EXCEPTION;
4242: l_ret_status varchar2(10);
4243: l_msg_data varchar2(300);
4244: l_msg_count number;

Line 4899: l_media_rec JTF_IH_PUB.media_rec_type;

4895: l_intent_str varchar2(700);
4896: l_index1 number;
4897: l_index2 number;
4898: l_api_name varchar2(100):='ReprocessAutoreply';
4899: l_media_rec JTF_IH_PUB.media_rec_type;
4900: l_kb_rank number;
4901: l_api_version_number number;
4902: l_rt_media_item_id number;
4903: l_rt_interaction_id number;

Line 4906: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

4902: l_rt_media_item_id number;
4903: l_rt_interaction_id number;
4904: l_milcs_id number;
4905: l_intent_counter number;
4906: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
4907: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
4908: l_activity_rec JTF_IH_PUB.activity_rec_type;
4909: l_Stat varchar2(100);
4910: l_auto_flag varchar2(10);

Line 4907: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

4903: l_rt_interaction_id number;
4904: l_milcs_id number;
4905: l_intent_counter number;
4906: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
4907: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
4908: l_activity_rec JTF_IH_PUB.activity_rec_type;
4909: l_Stat varchar2(100);
4910: l_auto_flag varchar2(10);
4911: l_encrypted_id varchar2(100);

Line 4908: l_activity_rec JTF_IH_PUB.activity_rec_type;

4904: l_milcs_id number;
4905: l_intent_counter number;
4906: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
4907: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
4908: l_activity_rec JTF_IH_PUB.activity_rec_type;
4909: l_Stat varchar2(100);
4910: l_auto_flag varchar2(10);
4911: l_encrypted_id varchar2(100);
4912: l_ret_status varchar2(10);

Line 5325: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,

5321: -- In case of autoroute update the interaction with resource id of the agent to which
5322: -- the message is autorouted to
5323: l_interaction_rec.interaction_id:=p_interaction_id;
5324: l_interaction_rec.resource_id:=l_agentid;
5325: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
5326: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
5327: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
5328: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
5329: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),