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 FND_PROFILE

Line 89: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

85:
86: -- Initialize variables
87: l_api_name :='getWork';
88: l_api_version_number :=1.0;
89: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
90: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
91: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
92: l_sr_id :=null;
93: l_parent_ih_id :=null;

Line 90: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

86: -- Initialize variables
87: l_api_name :='getWork';
88: l_api_version_number :=1.0;
89: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
90: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
91: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
92: l_sr_id :=null;
93: l_parent_ih_id :=null;
94: l_customer_id :=null;

Line 91: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

87: l_api_name :='getWork';
88: l_api_version_number :=1.0;
89: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
90: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
91: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
92: l_sr_id :=null;
93: l_parent_ih_id :=null;
94: l_customer_id :=null;
95: l_contact_id :=null;

Line 854: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

850:
851: -- Init vars
852: l_api_name :='createUnprocMediaItm';
853: l_api_version_number :=1.0;
854: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
855: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
856: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
857:
858: l_email_account_id := 0;

Line 855: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

851: -- Init vars
852: l_api_name :='createUnprocMediaItm';
853: l_api_version_number :=1.0;
854: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
855: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
856: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
857:
858: l_email_account_id := 0;
859: l_agent_account_id := 0;

Line 856: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

852: l_api_name :='createUnprocMediaItm';
853: l_api_version_number :=1.0;
854: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
855: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
856: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
857:
858: l_email_account_id := 0;
859: l_agent_account_id := 0;
860: l_rt_classification_id := 0;

Line 1006: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1002: SAVEPOINT createMediaDetails_pvt;
1003: -- Init vars
1004: l_api_name :='createMediaDetails';
1005: l_api_version_number :=1.0;
1006: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1007: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1008: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1009: l_email_account_id := 0;
1010: l_email_account_id_ih := 0;

Line 1007: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1003: -- Init vars
1004: l_api_name :='createMediaDetails';
1005: l_api_version_number :=1.0;
1006: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1007: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1008: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1009: l_email_account_id := 0;
1010: l_email_account_id_ih := 0;
1011: l_agent_account_id := 0;

Line 1008: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

1004: l_api_name :='createMediaDetails';
1005: l_api_version_number :=1.0;
1006: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1007: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1008: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1009: l_email_account_id := 0;
1010: l_email_account_id_ih := 0;
1011: l_agent_account_id := 0;
1012: l_rt_interaction_id := 0;

Line 1081: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

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,
1085: x_return_status => l_status,

Line 1082: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
1085: x_return_status => l_status,
1086: x_msg_count => l_msg_count,

Line 1332: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1328:
1329: -- Init vars
1330: l_api_name :='updateMediaDetails';
1331: l_api_version_number :=1.0;
1332: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1333: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1334: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1335: l_email_account_id_old := 0;
1336: l_agent_account_id_old := 0;

Line 1333: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1329: -- Init vars
1330: l_api_name :='updateMediaDetails';
1331: l_api_version_number :=1.0;
1332: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1333: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1334: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1335: l_email_account_id_old := 0;
1336: l_agent_account_id_old := 0;
1337: l_uwq_act_code := null;

Line 1334: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

1330: l_api_name :='updateMediaDetails';
1331: l_api_version_number :=1.0;
1332: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1333: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1334: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1335: l_email_account_id_old := 0;
1336: l_agent_account_id_old := 0;
1337: l_uwq_act_code := null;
1338: l_ib_media_id := -1;

Line 1416: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
1420: x_return_status => l_status,

Line 1417: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
1420: x_return_status => l_status,
1421: x_msg_count => l_msg_count,

Line 1453: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
1457: x_return_status => l_status,

Line 1454: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
1457: x_return_status => l_status,
1458: x_msg_count => l_msg_count,

Line 1750: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1746:
1747: -- Init vars
1748: l_api_name :='getIHID';
1749: l_api_version_number :=1.0;
1750: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1751: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1752: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1753:
1754: -- Standard call to check for call compatibility.

Line 1751: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

1747: -- Init vars
1748: l_api_name :='getIHID';
1749: l_api_version_number :=1.0;
1750: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1751: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1752: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1753:
1754: -- Standard call to check for call compatibility.
1755: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1752: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

1748: l_api_name :='getIHID';
1749: l_api_version_number :=1.0;
1750: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1751: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1752: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1753:
1754: -- Standard call to check for call compatibility.
1755: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1756: 1.0,

Line 1840: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
1844: x_return_status => l_status,

Line 1841: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
1844: x_return_status => l_status,
1845: x_msg_count => l_msg_count,

Line 2046: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

2042: SAVEPOINT wrapUp_pvt;
2043: -- Init vars
2044: l_api_name :='wrapUp';
2045: l_api_version_number :=1.0;
2046: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2047: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2048: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
2049: l_ob_action_id := 0;
2050: l_reroute_to_classi := null;

Line 2047: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

2043: -- Init vars
2044: l_api_name :='wrapUp';
2045: l_api_version_number :=1.0;
2046: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2047: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2048: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
2049: l_ob_action_id := 0;
2050: l_reroute_to_classi := null;
2051: l_mc_param_action := ' ';

Line 2048: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

2044: l_api_name :='wrapUp';
2045: l_api_version_number :=1.0;
2046: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2047: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2048: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
2049: l_ob_action_id := 0;
2050: l_reroute_to_classi := null;
2051: l_mc_param_action := ' ';
2052:

Line 2350: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
2354: x_return_status => l_status,

Line 2351: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
2354: x_return_status => l_status,
2355: x_msg_count => l_msg_count,

Line 2384: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
2388: x_return_status => l_status,

Line 2385: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
2388: x_return_status => l_status,
2389: x_msg_count => l_msg_count,

Line 2429: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

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,
2433: x_return_status => l_status,

Line 2430: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
2433: x_return_status => l_status,
2434: x_msg_count => l_msg_count,

Line 2455: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
2459: x_return_status => l_status,

Line 2456: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
2459: x_return_status => l_status,
2460: x_msg_count => l_msg_count,

Line 2478: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
2482: x_return_status => l_status,

Line 2479: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
2482: x_return_status => l_status,
2483: x_msg_count => l_msg_count,

Line 2503: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
2507: x_return_status => l_status,

Line 2504: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
2507: x_return_status => l_status,
2508: x_msg_count => l_msg_count,

Line 2549: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
2553: x_return_status => l_status,

Line 2550: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
2553: x_return_status => l_status,
2554: x_msg_count => l_msg_count,

Line 2582: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

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,
2586: x_return_status => l_status,

Line 2583: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
2586: x_return_status => l_status,
2587: x_msg_count => l_msg_count,

Line 2625: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
2629: x_return_status => l_status,

Line 2626: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
2629: x_return_status => l_status,
2630: x_msg_count => l_msg_count,

Line 2666: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
2670: x_return_status => l_status,

Line 2667: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
2670: x_return_status => l_status,
2671: x_msg_count => l_msg_count,

Line 2703: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
2707: x_return_status => l_status,

Line 2704: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_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,
2707: x_return_status => l_status,
2708: x_msg_count => l_msg_count,

Line 2848: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
2852: x_return_status => l_status,

Line 2849: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
2852: x_return_status => l_status,
2853: x_msg_count => l_msg_count,

Line 3122: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

3118:
3119: -- Init vars
3120: l_api_name :='recoverCompose';
3121: l_api_version_number :=1.0;
3122: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3123: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3124: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3125:
3126: -- Standard call to check for call compatibility.

Line 3123: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

3119: -- Init vars
3120: l_api_name :='recoverCompose';
3121: l_api_version_number :=1.0;
3122: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3123: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3124: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3125:
3126: -- Standard call to check for call compatibility.
3127: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 3124: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

3120: l_api_name :='recoverCompose';
3121: l_api_version_number :=1.0;
3122: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3123: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3124: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3125:
3126: -- Standard call to check for call compatibility.
3127: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3128: 1.0,

Line 3398: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

3394:
3395: -- Init vars
3396: l_api_name :='purgeOutbound';
3397: l_api_version_number :=1.0;
3398: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3399: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3400:
3401: -- Standard call to check for call compatibility.
3402: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 3399: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

3395: -- Init vars
3396: l_api_name :='purgeOutbound';
3397: l_api_version_number :=1.0;
3398: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3399: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3400:
3401: -- Standard call to check for call compatibility.
3402: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3403: 1.0,

Line 3525: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

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,
3529: x_return_status => l_status,

Line 3526: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
3529: x_return_status => l_status,
3530: x_msg_count => l_msg_count,

Line 3686: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

3682:
3683: -- Init vars
3684: l_api_name :='assignMsg';
3685: l_api_version_number :=1.0;
3686: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3687: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3688: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3689: l_sr_id :=null;
3690: l_parent_ih_id :=null;

Line 3687: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

3683: -- Init vars
3684: l_api_name :='assignMsg';
3685: l_api_version_number :=1.0;
3686: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3687: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3688: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3689: l_sr_id :=null;
3690: l_parent_ih_id :=null;
3691: l_customer_id :=null;

Line 3688: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

3684: l_api_name :='assignMsg';
3685: l_api_version_number :=1.0;
3686: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3687: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3688: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3689: l_sr_id :=null;
3690: l_parent_ih_id :=null;
3691: l_customer_id :=null;
3692: l_contact_id :=null;

Line 3860: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
3864: x_return_status => l_status,

Line 3861: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
3864: x_return_status => l_status,
3865: x_msg_count => l_msg_count,

Line 3877: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_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,
3881: x_return_status => l_status,

Line 3878: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

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,
3881: x_return_status => l_status,
3882: x_msg_count => l_msg_count,

Line 4010: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

4006: SAVEPOINT queueToOutbox_pvt;
4007: -- Init vars
4008: l_api_name :='queueToOutbox';
4009: l_api_version_number :=1.0;
4010: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4011: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4012: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4013: l_noop := 0;
4014:

Line 4011: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

4007: -- Init vars
4008: l_api_name :='queueToOutbox';
4009: l_api_version_number :=1.0;
4010: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4011: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4012: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4013: l_noop := 0;
4014:
4015: -- Standard call to check for call compatibility.

Line 4012: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

4008: l_api_name :='queueToOutbox';
4009: l_api_version_number :=1.0;
4010: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4011: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4012: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4013: l_noop := 0;
4014:
4015: -- Standard call to check for call compatibility.
4016: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 4519: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

4515:
4516: -- Init vars
4517: l_api_name :='createRTItem';
4518: l_api_version_number :=1.0;
4519: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4520: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4521: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4522: l_sr_id :=null;
4523: l_parent_ih_id :=null;

Line 4520: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

4516: -- Init vars
4517: l_api_name :='createRTItem';
4518: l_api_version_number :=1.0;
4519: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4520: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4521: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4522: l_sr_id :=null;
4523: l_parent_ih_id :=null;
4524: l_customer_id :=null;

Line 4521: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

4517: l_api_name :='createRTItem';
4518: l_api_version_number :=1.0;
4519: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4520: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4521: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4522: l_sr_id :=null;
4523: l_parent_ih_id :=null;
4524: l_customer_id :=null;
4525: l_contact_id :=null;

Line 4739: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

4735:
4736: -- Init vars
4737: l_api_name :='isAgentInboxClean';
4738: l_api_version_number :=1.0;
4739: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4740: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4741: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4742:
4743: -- Standard call to check for call compatibility.

Line 4740: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

4736: -- Init vars
4737: l_api_name :='isAgentInboxClean';
4738: l_api_version_number :=1.0;
4739: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4740: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4741: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4742:
4743: -- Standard call to check for call compatibility.
4744: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 4741: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

4737: l_api_name :='isAgentInboxClean';
4738: l_api_version_number :=1.0;
4739: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4740: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4741: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4742:
4743: -- Standard call to check for call compatibility.
4744: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4745: 1.0,

Line 4872: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

4868:
4869: -- Init vars
4870: l_api_name :='updateOutboundMessageID';
4871: l_api_version_number :=1.0;
4872: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4873: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4874: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4875:
4876: -- Standard call to check for call compatibility.

Line 4873: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

4869: -- Init vars
4870: l_api_name :='updateOutboundMessageID';
4871: l_api_version_number :=1.0;
4872: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4873: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4874: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4875:
4876: -- Standard call to check for call compatibility.
4877: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 4874: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

4870: l_api_name :='updateOutboundMessageID';
4871: l_api_version_number :=1.0;
4872: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4873: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4874: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4875:
4876: -- Standard call to check for call compatibility.
4877: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4878: 1.0,