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.

[Home] [Help]

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 1956: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

1952: --Emp Search. Shramana
1953: l_old_contact_id NUMBER;
1954: l_rt_interaction_id NUMBER;
1955: l_interaction_id NUMBER;
1956: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
1957: l_customer_id NUMBER;
1958: l_resource_id NUMBER;
1959: l_start_date DATE;
1960: l_ob_media_id NUMBER;

Line 1964: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

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

Line 1965: l_media_rec JTF_IH_PUB.media_rec_type;

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

Line 1969: l_activity_rec JTF_IH_PUB.activity_rec_type;

1965: l_media_rec JTF_IH_PUB.media_rec_type;
1966: x_milcs_id NUMBER;
1967: x_activity_id_i NUMBER;
1968: x_activity_id_o NUMBER;
1969: l_activity_rec JTF_IH_PUB.activity_rec_type;
1970: l_mdt_message_id NUMBER;
1971: l_session_id NUMBER;
1972: l_activity_id NUMBER;
1973: l_count NUMBER;

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

2345: l_interaction_rec.handler_id := 680; -- IEM APPL_ID
2346: l_interaction_rec.reason_id := l_reason_id;
2347: l_interaction_rec.parent_id := l_parent_ih_id;
2348:
2349: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
2350: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2351: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2352: p_user_id => l_created_by,
2353: p_login_id => l_last_update_login,

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

2379: l_interaction_rec.primary_party_id := l_primary_customer_id;
2380: l_interaction_rec.contact_party_id := l_ih_contact_id;
2381: l_interaction_rec.contact_rel_party_id := l_relationship_id;
2382: --Update interaction here. Since customer details have changed
2383: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
2384: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2385: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2386: p_user_id => l_created_by,
2387: p_login_id => l_last_update_login,

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

2424: l_media_rec.media_item_type := G_MEDIA_TYPE;
2425: l_media_rec.media_item_ref := l_outb_message_id;
2426: l_media_rec.media_data := l_ih_subject;
2427:
2428: JTF_IH_PUB.Open_MediaItem(p_api_version => 1.0,
2429: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2430: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2431: p_user_id => l_created_by,
2432: p_login_id => l_last_update_login,

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

2450: l_media_lc_rec.media_id := l_ob_media_id;
2451: l_media_lc_rec.milcs_type_id := l_action_id_o;
2452: l_media_lc_rec.resource_id := l_resource_id;
2453: l_media_lc_rec.handler_id := 680;
2454: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
2455: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2456: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2457: p_user_id => l_created_by,
2458: p_login_id => l_last_update_login,

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

2473: l_media_rec.media_item_ref := l_outb_message_id;
2474: l_media_rec.media_data := l_ih_subject;
2475: l_media_rec.address := p_to_address;
2476:
2477: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,
2478: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2479: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2480: p_user_id => l_created_by,
2481: p_login_id => l_last_update_login,

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

2498: l_media_lc_rec.media_id := l_ib_media_id;
2499: l_media_lc_rec.milcs_type_id := l_action_id_i;
2500: l_media_lc_rec.resource_id := l_resource_id;
2501: l_media_lc_rec.handler_id := 680;
2502: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
2503: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2504: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2505: p_user_id => l_created_by,
2506: p_login_id => l_last_update_login,

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

2544: l_activity_rec.reason_id := l_reason_id;
2545: l_activity_rec.action_item_id := l_activity_type_id;
2546:
2547:
2548: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
2549: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2550: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2551: p_user_id => l_created_by,
2552: p_login_id => l_last_update_login,

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

2577: ELSE
2578: l_activity_rec.action_id := l_action_id;
2579: END IF;
2580:
2581: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
2582: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2583: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2584: p_user_id => l_created_by,
2585: p_login_id => l_last_update_login,

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

2620: l_activity_rec.result_id := l_result_id;
2621: l_activity_rec.reason_id := l_reason_id;
2622: l_activity_rec.action_item_id := l_action_item_id;
2623:
2624: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
2625: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2626: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2627: p_user_id => l_created_by,
2628: p_login_id => l_last_update_login,

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

2661: l_activity_rec.result_id := l_result_id;
2662: l_activity_rec.reason_id := l_reason_id;
2663: l_activity_rec.action_item_id := 8; -- lead;
2664:
2665: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
2666: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2667: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2668: p_user_id => l_created_by,
2669: p_login_id => l_last_update_login,

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

2698: l_interaction_rec.reason_id := l_reason_id;
2699: -- done at creation l_interaction_rec.parent_id := l_parent_ih_id;
2700:
2701: IF (l_ih_creator = 'Y' OR l_ih_creator = 'S' ) THEN
2702: JTF_IH_PUB.Close_Interaction(p_api_version => 1.1,
2703: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2704: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2705: p_user_id => l_created_by,
2706: p_login_id => l_last_update_login,

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

2843: l_media_lc_rec.media_id := l_ib_media_id;
2844: l_media_lc_rec.milcs_type_id := 21; -- EMAIL_TRANSFER (should be transfer_to, but not seeded)
2845: l_media_lc_rec.resource_id := p_to_resource_id;
2846: l_media_lc_rec.handler_id := 680;
2847: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
2848: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2849: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2850: p_user_id => l_created_by,
2851: p_login_id => l_last_update_login,

Line 3376: l_media_rec JTF_IH_PUB.MEDIA_REC_TYPE;

3372: l_profile_value varchar2(200);
3373: l_rfc822_message_id VARCHAR2(255);
3374: l_email_type VARCHAR2(1);
3375: l_version NUMBER;
3376: l_media_rec JTF_IH_PUB.MEDIA_REC_TYPE;
3377: i NUMBER;
3378: l_message_id NUMBER;
3379:
3380: CURSOR del_rt_csr IS

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

3520: IF (l_email_type = 'I') THEN
3521: l_media_rec.direction := G_I_DIRECTION;
3522: END IF;
3523:
3524: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,
3525: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3526: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3527: p_user_id => l_created_by,
3528: p_login_id => l_last_update_login,

Line 3670: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;

3666: l_customer_id NUMBER;
3667: l_contact_id NUMBER;
3668: l_relationship_id NUMBER;
3669: l_lead_id NUMBER;
3670: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
3671: l_milcs_id NUMBER;
3672: l_ih_creator VARCHAR2(1);
3673: l_mail_item_status VARCHAR2(1);
3674: --Emp search. shramana

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

3855: l_media_lc_rec.media_id := l_email_data_rec.IH_MEDIA_ITEM_ID;
3856: l_media_lc_rec.milcs_type_id := 35; -- EMAIL_ASSIGNED
3857: l_media_lc_rec.resource_id := p_to_resource_id;
3858: l_media_lc_rec.handler_id := 680;
3859: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
3860: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3861: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3862: p_user_id => l_created_by,
3863: p_login_id => l_last_update_login,

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

3872: l_media_lc_rec.media_id := l_email_data_rec.IH_MEDIA_ITEM_ID;
3873: l_media_lc_rec.milcs_type_id := 45; -- EMAIL_ASSIGN
3874: l_media_lc_rec.resource_id := p_from_resource_id;
3875: l_media_lc_rec.handler_id := 680;
3876: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
3877: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3878: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3879: p_user_id => l_created_by,
3880: p_login_id => l_last_update_login,