eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_EMAIL_PROC_PVT dependencies on FND_PROFILE

Line 226: l_intent_counter:=FND_PROFILE.VALUE_SPECIFIC('IEM_INTENT_RESPONSE_NUM');

222: END IF;
223:
224: /* Find the profile value set for Processing Number of Intents for suggested Documents */
225:
226: l_intent_counter:=FND_PROFILE.VALUE_SPECIFIC('IEM_INTENT_RESPONSE_NUM');
227: if l_intent_counter is null then
228: l_intent_counter:=1;
229: end if;
230: if g_statement_log then

Line 550: l_resource_id:=FND_PROFILE.VALUE_SPECIFIC('IEM_SRVR_ARES') ;

546:
547: -- *** Open an Interaction *** --
548:
549: l_interaction_rec.start_date_time := sysdate;
550: l_resource_id:=FND_PROFILE.VALUE_SPECIFIC('IEM_SRVR_ARES') ;
551: l_interaction_rec.resource_id:=l_resource_id ;
552:
553: IF l_interaction_rec.resource_id is NULL THEN
554: l_logmessage:='Default Resource Id is Not Set For Creating Interaction';

Line 562: l_customer_id := FND_PROFILE.VALUE_SPECIFIC('CS_SR_DEFAULT_CUSTOMER_NAME');

558: IF l_ih_id is not null then
559: l_interaction_rec.parent_id := l_ih_id;
560: end if;
561: if l_acct_type='I' then -- For internal account type it will come from profile
562: l_customer_id := FND_PROFILE.VALUE_SPECIFIC('CS_SR_DEFAULT_CUSTOMER_NAME');
563: end if;
564: if l_customer_id >0 then -- Tag Data or pre processing contain Customer Id
565: l_interaction_rec.party_id := l_customer_id;
566: else -- Pre processing/TAg data fails to retrun customer id

Line 990: (FND_PROFILE.VALUE_SPECIFIC('IEM_RERUN_CUSTOM_PROCEDURE')='N')) THEN

986:
987: IF l_autoproc_result='T' THEN
988: IF l_action='EXECPROCEDURE' THEN
989: IF ((l_post_rec.ih_media_item_id is not null) and
990: (FND_PROFILE.VALUE_SPECIFIC('IEM_RERUN_CUSTOM_PROCEDURE')='N')) THEN
991: if g_statement_log then
992: l_logmessage:='Not Executing Custom Procedure Again ';
993: iem_logger(l_logmessage);
994: end if;

Line 1160: l_party_id:=FND_PROFILE.VALUE_SPECIFIC('CS_SR_DEFAULT_CUSTOMER_NAME');

1156: Where upper(email_address)=upper(l_sender);
1157: exception when others then
1158: l_contact_id:=null;
1159: END;
1160: l_party_id:=FND_PROFILE.VALUE_SPECIFIC('CS_SR_DEFAULT_CUSTOMER_NAME');
1161: else -- External Account
1162: l_emp_flag:='N';
1163: if l_customer_id>0 then
1164: -- Check to see if party identified is a contact or not

Line 1192: if fnd_profile.value_specific('IEM_SR_NO_CUST')='CREATESR' then

1188: l_Contact_id:=g_contact_id;
1189: end if;
1190: elsif l_customer_id=-1 then -- No customer match check profile
1191: -- for what to do next
1192: if fnd_profile.value_specific('IEM_SR_NO_CUST')='CREATESR' then
1193: l_party_id:=fnd_profile.value_specific('IEM_DEFAULT_CUSTOMER_ID');
1194: else
1195: l_party_id:=null;
1196: end if;

Line 1193: l_party_id:=fnd_profile.value_specific('IEM_DEFAULT_CUSTOMER_ID');

1189: end if;
1190: elsif l_customer_id=-1 then -- No customer match check profile
1191: -- for what to do next
1192: if fnd_profile.value_specific('IEM_SR_NO_CUST')='CREATESR' then
1193: l_party_id:=fnd_profile.value_specific('IEM_DEFAULT_CUSTOMER_ID');
1194: else
1195: l_party_id:=null;
1196: end if;
1197: else -- Multiple Customer Match.

Line 1211: l_note_type:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_NOTE_TYPE');

1207: if l_status<>'S' then
1208: l_logmessage:='Error Encountered while Retrieving Notes';
1209: raise ABORT_PROCESSING;
1210: end if;
1211: l_note_type:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_NOTE_TYPE');
1212: IEM_SERVICEREQUEST_PVT.IEM_CREATE_SR(
1213: p_api_version => 1.0,
1214: p_init_msg_list => FND_API.G_TRUE,
1215: p_commit => FND_API.G_FALSE,

Line 1372: l_noti_flag:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_CREATE_NOTI');

1368: l_logmessage:=l_out_text;
1369: raise ABORT_PROCESSING;
1370: END IF;
1371: -- Check for Sending out notifications
1372: l_noti_flag:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_CREATE_NOTI');
1373: if l_noti_flag='Y' then
1374: -- update the itneraction with result reason outcome
1375: select wu.outcome_id, wu.result_id, wu.reason_id INTO
1376: l_interaction_rec.outcome_id, l_interaction_rec.result_id, l_interaction_rec.reason_id

Line 1437: if (fnd_profile.value_specific('IEM_SR_NOT_UPDATED'))='REDIRECT'

1433: end if; -- for if l_noti_flag='Y'
1434: raise STOP_PROCESSING;
1435: else -- Sr creation fails so if it is internal type in that casecheck prfile value for next action. in case of external account it is always route.
1436: if l_acct_type='I' then
1437: if (fnd_profile.value_specific('IEM_SR_NOT_UPDATED'))='REDIRECT'
1438: then
1439: l_redirect_flag:='Y';
1440: end if;
1441: end if;

Line 1547: l_noti_flag:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_UPDATE_NOTI');

1543: l_logmessage:='AUTOUPDSR:Error While Inserting Record in Proc Emails Table ';
1544: raise ABORT_PROCESSING;
1545: END IF;
1546: -- Check for Sending Out Notifications
1547: l_noti_flag:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_UPDATE_NOTI');
1548: if l_noti_flag='Y' then -- Sends out notifications
1549:
1550: -- update the itneraction with result reason outcome
1551: select wu.outcome_id, wu.result_id, wu.reason_id INTO

Line 1638: if (fnd_profile.value_specific('IEM_SR_NOT_UPDATED'))='REDIRECT'

1634: raise STOP_PROCESSING;
1635: ELSE
1636: -- Sr updation fails so if it is internal type in that casecheck prfile value for next action. in case of external account it is always route.
1637: if l_acct_type='I' then
1638: if (fnd_profile.value_specific('IEM_SR_NOT_UPDATED'))='REDIRECT'
1639: then
1640: l_redirect_flag:='Y';
1641: end if;
1642: end if;

Line 1731: l_ext_address:=fnd_profile.value_specific('IEM_SR_REDIRECT_EMAIL_ADDR');

1727: END IF;
1728: else -- As auto redirect flag is set for autoupdate/create SR
1729: l_autoproc_result:='T';
1730: l_action:='AUTOREDIRECT_EXTERNAL';
1731: l_ext_address:=fnd_profile.value_specific('IEM_SR_REDIRECT_EMAIL_ADDR');
1732: end if;
1733: if l_action='AUTOREDIRECT_EXTERNAL' and l_autoproc_result='T' THEN
1734: IF l_auto_forward_flag='Y' THEN --donot autoforward to a already autofwd message
1735: l_autoproc_result:='F';

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

2098: -- the message is autorouted to
2099: l_interaction_rec.interaction_id:=l_interaction_id;
2100: l_interaction_rec.resource_id:=l_agentid;
2101: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
2102: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2103: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2104: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2105: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2106: x_return_status => l_ret_status,

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

2099: l_interaction_rec.interaction_id:=l_interaction_id;
2100: l_interaction_rec.resource_id:=l_agentid;
2101: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
2102: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2103: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2104: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2105: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2106: x_return_status => l_ret_status,
2107: x_msg_count => l_msg_count,

Line 2104: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

2100: l_interaction_rec.resource_id:=l_agentid;
2101: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
2102: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2103: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2104: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2105: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2106: x_return_status => l_ret_status,
2107: x_msg_count => l_msg_count,
2108: x_msg_data => l_msg_data,

Line 2105: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

2101: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
2102: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2103: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2104: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2105: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2106: x_return_status => l_ret_status,
2107: x_msg_count => l_msg_count,
2108: x_msg_data => l_msg_data,
2109: p_interaction_rec => l_interaction_rec

Line 2190: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

2186: p_doc_last_modified_date=>v_item.last_update_date,
2187: p_score =>l_kb_rank,
2188: p_url =>' ',
2189: p_kb_delete=>'N',
2190: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2191: p_CREATION_DATE =>SYSDATE,
2192: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2193: p_LAST_UPDATE_DATE =>SYSDATE,
2194: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 2192: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

2188: p_url =>' ',
2189: p_kb_delete=>'N',
2190: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2191: p_CREATION_DATE =>SYSDATE,
2192: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2193: p_LAST_UPDATE_DATE =>SYSDATE,
2194: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
2195: p_ATTRIBUTE1 =>null,
2196: p_ATTRIBUTE2 =>null,

Line 2194: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

2190: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2191: p_CREATION_DATE =>SYSDATE,
2192: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2193: p_LAST_UPDATE_DATE =>SYSDATE,
2194: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
2195: p_ATTRIBUTE1 =>null,
2196: p_ATTRIBUTE2 =>null,
2197: p_ATTRIBUTE3 =>null,
2198: p_ATTRIBUTE4 =>null,

Line 2538: l_resource_id:=FND_PROFILE.VALUE_SPECIFIC('IEM_SRVR_ARES') ;

2534: null;
2535: END;
2536: -- Calling OP Api for sending Out Auto Acknowledgement
2537:
2538: l_resource_id:=FND_PROFILE.VALUE_SPECIFIC('IEM_SRVR_ARES') ;
2539: IEM_OUTBOX_PROC_PUB.createOutboxMessage(p_api_version_number=>1.0,
2540: p_init_msg_list=>'F',
2541: p_commit=>'F',
2542: P_RESOURCE_ID=>l_resource_id,

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

2803: IEM_ServiceRequest_PVT.Update_Status_Wrap
2804: ( p_api_version =>2.0,
2805: p_init_msg_list =>fnd_api.g_true,
2806: p_commit => fnd_api.g_false,
2807: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2808: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2809: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2810: x_return_status =>l_ret_status,
2811: x_msg_count=>l_msg_count,

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

2804: ( p_api_version =>2.0,
2805: p_init_msg_list =>fnd_api.g_true,
2806: p_commit => fnd_api.g_false,
2807: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2808: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2809: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2810: x_return_status =>l_ret_status,
2811: x_msg_count=>l_msg_count,
2812: x_msg_data =>l_msg_data,

Line 2809: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

2805: p_init_msg_list =>fnd_api.g_true,
2806: p_commit => fnd_api.g_false,
2807: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2808: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2809: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2810: x_return_status =>l_ret_status,
2811: x_msg_count=>l_msg_count,
2812: x_msg_data =>l_msg_data,
2813: p_request_id =>p_sr_id,

Line 2938: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

2934: if p_action='ADD' THEN
2935: JTF_IH_PUB.Open_MediaItem(1.0,
2936: 'T',
2937: 'F',
2938: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2939: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2940: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2941: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2942: l_ret_status,

Line 2939: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

2935: JTF_IH_PUB.Open_MediaItem(1.0,
2936: 'T',
2937: 'F',
2938: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2939: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2940: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2941: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2942: l_ret_status,
2943: l_msg_count,

Line 2940: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

2936: 'T',
2937: 'F',
2938: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2939: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2940: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2941: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2942: l_ret_status,
2943: l_msg_count,
2944: l_msg_data,

Line 2941: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

2937: 'F',
2938: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2939: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2940: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2941: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2942: l_ret_status,
2943: l_msg_count,
2944: l_msg_data,
2945: p_media_rec,

Line 2959: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

2955:
2956: JTF_IH_PUB.Update_MediaItem( 1.0,
2957: 'T',
2958: 'F',
2959: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2960: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2961: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2962: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2963: l_ret_status,

Line 2960: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

2956: JTF_IH_PUB.Update_MediaItem( 1.0,
2957: 'T',
2958: 'F',
2959: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2960: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2961: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2962: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2963: l_ret_status,
2964: l_msg_count,

Line 2961: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

2957: 'T',
2958: 'F',
2959: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2960: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2961: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2962: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2963: l_ret_status,
2964: l_msg_count,
2965: l_msg_data,

Line 2962: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

2958: 'F',
2959: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2960: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2961: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2962: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2963: l_ret_status,
2964: l_msg_count,
2965: l_msg_data,
2966: p_media_rec);

Line 2976: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

2972:
2973: JTF_IH_PUB.Close_MediaItem( 1.0,
2974: 'T',
2975: 'F',
2976: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2977: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2978: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2979: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2980: l_ret_status,

Line 2977: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

2973: JTF_IH_PUB.Close_MediaItem( 1.0,
2974: 'T',
2975: 'F',
2976: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2977: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2978: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2979: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2980: l_ret_status,
2981: l_msg_count,

Line 2978: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

2974: 'T',
2975: 'F',
2976: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2977: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2978: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2979: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2980: l_ret_status,
2981: l_msg_count,
2982: l_msg_data,

Line 2979: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

2975: 'F',
2976: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2977: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2978: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2979: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2980: l_ret_status,
2981: l_msg_count,
2982: l_msg_data,
2983: p_media_rec);

Line 2994: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

2990: if p_action='ADD' THEN
2991: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
2992: 'T',
2993: 'F',
2994: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2995: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2996: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2997: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2998: l_ret_status,

Line 2995: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

2991: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
2992: 'T',
2993: 'F',
2994: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2995: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2996: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2997: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2998: l_ret_status,
2999: l_msg_count,

Line 2996: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

2992: 'T',
2993: 'F',
2994: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2995: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2996: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2997: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2998: l_ret_status,
2999: l_msg_count,
3000: l_msg_data,

Line 2997: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

2993: 'F',
2994: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2995: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2996: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
2997: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2998: l_ret_status,
2999: l_msg_count,
3000: l_msg_data,
3001: p_media_lc_rec,

Line 3014: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

3010: elsif p_action='UPDATE' THEN
3011: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,
3012: 'T',
3013: 'F',
3014: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3015: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3016: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3017: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3018: l_ret_status,

Line 3015: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

3011: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,
3012: 'T',
3013: 'F',
3014: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3015: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3016: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3017: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3018: l_ret_status,
3019: l_msg_count,

Line 3016: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

3012: 'T',
3013: 'F',
3014: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3015: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3016: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3017: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3018: l_ret_status,
3019: l_msg_count,
3020: l_msg_data,

Line 3017: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

3013: 'F',
3014: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3015: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3016: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3017: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3018: l_ret_status,
3019: l_msg_count,
3020: l_msg_data,
3021: p_media_lc_rec);

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

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

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

3028: IF p_action='ADD' THEN
3029:
3030: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
3031: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3032: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3033: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3034: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3035: x_return_status => l_ret_status,
3036: x_msg_count => l_msg_count,

Line 3033: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

3029:
3030: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
3031: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3032: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3033: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3034: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3035: x_return_status => l_ret_status,
3036: x_msg_count => l_msg_count,
3037: x_msg_data => l_msg_data,

Line 3034: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

3030: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
3031: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3032: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3033: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3034: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3035: x_return_status => l_ret_status,
3036: x_msg_count => l_msg_count,
3037: x_msg_data => l_msg_data,
3038: x_interaction_id => l_interaction_id,

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

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

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

3046: end if;
3047: ELSIF p_action='UPDATE' THEN
3048: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
3049: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3050: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3051: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3052: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3053: x_return_status => l_ret_status,
3054: x_msg_count => l_msg_count,

Line 3051: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

3047: ELSIF p_action='UPDATE' THEN
3048: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
3049: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3050: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3051: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3052: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3053: x_return_status => l_ret_status,
3054: x_msg_count => l_msg_count,
3055: x_msg_data => l_msg_data,

Line 3052: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

3048: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
3049: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3050: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3051: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3052: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3053: x_return_status => l_ret_status,
3054: x_msg_count => l_msg_count,
3055: x_msg_data => l_msg_data,
3056: p_interaction_rec => p_interaction_rec

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

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

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

3061: END IF;
3062: ELSIF p_action='CLOSE' THEN
3063: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,
3064: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3065: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3066: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3067: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3068: x_return_status => l_ret_status,
3069: x_msg_count => l_msg_count,

Line 3066: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

3062: ELSIF p_action='CLOSE' THEN
3063: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,
3064: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3065: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3066: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3067: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3068: x_return_status => l_ret_status,
3069: x_msg_count => l_msg_count,
3070: x_msg_data => l_msg_data,

Line 3067: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

3063: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,
3064: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3065: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3066: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3067: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3068: x_return_status => l_ret_status,
3069: x_msg_count => l_msg_count,
3070: x_msg_data => l_msg_data,
3071: p_interaction_rec => p_interaction_rec);

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

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

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

3088: NULL;
3089: END;
3090: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
3091: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3092: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3093: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3094: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3095: x_return_status => l_ret_status,
3096: x_msg_count => l_msg_count,

Line 3093: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

3089: END;
3090: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
3091: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3092: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3093: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3094: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3095: x_return_status => l_ret_status,
3096: x_msg_count => l_msg_count,
3097: x_msg_data => l_msg_data,

Line 3094: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

3090: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
3091: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3092: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3093: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3094: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3095: x_return_status => l_ret_status,
3096: x_msg_count => l_msg_count,
3097: x_msg_data => l_msg_data,
3098: p_activity_rec => l_activity_rec,

Line 3750: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

3746: p_classification_id=>x.classification_id,
3747: p_score=>x.score,
3748: p_message_id=>l_msg_id,
3749: p_class_string=>l_class_str,
3750: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3751: p_CREATION_DATE=> SYSDATE,
3752: p_LAST_UPDATED_BY=>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
3753: p_LAST_UPDATE_DATE=>SYSDATE,
3754: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,

Line 3752: p_LAST_UPDATED_BY=>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,

3748: p_message_id=>l_msg_id,
3749: p_class_string=>l_class_str,
3750: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3751: p_CREATION_DATE=> SYSDATE,
3752: p_LAST_UPDATED_BY=>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
3753: p_LAST_UPDATE_DATE=>SYSDATE,
3754: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
3755: x_return_Status=>l_status,
3756: x_msg_count=>l_count,

Line 3754: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,

3750: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3751: p_CREATION_DATE=> SYSDATE,
3752: p_LAST_UPDATED_BY=>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
3753: p_LAST_UPDATE_DATE=>SYSDATE,
3754: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
3755: x_return_Status=>l_status,
3756: x_msg_count=>l_count,
3757: x_msg_data=>l_msg_data);
3758: l_class_count:=l_class_count+1;

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

4227: -- the message is autorouted to
4228: l_interaction_rec.interaction_id:=p_interaction_id;
4229: l_interaction_rec.resource_id:=l_agentid;
4230: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4231: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4232: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4233: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4234: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4235: x_return_status => l_ret_status,

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

4228: l_interaction_rec.interaction_id:=p_interaction_id;
4229: l_interaction_rec.resource_id:=l_agentid;
4230: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4231: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4232: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4233: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4234: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4235: x_return_status => l_ret_status,
4236: x_msg_count => l_msg_count,

Line 4233: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

4229: l_interaction_rec.resource_id:=l_agentid;
4230: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4231: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4232: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4233: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4234: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4235: x_return_status => l_ret_status,
4236: x_msg_count => l_msg_count,
4237: x_msg_data => l_msg_data,

Line 4234: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

4230: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4231: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4232: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4233: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4234: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4235: x_return_status => l_ret_status,
4236: x_msg_count => l_msg_count,
4237: x_msg_data => l_msg_data,
4238: p_interaction_rec => l_interaction_rec

Line 4295: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4291: p_doc_last_modified_date=>v_item.last_update_date,
4292: p_score =>l_kb_rank,
4293: p_url =>' ',
4294: p_kb_delete=>'N',
4295: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4296: p_CREATION_DATE =>SYSDATE,
4297: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4298: p_LAST_UPDATE_DATE =>SYSDATE,
4299: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 4297: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4293: p_url =>' ',
4294: p_kb_delete=>'N',
4295: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4296: p_CREATION_DATE =>SYSDATE,
4297: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4298: p_LAST_UPDATE_DATE =>SYSDATE,
4299: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4300: p_ATTRIBUTE1 =>null,
4301: p_ATTRIBUTE2 =>null,

Line 4299: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

4295: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4296: p_CREATION_DATE =>SYSDATE,
4297: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4298: p_LAST_UPDATE_DATE =>SYSDATE,
4299: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4300: p_ATTRIBUTE1 =>null,
4301: p_ATTRIBUTE2 =>null,
4302: p_ATTRIBUTE3 =>null,
4303: p_ATTRIBUTE4 =>null,

Line 4466: l_search_repos:=FND_PROFILE.VALUE_SPECIFIC('IEM_KNOWLEDGE_BASE');

4462: from IEM_EMAIL_CLASSIFICATIONS
4463: WHERE MESSAGE_ID=l_msg_id AND EMAIL_ACCOUNT_ID=l_email_account_id
4464: and classification_id=l_classification_id;
4465: IF l_repos is null then
4466: l_search_repos:=FND_PROFILE.VALUE_SPECIFIC('IEM_KNOWLEDGE_BASE');
4467: IF l_search_repos is null then
4468: l_search_repos:='MES';
4469: END IF;
4470: else

Line 4527: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4523: p_doc_last_modified_date=>l_result_array(l_count).last_update_date,
4524: p_score =>to_char(l_result_array(l_count).score),
4525: p_url =>l_result_array(l_count).url_string,
4526: p_kb_delete=>'N',
4527: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4528: p_CREATION_DATE =>SYSDATE,
4529: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4530: p_LAST_UPDATE_DATE =>SYSDATE,
4531: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 4529: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4525: p_url =>l_result_array(l_count).url_string,
4526: p_kb_delete=>'N',
4527: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4528: p_CREATION_DATE =>SYSDATE,
4529: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4530: p_LAST_UPDATE_DATE =>SYSDATE,
4531: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4532: p_ATTRIBUTE1 =>null,
4533: p_ATTRIBUTE2 =>null,

Line 4531: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

4527: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4528: p_CREATION_DATE =>SYSDATE,
4529: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4530: p_LAST_UPDATE_DATE =>SYSDATE,
4531: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4532: p_ATTRIBUTE1 =>null,
4533: p_ATTRIBUTE2 =>null,
4534: p_ATTRIBUTE3 =>null,
4535: p_ATTRIBUTE4 =>null,

Line 4601: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4597: p_doc_last_modified_date=>l_result_array(l_count).last_update_date,
4598: p_score =>to_char(l_result_array(l_count).score),
4599: p_url =>l_result_array(l_count).url_string,
4600: p_kb_delete=>'N',
4601: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4602: p_CREATION_DATE =>SYSDATE,
4603: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4604: p_LAST_UPDATE_DATE =>SYSDATE,
4605: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 4603: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4599: p_url =>l_result_array(l_count).url_string,
4600: p_kb_delete=>'N',
4601: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4602: p_CREATION_DATE =>SYSDATE,
4603: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4604: p_LAST_UPDATE_DATE =>SYSDATE,
4605: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4606: p_ATTRIBUTE1 =>null,
4607: p_ATTRIBUTE2 =>null,

Line 4605: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

4601: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4602: p_CREATION_DATE =>SYSDATE,
4603: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4604: p_LAST_UPDATE_DATE =>SYSDATE,
4605: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4606: p_ATTRIBUTE1 =>null,
4607: p_ATTRIBUTE2 =>null,
4608: p_ATTRIBUTE3 =>null,
4609: p_ATTRIBUTE4 =>null,

Line 4689: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4685: p_doc_last_modified_date=>l_result_array(l_count).last_update_date,
4686: p_score =>to_char(l_result_array(l_count).score),
4687: p_url =>l_result_array(l_count).url_string,
4688: p_kb_delete=>'N',
4689: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4690: p_CREATION_DATE =>SYSDATE,
4691: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4692: p_LAST_UPDATE_DATE =>SYSDATE,
4693: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 4691: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4687: p_url =>l_result_array(l_count).url_string,
4688: p_kb_delete=>'N',
4689: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4690: p_CREATION_DATE =>SYSDATE,
4691: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4692: p_LAST_UPDATE_DATE =>SYSDATE,
4693: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4694: p_ATTRIBUTE1 =>null,
4695: p_ATTRIBUTE2 =>null,

Line 4693: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

4689: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4690: p_CREATION_DATE =>SYSDATE,
4691: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4692: p_LAST_UPDATE_DATE =>SYSDATE,
4693: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4694: p_ATTRIBUTE1 =>null,
4695: p_ATTRIBUTE2 =>null,
4696: p_ATTRIBUTE3 =>null,
4697: p_ATTRIBUTE4 =>null,

Line 4763: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4759: p_doc_last_modified_date=>l_result_array(l_count).last_update_date,
4760: p_score =>to_char(l_result_array(l_count).score),
4761: p_url =>l_result_array(l_count).url_string,
4762: p_kb_delete=>'N',
4763: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4764: p_CREATION_DATE =>SYSDATE,
4765: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4766: p_LAST_UPDATE_DATE =>SYSDATE,
4767: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 4765: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

4761: p_url =>l_result_array(l_count).url_string,
4762: p_kb_delete=>'N',
4763: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4764: p_CREATION_DATE =>SYSDATE,
4765: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4766: p_LAST_UPDATE_DATE =>SYSDATE,
4767: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4768: p_ATTRIBUTE1 =>null,
4769: p_ATTRIBUTE2 =>null,

Line 4767: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

4763: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4764: p_CREATION_DATE =>SYSDATE,
4765: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4766: p_LAST_UPDATE_DATE =>SYSDATE,
4767: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
4768: p_ATTRIBUTE1 =>null,
4769: p_ATTRIBUTE2 =>null,
4770: p_ATTRIBUTE3 =>null,
4771: p_ATTRIBUTE4 =>null,