DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on FND_GLOBAL

Line 321: l_wf_started_by_id := FND_GLOBAL.user_id;

317: SELECT pa_prm_wf_item_key_s.nextval
318: INTO l_itemkey
319: FROM dual;
320:
321: l_wf_started_by_id := FND_GLOBAL.user_id;
322: l_responsibility_id := FND_GLOBAL.resp_id;
323: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
324:
325: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

Line 322: l_responsibility_id := FND_GLOBAL.resp_id;

318: INTO l_itemkey
319: FROM dual;
320:
321: l_wf_started_by_id := FND_GLOBAL.user_id;
322: l_responsibility_id := FND_GLOBAL.resp_id;
323: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
324:
325: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
326: , resp_id => l_responsibility_id

Line 323: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

319: FROM dual;
320:
321: l_wf_started_by_id := FND_GLOBAL.user_id;
322: l_responsibility_id := FND_GLOBAL.resp_id;
323: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
324:
325: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
326: , resp_id => l_responsibility_id
327: , resp_appl_id => l_resp_appl_id );

Line 325: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

321: l_wf_started_by_id := FND_GLOBAL.user_id;
322: l_responsibility_id := FND_GLOBAL.resp_id;
323: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
324:
325: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
326: , resp_id => l_responsibility_id
327: , resp_appl_id => l_resp_appl_id );
328:
329: -- Setting thresold value to run the process in background

Line 665: , avalue => fnd_global.user_name

661: wf_engine.SetItemAttrText
662: ( itemtype => p_wf_item_type
663: , itemkey => l_itemkey
664: , aname => 'FROM_ROLE_VALUE'
665: , avalue => fnd_global.user_name
666: );*/
667:
668: wf_engine.SetItemAttrText
669: ( itemtype => p_wf_item_type

Line 1383: -- Get the current user_id using FND_GLOBAL.USER_ID

1379: , avalue => p_conflict_group_id
1380: );
1381:
1382: -- Set workflow started by attributes
1383: -- Get the current user_id using FND_GLOBAL.USER_ID
1384: -- Get the user name from the user id
1385: -- Set the workflow started by user name
1386: l_workflow_started_by_uname := FND_GLOBAL.USER_NAME;
1387: wf_engine.SetItemAttrText

Line 1386: l_workflow_started_by_uname := FND_GLOBAL.USER_NAME;

1382: -- Set workflow started by attributes
1383: -- Get the current user_id using FND_GLOBAL.USER_ID
1384: -- Get the user name from the user id
1385: -- Set the workflow started by user name
1386: l_workflow_started_by_uname := FND_GLOBAL.USER_NAME;
1387: wf_engine.SetItemAttrText
1388: ( itemtype => p_wf_item_type
1389: , itemkey => l_itemkey
1390: , aname => 'WORKFLOW_STARTED_BY_UNAME'

Line 3796: l_newline := FND_GLOBAL.newline;

3792: FROM wf_item_activity_statuses
3793: WHERE notification_id = document_id;
3794:
3795: BEGIN
3796: l_newline := FND_GLOBAL.newline;
3797: l_msg_count := FND_MSG_PUB.Count_Msg;
3798: OPEN l_nf_csr;
3799: FETCH l_nf_csr INTO l_item_type, l_item_key;
3800: IF l_nf_csr%NOTFOUND THEN

Line 4496: l_wf_started_by_id := FND_GLOBAL.user_id;

4492: SELECT pa_prm_wf_item_key_s.nextval
4493: INTO l_itemkey
4494: FROM dual;
4495:
4496: l_wf_started_by_id := FND_GLOBAL.user_id;
4497: l_responsibility_id := FND_GLOBAL.resp_id;
4498: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
4499:
4500: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

Line 4497: l_responsibility_id := FND_GLOBAL.resp_id;

4493: INTO l_itemkey
4494: FROM dual;
4495:
4496: l_wf_started_by_id := FND_GLOBAL.user_id;
4497: l_responsibility_id := FND_GLOBAL.resp_id;
4498: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
4499:
4500: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
4501: , resp_id => l_responsibility_id

Line 4498: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

4494: FROM dual;
4495:
4496: l_wf_started_by_id := FND_GLOBAL.user_id;
4497: l_responsibility_id := FND_GLOBAL.resp_id;
4498: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
4499:
4500: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
4501: , resp_id => l_responsibility_id
4502: , resp_appl_id => l_resp_appl_id );

Line 4500: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

4496: l_wf_started_by_id := FND_GLOBAL.user_id;
4497: l_responsibility_id := FND_GLOBAL.resp_id;
4498: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
4499:
4500: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
4501: , resp_id => l_responsibility_id
4502: , resp_appl_id => l_resp_appl_id );
4503:
4504: -- Setting thresold value to run the process in background

Line 5017: l_wf_started_by_id := FND_GLOBAL.user_id;

5013:
5014: --------------------------------------
5015: --Start Resource Notification workflow
5016: --------------------------------------
5017: l_wf_started_by_id := FND_GLOBAL.user_id;
5018: l_responsibility_id := FND_GLOBAL.resp_id;
5019: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
5020:
5021: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

Line 5018: l_responsibility_id := FND_GLOBAL.resp_id;

5014: --------------------------------------
5015: --Start Resource Notification workflow
5016: --------------------------------------
5017: l_wf_started_by_id := FND_GLOBAL.user_id;
5018: l_responsibility_id := FND_GLOBAL.resp_id;
5019: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
5020:
5021: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
5022: , resp_id => l_responsibility_id

Line 5019: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

5015: --Start Resource Notification workflow
5016: --------------------------------------
5017: l_wf_started_by_id := FND_GLOBAL.user_id;
5018: l_responsibility_id := FND_GLOBAL.resp_id;
5019: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
5020:
5021: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
5022: , resp_id => l_responsibility_id
5023: , resp_appl_id => l_resp_appl_id );

Line 5021: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

5017: l_wf_started_by_id := FND_GLOBAL.user_id;
5018: l_responsibility_id := FND_GLOBAL.resp_id;
5019: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
5020:
5021: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
5022: , resp_id => l_responsibility_id
5023: , resp_appl_id => l_resp_appl_id );
5024:
5025: -- Setting thresold value to run the process in background

Line 6254: l_wf_started_by_id := FND_GLOBAL.user_id;

6250:
6251: --------------------------------------------------------
6252: --Start Notification Workflow for all manager recipients
6253: --------------------------------------------------------
6254: l_wf_started_by_id := FND_GLOBAL.user_id;
6255: l_responsibility_id := FND_GLOBAL.resp_id;
6256: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
6257:
6258: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

Line 6255: l_responsibility_id := FND_GLOBAL.resp_id;

6251: --------------------------------------------------------
6252: --Start Notification Workflow for all manager recipients
6253: --------------------------------------------------------
6254: l_wf_started_by_id := FND_GLOBAL.user_id;
6255: l_responsibility_id := FND_GLOBAL.resp_id;
6256: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
6257:
6258: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
6259: , resp_id => l_responsibility_id

Line 6256: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

6252: --Start Notification Workflow for all manager recipients
6253: --------------------------------------------------------
6254: l_wf_started_by_id := FND_GLOBAL.user_id;
6255: l_responsibility_id := FND_GLOBAL.resp_id;
6256: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
6257:
6258: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
6259: , resp_id => l_responsibility_id
6260: , resp_appl_id => l_resp_appl_id );

Line 6258: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

6254: l_wf_started_by_id := FND_GLOBAL.user_id;
6255: l_responsibility_id := FND_GLOBAL.resp_id;
6256: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
6257:
6258: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
6259: , resp_id => l_responsibility_id
6260: , resp_appl_id => l_resp_appl_id );
6261:
6262: -- Setting thresold value to run the process in background

Line 7390: l_wf_started_by_id := FND_GLOBAL.user_id;

7386: END IF;
7387: --------------------------------------
7388: --Start Submitter Notification workflow
7389: --------------------------------------
7390: l_wf_started_by_id := FND_GLOBAL.user_id;
7391: l_responsibility_id := FND_GLOBAL.resp_id;
7392: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
7393:
7394: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

Line 7391: l_responsibility_id := FND_GLOBAL.resp_id;

7387: --------------------------------------
7388: --Start Submitter Notification workflow
7389: --------------------------------------
7390: l_wf_started_by_id := FND_GLOBAL.user_id;
7391: l_responsibility_id := FND_GLOBAL.resp_id;
7392: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
7393:
7394: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
7395: , resp_id => l_responsibility_id

Line 7392: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

7388: --Start Submitter Notification workflow
7389: --------------------------------------
7390: l_wf_started_by_id := FND_GLOBAL.user_id;
7391: l_responsibility_id := FND_GLOBAL.resp_id;
7392: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
7393:
7394: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
7395: , resp_id => l_responsibility_id
7396: , resp_appl_id => l_resp_appl_id );

Line 7394: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

7390: l_wf_started_by_id := FND_GLOBAL.user_id;
7391: l_responsibility_id := FND_GLOBAL.resp_id;
7392: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
7393:
7394: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
7395: , resp_id => l_responsibility_id
7396: , resp_appl_id => l_resp_appl_id );
7397:
7398: -- Setting thresold value to run the process in background