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 2040: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

2036: SAVEPOINT wrapUp_pvt;
2037: -- Init vars
2038: l_api_name :='wrapUp';
2039: l_api_version_number :=1.0;
2040: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2041: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2042: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
2043: l_ob_action_id := 0;
2044: l_reroute_to_classi := null;

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

2037: -- Init vars
2038: l_api_name :='wrapUp';
2039: l_api_version_number :=1.0;
2040: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2041: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2042: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
2043: l_ob_action_id := 0;
2044: l_reroute_to_classi := null;
2045: l_mc_param_action := ' ';

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

2038: l_api_name :='wrapUp';
2039: l_api_version_number :=1.0;
2040: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2041: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
2042: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
2043: l_ob_action_id := 0;
2044: l_reroute_to_classi := null;
2045: l_mc_param_action := ' ';
2046:

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

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

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

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

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

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

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

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,
2405: x_return_status => l_status,
2406: x_msg_count => l_msg_count,

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

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

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,
2428: x_return_status => l_status,
2429: x_msg_count => l_msg_count,

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

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

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,
2453: x_return_status => l_status,
2454: x_msg_count => l_msg_count,

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

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

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

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

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

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

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

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

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

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

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

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

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

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,
2790: x_return_status => l_status,
2791: x_msg_count => l_msg_count,

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

3056:
3057: -- Init vars
3058: l_api_name :='recoverCompose';
3059: l_api_version_number :=1.0;
3060: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3061: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3062: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3063:
3064: -- Standard call to check for call compatibility.

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

3057: -- Init vars
3058: l_api_name :='recoverCompose';
3059: l_api_version_number :=1.0;
3060: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3061: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3062: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3063:
3064: -- Standard call to check for call compatibility.
3065: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

3058: l_api_name :='recoverCompose';
3059: l_api_version_number :=1.0;
3060: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3061: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3062: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3063:
3064: -- Standard call to check for call compatibility.
3065: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3066: 1.0,

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

3332:
3333: -- Init vars
3334: l_api_name :='purgeOutbound';
3335: l_api_version_number :=1.0;
3336: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3337: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3338:
3339: -- Standard call to check for call compatibility.
3340: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

3333: -- Init vars
3334: l_api_name :='purgeOutbound';
3335: l_api_version_number :=1.0;
3336: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3337: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3338:
3339: -- Standard call to check for call compatibility.
3340: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3341: 1.0,

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

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

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

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,
3467: x_return_status => l_status,
3468: x_msg_count => l_msg_count,

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

3618:
3619: -- Init vars
3620: l_api_name :='assignMsg';
3621: l_api_version_number :=1.0;
3622: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3623: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3624: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3625: l_sr_id :=null;
3626: l_parent_ih_id :=null;

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

3619: -- Init vars
3620: l_api_name :='assignMsg';
3621: l_api_version_number :=1.0;
3622: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3623: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3624: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3625: l_sr_id :=null;
3626: l_parent_ih_id :=null;
3627: l_customer_id :=null;

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

3620: l_api_name :='assignMsg';
3621: l_api_version_number :=1.0;
3622: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3623: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3624: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3625: l_sr_id :=null;
3626: l_parent_ih_id :=null;
3627: l_customer_id :=null;
3628: l_contact_id :=null;

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

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

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,
3789: x_return_status => l_status,
3790: x_msg_count => l_msg_count,

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

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

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,
3806: x_return_status => l_status,
3807: x_msg_count => l_msg_count,

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

3931: SAVEPOINT queueToOutbox_pvt;
3932: -- Init vars
3933: l_api_name :='queueToOutbox';
3934: l_api_version_number :=1.0;
3935: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3936: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3937: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3938: l_noop := 0;
3939:

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

3932: -- Init vars
3933: l_api_name :='queueToOutbox';
3934: l_api_version_number :=1.0;
3935: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3936: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3937: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3938: l_noop := 0;
3939:
3940: -- Standard call to check for call compatibility.

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

3933: l_api_name :='queueToOutbox';
3934: l_api_version_number :=1.0;
3935: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3936: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3937: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3938: l_noop := 0;
3939:
3940: -- Standard call to check for call compatibility.
3941: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

4440:
4441: -- Init vars
4442: l_api_name :='createRTItem';
4443: l_api_version_number :=1.0;
4444: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4445: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4446: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4447: l_sr_id :=null;
4448: l_parent_ih_id :=null;

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

4441: -- Init vars
4442: l_api_name :='createRTItem';
4443: l_api_version_number :=1.0;
4444: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4445: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4446: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4447: l_sr_id :=null;
4448: l_parent_ih_id :=null;
4449: l_customer_id :=null;

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

4442: l_api_name :='createRTItem';
4443: l_api_version_number :=1.0;
4444: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4445: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4446: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4447: l_sr_id :=null;
4448: l_parent_ih_id :=null;
4449: l_customer_id :=null;
4450: l_contact_id :=null;

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

4660:
4661: -- Init vars
4662: l_api_name :='isAgentInboxClean';
4663: l_api_version_number :=1.0;
4664: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4665: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4666: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4667:
4668: -- Standard call to check for call compatibility.

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

4661: -- Init vars
4662: l_api_name :='isAgentInboxClean';
4663: l_api_version_number :=1.0;
4664: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4665: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4666: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4667:
4668: -- Standard call to check for call compatibility.
4669: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

4662: l_api_name :='isAgentInboxClean';
4663: l_api_version_number :=1.0;
4664: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4665: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4666: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4667:
4668: -- Standard call to check for call compatibility.
4669: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4670: 1.0,

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

4793:
4794: -- Init vars
4795: l_api_name :='updateOutboundMessageID';
4796: l_api_version_number :=1.0;
4797: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4798: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4799: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4800:
4801: -- Standard call to check for call compatibility.

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

4794: -- Init vars
4795: l_api_name :='updateOutboundMessageID';
4796: l_api_version_number :=1.0;
4797: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4798: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4799: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4800:
4801: -- Standard call to check for call compatibility.
4802: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

4795: l_api_name :='updateOutboundMessageID';
4796: l_api_version_number :=1.0;
4797: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4798: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4799: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4800:
4801: -- Standard call to check for call compatibility.
4802: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4803: 1.0,