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_CLIENT_PUB dependencies on JTF_IH_PUB

Line 834: l_media_rec JTF_IH_PUB.MEDIA_REC_TYPE;

830: l_inpEmail_type VARCHAR2(2);
831: InteractnNotFnd EXCEPTION;
832: IHError EXCEPTION;
833:
834: l_media_rec JTF_IH_PUB.MEDIA_REC_TYPE;
835: l_media_id NUMBER;
836: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
837: l_resource_id NUMBER;
838: x_milcs_id NUMBER;

Line 836: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

832: IHError EXCEPTION;
833:
834: l_media_rec JTF_IH_PUB.MEDIA_REC_TYPE;
835: l_media_id NUMBER;
836: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
837: l_resource_id NUMBER;
838: x_milcs_id NUMBER;
839: l_i_sequence NUMBER;
840: l_m_sequence NUMBER;

Line 991: l_media_rec JTF_IH_PUB.MEDIA_REC_TYPE;

987:
988: l_status VARCHAR2(255);
989: l_msg_count NUMBER;
990: l_msg_data VARCHAR2(300);
991: l_media_rec JTF_IH_PUB.MEDIA_REC_TYPE;
992: l_media_id NUMBER;
993: badAccountType EXCEPTION;
994: badAccount EXCEPTION;
995: l_ob_media_id NUMBER;

Line 1080: JTF_IH_PUB.Open_MediaItem(p_api_version => 1.0,

1076: l_ih_subject:=p_subject;
1077: END IF;
1078: l_media_rec.media_data := l_ih_subject;
1079:
1080: JTF_IH_PUB.Open_MediaItem(p_api_version => 1.0,
1081: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
1082: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
1083: p_user_id => l_created_by,
1084: p_login_id => l_last_update_login,

Line 1297: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

1293: l_version NUMBER;
1294: l_email_type VARCHAR2(300);
1295: l_rt_interaction_id NUMBER;
1296:
1297: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
1298: l_media_id NUMBER;
1299: l_resource_id NUMBER;
1300: x_milcs_id NUMBER;
1301: badAccountType EXCEPTION;

Line 1415: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,

1411: l_media_lc_rec.media_id := l_media_id;
1412: l_media_lc_rec.milcs_type_id := 24; -- EMAIL_OPEN
1413: l_media_lc_rec.resource_id := l_resource_id;
1414: l_media_lc_rec.handler_id := 680;
1415: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
1416: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
1417: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
1418: p_user_id => l_created_by,
1419: p_login_id => l_last_update_login,

Line 1452: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,

1448: l_media_lc_rec.media_id := l_media_id;
1449: l_media_lc_rec.milcs_type_id := 18; -- EMAIL_FETCH
1450: l_media_lc_rec.resource_id := l_resource_id;
1451: l_media_lc_rec.handler_id := 680;
1452: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
1453: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
1454: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
1455: p_user_id => l_created_by,
1456: p_login_id => l_last_update_login,

Line 1726: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

1722: IHError EXCEPTION;
1723:
1724: l_rt_interaction_id NUMBER;
1725: l_interaction_id NUMBER;
1726: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
1727: l_customer_id NUMBER;
1728: l_contact_id NUMBER;
1729: l_resource_id NUMBER;
1730: l_start_date DATE;

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

1835: l_interaction_rec.handler_id := 680; -- IEM APPL_ID
1836: l_interaction_rec.reason_id := l_reason_id;
1837: l_interaction_rec.parent_id := l_parent_ih_id;
1838:
1839: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
1840: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
1841: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
1842: p_user_id => l_created_by,
1843: p_login_id => l_last_update_login,

Line 1953: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

1949: l_action_id_o NUMBER;
1950:
1951: l_rt_interaction_id NUMBER;
1952: l_interaction_id NUMBER;
1953: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
1954: l_customer_id NUMBER;
1955: l_resource_id NUMBER;
1956: l_start_date DATE;
1957: l_ob_media_id NUMBER;

Line 1961: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

1957: l_ob_media_id NUMBER;
1958: l_ib_media_id NUMBER;
1959: l_rfc822_message_id VARCHAR2(300);
1960: l_creation_date DATE;
1961: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
1962: l_media_rec JTF_IH_PUB.media_rec_type;
1963: x_milcs_id NUMBER;
1964: x_activity_id_i NUMBER;
1965: x_activity_id_o NUMBER;

Line 1962: l_media_rec JTF_IH_PUB.media_rec_type;

1958: l_ib_media_id NUMBER;
1959: l_rfc822_message_id VARCHAR2(300);
1960: l_creation_date DATE;
1961: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
1962: l_media_rec JTF_IH_PUB.media_rec_type;
1963: x_milcs_id NUMBER;
1964: x_activity_id_i NUMBER;
1965: x_activity_id_o NUMBER;
1966: l_activity_rec JTF_IH_PUB.activity_rec_type;

Line 1966: l_activity_rec JTF_IH_PUB.activity_rec_type;

1962: l_media_rec JTF_IH_PUB.media_rec_type;
1963: x_milcs_id NUMBER;
1964: x_activity_id_i NUMBER;
1965: x_activity_id_o NUMBER;
1966: l_activity_rec JTF_IH_PUB.activity_rec_type;
1967: l_mdt_message_id NUMBER;
1968: l_session_id NUMBER;
1969: l_activity_id NUMBER;
1970: l_count NUMBER;

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

2319: l_interaction_rec.handler_id := 680; -- IEM APPL_ID
2320: l_interaction_rec.reason_id := l_reason_id;
2321: l_interaction_rec.parent_id := l_parent_ih_id;
2322:
2323: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
2324: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2325: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2326: p_user_id => l_created_by,
2327: p_login_id => l_last_update_login,

Line 2374: JTF_IH_PUB.Open_MediaItem(p_api_version => 1.0,

2370: l_media_rec.media_item_type := G_MEDIA_TYPE;
2371: l_media_rec.media_item_ref := l_outb_message_id;
2372: l_media_rec.media_data := l_ih_subject;
2373:
2374: JTF_IH_PUB.Open_MediaItem(p_api_version => 1.0,
2375: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2376: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2377: p_user_id => l_created_by,
2378: p_login_id => l_last_update_login,

Line 2400: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,

2396: l_media_lc_rec.media_id := l_ob_media_id;
2397: l_media_lc_rec.milcs_type_id := l_action_id_o;
2398: l_media_lc_rec.resource_id := l_resource_id;
2399: l_media_lc_rec.handler_id := 680;
2400: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
2401: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2402: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2403: p_user_id => l_created_by,
2404: p_login_id => l_last_update_login,

Line 2423: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,

2419: l_media_rec.media_item_ref := l_outb_message_id;
2420: l_media_rec.media_data := l_ih_subject;
2421: l_media_rec.address := p_to_address;
2422:
2423: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,
2424: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2425: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2426: p_user_id => l_created_by,
2427: p_login_id => l_last_update_login,

Line 2448: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,

2444: l_media_lc_rec.media_id := l_ib_media_id;
2445: l_media_lc_rec.milcs_type_id := l_action_id_i;
2446: l_media_lc_rec.resource_id := l_resource_id;
2447: l_media_lc_rec.handler_id := 680;
2448: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
2449: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2450: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2451: p_user_id => l_created_by,
2452: p_login_id => l_last_update_login,

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

2490: l_activity_rec.reason_id := l_reason_id;
2491: l_activity_rec.action_item_id := l_activity_type_id;
2492:
2493:
2494: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
2495: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2496: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2497: p_user_id => l_created_by,
2498: p_login_id => l_last_update_login,

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

2523: ELSE
2524: l_activity_rec.action_id := l_action_id;
2525: END IF;
2526:
2527: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
2528: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2529: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2530: p_user_id => l_created_by,
2531: p_login_id => l_last_update_login,

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

2562: l_activity_rec.result_id := l_result_id;
2563: l_activity_rec.reason_id := l_reason_id;
2564: l_activity_rec.action_item_id := l_action_item_id;
2565:
2566: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
2567: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2568: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2569: p_user_id => l_created_by,
2570: p_login_id => l_last_update_login,

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

2602: l_activity_rec.result_id := l_result_id;
2603: l_activity_rec.reason_id := l_reason_id;
2604: l_activity_rec.action_item_id := 8; -- lead;
2605:
2606: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
2607: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2608: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2609: p_user_id => l_created_by,
2610: p_login_id => l_last_update_login,

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

2636: l_interaction_rec.reason_id := l_reason_id;
2637: -- done at creation l_interaction_rec.parent_id := l_parent_ih_id;
2638:
2639: IF (l_ih_creator = 'Y' OR l_ih_creator = 'S' ) THEN
2640: JTF_IH_PUB.Close_Interaction(p_api_version => 1.1,
2641: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2642: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2643: p_user_id => l_created_by,
2644: p_login_id => l_last_update_login,

Line 2785: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,

2781: l_media_lc_rec.media_id := l_ib_media_id;
2782: l_media_lc_rec.milcs_type_id := 21; -- EMAIL_TRANSFER (should be transfer_to, but not seeded)
2783: l_media_lc_rec.resource_id := p_to_resource_id;
2784: l_media_lc_rec.handler_id := 680;
2785: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
2786: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2787: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2788: p_user_id => l_created_by,
2789: p_login_id => l_last_update_login,

Line 3314: l_media_rec JTF_IH_PUB.MEDIA_REC_TYPE;

3310: l_profile_value varchar2(200);
3311: l_rfc822_message_id VARCHAR2(255);
3312: l_email_type VARCHAR2(1);
3313: l_version NUMBER;
3314: l_media_rec JTF_IH_PUB.MEDIA_REC_TYPE;
3315: i NUMBER;
3316: l_message_id NUMBER;
3317:
3318: CURSOR del_rt_csr IS

Line 3462: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,

3458: IF (l_email_type = 'I') THEN
3459: l_media_rec.direction := G_I_DIRECTION;
3460: END IF;
3461:
3462: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,
3463: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3464: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3465: p_user_id => l_created_by,
3466: p_login_id => l_last_update_login,

Line 3608: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

3604: l_customer_id NUMBER;
3605: l_contact_id NUMBER;
3606: l_relationship_id NUMBER;
3607: l_lead_id NUMBER;
3608: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
3609: l_milcs_id NUMBER;
3610: l_ih_creator VARCHAR2(1);
3611: l_mail_item_status VARCHAR2(1);
3612:

Line 3784: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,

3780: l_media_lc_rec.media_id := l_email_data_rec.IH_MEDIA_ITEM_ID;
3781: l_media_lc_rec.milcs_type_id := 35; -- EMAIL_ASSIGNED
3782: l_media_lc_rec.resource_id := p_to_resource_id;
3783: l_media_lc_rec.handler_id := 680;
3784: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
3785: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3786: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3787: p_user_id => l_created_by,
3788: p_login_id => l_last_update_login,

Line 3801: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,

3797: l_media_lc_rec.media_id := l_email_data_rec.IH_MEDIA_ITEM_ID;
3798: l_media_lc_rec.milcs_type_id := 45; -- EMAIL_ASSIGN
3799: l_media_lc_rec.resource_id := p_from_resource_id;
3800: l_media_lc_rec.handler_id := 680;
3801: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
3802: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3803: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3804: p_user_id => l_created_by,
3805: p_login_id => l_last_update_login,