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 43: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

39: l_tag_keyval IEM_TAGPROCESS_PUB.keyVals_tbl_type;
40: l_action varchar2(50);
41: l_counter number:=1;
42: l_uid number;
43: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
44: l_milcs_id NUMBER;
45: l_mp_milcs_id NUMBER; -- MLCS ID for MAIL PROCESSINGS
46: l_message_id number;
47: l_email_rec iem_rt_preproc_emails%ROWTYPE;

Line 100: l_media_rec JTF_IH_PUB.media_rec_type;

96: l_noti_flag varchar2(1);
97: l_auto_value varchar2(20);
98: l_dflt_sender varchar2(200);
99: l_wf_custom_val varchar2(200);
100: l_media_rec JTF_IH_PUB.media_rec_type;
101: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
102: l_activity_rec JTF_IH_PUB.activity_rec_type;
103: l_interaction_id number;
104: l_activity_id number;

Line 101: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

97: l_auto_value varchar2(20);
98: l_dflt_sender varchar2(200);
99: l_wf_custom_val varchar2(200);
100: l_media_rec JTF_IH_PUB.media_rec_type;
101: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
102: l_activity_rec JTF_IH_PUB.activity_rec_type;
103: l_interaction_id number;
104: l_activity_id number;
105: l_param_index number;

Line 102: l_activity_rec JTF_IH_PUB.activity_rec_type;

98: l_dflt_sender varchar2(200);
99: l_wf_custom_val varchar2(200);
100: l_media_rec JTF_IH_PUB.media_rec_type;
101: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
102: l_activity_rec JTF_IH_PUB.activity_rec_type;
103: l_interaction_id number;
104: l_activity_id number;
105: l_param_index number;
106: l_cust_search_id number;

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

2097: -- In case of autoroute update the interaction with resource id of the agent to which
2098: -- the message is autorouted to
2099: l_interaction_rec.interaction_id:=l_interaction_id;
2100: l_interaction_rec.resource_id:=l_agentid;
2101: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
2102: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2103: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2104: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2105: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

Line 2913: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,

2909:
2910: PROCEDURE IEM_PROC_IH(
2911: p_type in varchar2, -- MEDIA/ACTIVITY/MLCS/INTERACTION
2912: p_action in varchar2, -- ADD/UPDATE/CLOSE
2913: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,
2914: p_activity_rec IN JTF_IH_PUB.activity_rec_type,
2915: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,
2916: p_media_rec IN JTF_IH_PUB.media_rec_type,
2917: x_id OUT NOCOPY NUMBER,

Line 2914: p_activity_rec IN JTF_IH_PUB.activity_rec_type,

2910: PROCEDURE IEM_PROC_IH(
2911: p_type in varchar2, -- MEDIA/ACTIVITY/MLCS/INTERACTION
2912: p_action in varchar2, -- ADD/UPDATE/CLOSE
2913: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,
2914: p_activity_rec IN JTF_IH_PUB.activity_rec_type,
2915: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,
2916: p_media_rec IN JTF_IH_PUB.media_rec_type,
2917: x_id OUT NOCOPY NUMBER,
2918: x_status out NOCOPY varchar2,

Line 2915: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,

2911: p_type in varchar2, -- MEDIA/ACTIVITY/MLCS/INTERACTION
2912: p_action in varchar2, -- ADD/UPDATE/CLOSE
2913: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,
2914: p_activity_rec IN JTF_IH_PUB.activity_rec_type,
2915: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,
2916: p_media_rec IN JTF_IH_PUB.media_rec_type,
2917: x_id OUT NOCOPY NUMBER,
2918: x_status out NOCOPY varchar2,
2919: x_out_text out NOCOPY varchar2) IS

Line 2916: p_media_rec IN JTF_IH_PUB.media_rec_type,

2912: p_action in varchar2, -- ADD/UPDATE/CLOSE
2913: p_interaction_rec IN JTF_IH_PUB.interaction_rec_type,
2914: p_activity_rec IN JTF_IH_PUB.activity_rec_type,
2915: p_media_lc_rec IN JTF_IH_PUB.media_lc_rec_type,
2916: p_media_rec IN JTF_IH_PUB.media_rec_type,
2917: x_id OUT NOCOPY NUMBER,
2918: x_status out NOCOPY varchar2,
2919: x_out_text out NOCOPY varchar2) IS
2920: l_media_id number;

Line 2923: l_activity_rec JTF_IH_PUB.activity_rec_type;

2919: x_out_text out NOCOPY varchar2) IS
2920: l_media_id number;
2921: l_milcs_id number;
2922: l_interaction_id number;
2923: l_activity_rec JTF_IH_PUB.activity_rec_type;
2924: l_activity_id number;
2925: l_ret_status varchar2(10);
2926: l_msg_data varchar2(1500);
2927: l_data varchar2(1500);

Line 2935: JTF_IH_PUB.Open_MediaItem(1.0,

2931: IH_EXCEPTION EXCEPTION;
2932: BEGIN
2933: if p_type='MEDIA' THEN
2934: if p_action='ADD' THEN
2935: JTF_IH_PUB.Open_MediaItem(1.0,
2936: 'T',
2937: 'F',
2938: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2939: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

Line 2956: JTF_IH_PUB.Update_MediaItem( 1.0,

2952: end if;
2953:
2954: elsif p_action='UPDATE' THEN
2955:
2956: JTF_IH_PUB.Update_MediaItem( 1.0,
2957: 'T',
2958: 'F',
2959: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2960: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

Line 2973: JTF_IH_PUB.Close_MediaItem( 1.0,

2969: raise IH_EXCEPTION;
2970: end if;
2971: elsif p_action='CLOSE' THEN
2972:
2973: JTF_IH_PUB.Close_MediaItem( 1.0,
2974: 'T',
2975: 'F',
2976: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2977: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

Line 2991: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,

2987: end if;
2988: end if;
2989: elsif p_type='MLCS' THEN
2990: if p_action='ADD' THEN
2991: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
2992: 'T',
2993: 'F',
2994: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2995: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

Line 3011: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,

3007: else
3008: x_id:=l_milcs_id;
3009: end if;
3010: elsif p_action='UPDATE' THEN
3011: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,
3012: 'T',
3013: 'F',
3014: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3015: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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

3026: end if;
3027: elsif p_type='INTERACTION' THEN
3028: IF p_action='ADD' THEN
3029:
3030: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
3031: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3032: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3033: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3034: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

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

3044: else
3045: x_id:=l_interaction_id;
3046: end if;
3047: ELSIF p_action='UPDATE' THEN
3048: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
3049: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3050: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3051: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3052: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

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

3059: x_out_text:='Error While Updating Interaction ';
3060: raise IH_EXCEPTION;
3061: END IF;
3062: ELSIF p_action='CLOSE' THEN
3063: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,
3064: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3065: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3066: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3067: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

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

3086: and aa.default_wrap_id = wu.wrap_id;
3087: EXCEPTION WHEN OTHERS THEN
3088: NULL;
3089: END;
3090: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
3091: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3092: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3093: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3094: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

Line 3136: l_media_rec JTF_IH_PUB.media_rec_type;

3132: p_action_id in number,
3133: x_out_text out NOCOPY varchar2,
3134: x_status out NOCOPY varchar2) IS
3135:
3136: l_media_rec JTF_IH_PUB.media_rec_type;
3137: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
3138: l_stat varchar2(10);
3139: l_out_text varchar2(500);
3140: l_uid number;

Line 3137: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

3133: x_out_text out NOCOPY varchar2,
3134: x_status out NOCOPY varchar2) IS
3135:
3136: l_media_rec JTF_IH_PUB.media_rec_type;
3137: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
3138: l_stat varchar2(10);
3139: l_out_text varchar2(500);
3140: l_uid number;
3141: l_milcs_id number;

Line 3143: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

3139: l_out_text varchar2(500);
3140: l_uid number;
3141: l_milcs_id number;
3142: l_interaction_id number;
3143: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
3144: l_action_id number;
3145: l_activity_rec JTF_IH_PUB.activity_rec_type;
3146: WRAPUP_ERROR EXCEPTION;
3147: l_ret_status varchar2(10);

Line 3145: l_activity_rec JTF_IH_PUB.activity_rec_type;

3141: l_milcs_id number;
3142: l_interaction_id number;
3143: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
3144: l_action_id number;
3145: l_activity_rec JTF_IH_PUB.activity_rec_type;
3146: WRAPUP_ERROR EXCEPTION;
3147: l_ret_status varchar2(10);
3148: l_msg_data varchar2(300);
3149: l_msg_count number;

Line 3804: l_media_rec JTF_IH_PUB.media_rec_type;

3800: l_intent_str varchar2(700);
3801: l_index1 number;
3802: l_index2 number;
3803: l_api_name varchar2(100):='ReprocessAutoreply';
3804: l_media_rec JTF_IH_PUB.media_rec_type;
3805: l_kb_rank number;
3806: l_api_version_number number;
3807: l_rt_media_item_id number;
3808: l_rt_interaction_id number;

Line 3811: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

3807: l_rt_media_item_id number;
3808: l_rt_interaction_id number;
3809: l_milcs_id number;
3810: l_intent_counter number;
3811: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
3812: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
3813: l_activity_rec JTF_IH_PUB.activity_rec_type;
3814: l_Stat varchar2(100);
3815: l_auto_flag varchar2(10);

Line 3812: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

3808: l_rt_interaction_id number;
3809: l_milcs_id number;
3810: l_intent_counter number;
3811: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
3812: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
3813: l_activity_rec JTF_IH_PUB.activity_rec_type;
3814: l_Stat varchar2(100);
3815: l_auto_flag varchar2(10);
3816: l_encrypted_id varchar2(100);

Line 3813: l_activity_rec JTF_IH_PUB.activity_rec_type;

3809: l_milcs_id number;
3810: l_intent_counter number;
3811: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
3812: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
3813: l_activity_rec JTF_IH_PUB.activity_rec_type;
3814: l_Stat varchar2(100);
3815: l_auto_flag varchar2(10);
3816: l_encrypted_id varchar2(100);
3817: l_ret_status varchar2(10);

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

4226: -- In case of autoroute update the interaction with resource id of the agent to which
4227: -- the message is autorouted to
4228: l_interaction_rec.interaction_id:=p_interaction_id;
4229: l_interaction_rec.resource_id:=l_agentid;
4230: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4231: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4232: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4233: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4234: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),