APPS.IGP_AD_USERID_PKG dependencies on DUAL

Line 31: FROM dual;

27: */
28: -- Get the details of
29: CURSOR c_get_val IS
30: SELECT to_char(sysdate,'dd-mm-yyyy-HH24-MI-SS')
31: FROM dual;
32:
33: CURSOR c_get_fnd_user(cp_user_id fnd_user.user_id%TYPE) IS
34: SELECT user_name
35: FROM fnd_user

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';