DBA Data[Home] [Help]

APPS.IGS_EN_WLST_GEN_PROC dependencies on FND_PROFILE

Line 202: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);

198: l_key NUMBER;
199: l_wf_installed fnd_lookups.lookup_code%TYPE;
200: BEGIN
201: -- get the profile value that is set for checking if workflow is installed
202: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);
203:
204: -- if workflow is installed then carry on with the raising an event
205: IF (RTRIM(l_wf_installed) ='Y') THEN
206: --

Line 258: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);

254: l_param_list wf_parameter_list_t:=wf_parameter_list_t();
255: l_wf_installed fnd_lookups.lookup_code%TYPE;
256: BEGIN
257: -- get the profile value that is set for checking if workflow is installed
258: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);
259:
260: -- if workflow is installed then carry on with the raising an event
261: IF (RTRIM(l_wf_installed) ='Y') THEN
262: SELECT IGS_EN_WF_MAILSTUD_S.NEXTVAL INTO l_key FROM dual;

Line 267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);

263: --
264: -- now add the parameters to the parameter list
265: --
266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);
268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);
269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);
270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);

Line 268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);

264: -- now add the parameters to the parameter list
265: --
266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);
268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);
269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);
270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);
272: --

Line 269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);

265: --
266: wf_event.AddParameterToList(p_name => 'ORG_ID', p_value => p_org_id, p_parameterlist => l_param_list);
267: wf_event.AddParameterToList(p_name => 'USER_ID', p_value => FND_PROFILE.VALUE('USER_ID'), p_parameterlist => l_param_list);
268: wf_event.AddParameterToList(p_name => 'RESP_ID', p_value => FND_PROFILE.VALUE('RESP_ID'), p_parameterlist => l_param_list);
269: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',p_value => FND_PROFILE.VALUE('RESP_APPL_ID'),p_parameterlist => l_param_list);
270: wf_event.AddParameterToList(p_name => 'UOO_ID', p_value => p_uoo_id, p_parameterlist => l_param_list);
271: wf_event.AddParameterToList(p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_param_list);
272: --
273: -- raise the event

Line 333: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);

329: l_RESP_APPL_ID fnd_user_resp_groups.responsibility_application_id%TYPE ;
330:
331: BEGIN
332: -- get the profile value that is set for checking if workflow is installed
333: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);
334:
335: -- if workflow is installed then carry on with the raising an event
336: IF (RTRIM(l_wf_installed) ='Y') THEN
337:

Line 352: l_USER_ID := FND_PROFILE.VALUE('USER_ID');

348: END LOOP ;
349:
350:
351: IF l_USER_ID IS NULL OR l_RESP_ID IS NULL OR l_RESP_APPL_ID IS NULL THEN
352: l_USER_ID := FND_PROFILE.VALUE('USER_ID');
353: l_RESP_ID := FND_PROFILE.VALUE('RESP_ID');
354: l_RESP_APPL_ID := FND_PROFILE.VALUE('RESP_APPL_ID');
355: END IF;
356:

Line 353: l_RESP_ID := FND_PROFILE.VALUE('RESP_ID');

349:
350:
351: IF l_USER_ID IS NULL OR l_RESP_ID IS NULL OR l_RESP_APPL_ID IS NULL THEN
352: l_USER_ID := FND_PROFILE.VALUE('USER_ID');
353: l_RESP_ID := FND_PROFILE.VALUE('RESP_ID');
354: l_RESP_APPL_ID := FND_PROFILE.VALUE('RESP_APPL_ID');
355: END IF;
356:
357:

Line 354: l_RESP_APPL_ID := FND_PROFILE.VALUE('RESP_APPL_ID');

350:
351: IF l_USER_ID IS NULL OR l_RESP_ID IS NULL OR l_RESP_APPL_ID IS NULL THEN
352: l_USER_ID := FND_PROFILE.VALUE('USER_ID');
353: l_RESP_ID := FND_PROFILE.VALUE('RESP_ID');
354: l_RESP_APPL_ID := FND_PROFILE.VALUE('RESP_APPL_ID');
355: END IF;
356:
357:
358: --