APPS.IGP_AD_USERID_PKG dependencies on FND_PROFILE

Line 274: l_approver:=fnd_profile.value('IGP_ADMIN_WF_APPROVER');

270: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
271: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','l_message_text :'||l_message_text);
272: END IF;
273:
274: l_approver:=fnd_profile.value('IGP_ADMIN_WF_APPROVER');
275:
276: IF (l_approver IS NULL) THEN
277: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
278: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','approver not defined');

Line 300: select SUBSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),1,INSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),'/',1,3)) INTO l_url_part1 FROM dual;

296: fnd_message.set_name('IGS','IGP_AD_INTERNAL_NOTE');
297: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE', fnd_message.get);
298: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE', l_classification_cd);
299: END IF;
300: select SUBSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),1,INSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),'/',1,3)) INTO l_url_part1 FROM dual;
301: select FND_PROFILE.VALUE('ICX_OA_HTML') INTO l_url_part2 FROM dual;
302: l_url:=l_url_part1||l_url_part2||'/AppsLocalLogin.jsp';
303: l_url:=''||l_url||'';
304: wf_engine.SetItemAttrText(itemtype,itemkey,'P_URL', l_url);

Line 301: select FND_PROFILE.VALUE('ICX_OA_HTML') INTO l_url_part2 FROM dual;

297: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE', fnd_message.get);
298: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE', l_classification_cd);
299: END IF;
300: select SUBSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),1,INSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),'/',1,3)) INTO l_url_part1 FROM dual;
301: select FND_PROFILE.VALUE('ICX_OA_HTML') INTO l_url_part2 FROM dual;
302: l_url:=l_url_part1||l_url_part2||'/AppsLocalLogin.jsp';
303: l_url:=''||l_url||'';
304: wf_engine.SetItemAttrText(itemtype,itemkey,'P_URL', l_url);
305: resultout := 'COMPLETE:IGP_SUCCESS';