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 3811: l_newline := FND_GLOBAL.newline;

3807: FROM wf_item_activity_statuses
3808: WHERE notification_id = document_id;
3809:
3810: BEGIN
3811: l_newline := FND_GLOBAL.newline;
3812: l_msg_count := FND_MSG_PUB.Count_Msg;
3813: OPEN l_nf_csr;
3814: FETCH l_nf_csr INTO l_item_type, l_item_key;
3815: IF l_nf_csr%NOTFOUND THEN

Line 4511: l_wf_started_by_id := FND_GLOBAL.user_id;

4507: SELECT pa_prm_wf_item_key_s.nextval
4508: INTO l_itemkey
4509: FROM dual;
4510:
4511: l_wf_started_by_id := FND_GLOBAL.user_id;
4512: l_responsibility_id := FND_GLOBAL.resp_id;
4513: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
4514:
4515: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

Line 4512: l_responsibility_id := FND_GLOBAL.resp_id;

4508: INTO l_itemkey
4509: FROM dual;
4510:
4511: l_wf_started_by_id := FND_GLOBAL.user_id;
4512: l_responsibility_id := FND_GLOBAL.resp_id;
4513: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
4514:
4515: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
4516: , resp_id => l_responsibility_id

Line 4513: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

4509: FROM dual;
4510:
4511: l_wf_started_by_id := FND_GLOBAL.user_id;
4512: l_responsibility_id := FND_GLOBAL.resp_id;
4513: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
4514:
4515: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
4516: , resp_id => l_responsibility_id
4517: , resp_appl_id => l_resp_appl_id );

Line 4515: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

4511: l_wf_started_by_id := FND_GLOBAL.user_id;
4512: l_responsibility_id := FND_GLOBAL.resp_id;
4513: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
4514:
4515: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
4516: , resp_id => l_responsibility_id
4517: , resp_appl_id => l_resp_appl_id );
4518:
4519: -- Setting thresold value to run the process in background

Line 5033: l_wf_started_by_id := FND_GLOBAL.user_id;

5029:
5030: --------------------------------------
5031: --Start Resource Notification workflow
5032: --------------------------------------
5033: l_wf_started_by_id := FND_GLOBAL.user_id;
5034: l_responsibility_id := FND_GLOBAL.resp_id;
5035: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
5036:
5037: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

Line 5034: l_responsibility_id := FND_GLOBAL.resp_id;

5030: --------------------------------------
5031: --Start Resource Notification workflow
5032: --------------------------------------
5033: l_wf_started_by_id := FND_GLOBAL.user_id;
5034: l_responsibility_id := FND_GLOBAL.resp_id;
5035: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
5036:
5037: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
5038: , resp_id => l_responsibility_id

Line 5035: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

5031: --Start Resource Notification workflow
5032: --------------------------------------
5033: l_wf_started_by_id := FND_GLOBAL.user_id;
5034: l_responsibility_id := FND_GLOBAL.resp_id;
5035: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
5036:
5037: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
5038: , resp_id => l_responsibility_id
5039: , resp_appl_id => l_resp_appl_id );

Line 5037: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

5033: l_wf_started_by_id := FND_GLOBAL.user_id;
5034: l_responsibility_id := FND_GLOBAL.resp_id;
5035: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
5036:
5037: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
5038: , resp_id => l_responsibility_id
5039: , resp_appl_id => l_resp_appl_id );
5040:
5041: -- Setting thresold value to run the process in background

Line 6270: l_wf_started_by_id := FND_GLOBAL.user_id;

6266:
6267: --------------------------------------------------------
6268: --Start Notification Workflow for all manager recipients
6269: --------------------------------------------------------
6270: l_wf_started_by_id := FND_GLOBAL.user_id;
6271: l_responsibility_id := FND_GLOBAL.resp_id;
6272: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
6273:
6274: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

Line 6271: l_responsibility_id := FND_GLOBAL.resp_id;

6267: --------------------------------------------------------
6268: --Start Notification Workflow for all manager recipients
6269: --------------------------------------------------------
6270: l_wf_started_by_id := FND_GLOBAL.user_id;
6271: l_responsibility_id := FND_GLOBAL.resp_id;
6272: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
6273:
6274: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
6275: , resp_id => l_responsibility_id

Line 6272: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

6268: --Start Notification Workflow for all manager recipients
6269: --------------------------------------------------------
6270: l_wf_started_by_id := FND_GLOBAL.user_id;
6271: l_responsibility_id := FND_GLOBAL.resp_id;
6272: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
6273:
6274: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
6275: , resp_id => l_responsibility_id
6276: , resp_appl_id => l_resp_appl_id );

Line 6274: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

6270: l_wf_started_by_id := FND_GLOBAL.user_id;
6271: l_responsibility_id := FND_GLOBAL.resp_id;
6272: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
6273:
6274: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
6275: , resp_id => l_responsibility_id
6276: , resp_appl_id => l_resp_appl_id );
6277:
6278: -- Setting thresold value to run the process in background

Line 7406: l_wf_started_by_id := FND_GLOBAL.user_id;

7402: END IF;
7403: --------------------------------------
7404: --Start Submitter Notification workflow
7405: --------------------------------------
7406: l_wf_started_by_id := FND_GLOBAL.user_id;
7407: l_responsibility_id := FND_GLOBAL.resp_id;
7408: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
7409:
7410: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

Line 7407: l_responsibility_id := FND_GLOBAL.resp_id;

7403: --------------------------------------
7404: --Start Submitter Notification workflow
7405: --------------------------------------
7406: l_wf_started_by_id := FND_GLOBAL.user_id;
7407: l_responsibility_id := FND_GLOBAL.resp_id;
7408: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
7409:
7410: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
7411: , resp_id => l_responsibility_id

Line 7408: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

7404: --Start Submitter Notification workflow
7405: --------------------------------------
7406: l_wf_started_by_id := FND_GLOBAL.user_id;
7407: l_responsibility_id := FND_GLOBAL.resp_id;
7408: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
7409:
7410: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
7411: , resp_id => l_responsibility_id
7412: , resp_appl_id => l_resp_appl_id );

Line 7410: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id

7406: l_wf_started_by_id := FND_GLOBAL.user_id;
7407: l_responsibility_id := FND_GLOBAL.resp_id;
7408: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
7409:
7410: FND_GLOBAL.Apps_Initialize ( user_id => l_wf_started_by_id
7411: , resp_id => l_responsibility_id
7412: , resp_appl_id => l_resp_appl_id );
7413:
7414: -- Setting thresold value to run the process in background