DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on DUAL

Line 319: FROM dual;

315: x_msg_count := 0;
316: -- Create the unique item key to launch WF with
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;

Line 4509: FROM dual;

4505:
4506: -- Create the unique item key to launch WF with
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;

Line 5102: FROM dual;

5098:
5099: -- Create the unique item key to launch WF with
5100: SELECT pa_prm_wf_item_key_s.nextval
5101: INTO l_itemkey
5102: FROM dual;
5103:
5104: -- Create the WF process
5105: wf_engine.CreateProcess
5106: ( ItemType => l_wf_item_type

Line 5963: from dual) temp, */

5959: fnd_user fnd,
5960: pa_resources_denorm res,
5961: /* Commenting this for performance tuning Bug#2499051
5962: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5963: from dual) temp, */
5964: pa_project_assignments asgn,
5965: pa_wf_ntf_performers ntf,
5966: wf_roles wf,
5967: per_all_people_f per

Line 6309: FROM dual;

6305:
6306: -- Create the unique item key to launch WF with
6307: SELECT pa_prm_wf_item_key_s.nextval
6308: INTO l_itemkey
6309: FROM dual;
6310:
6311: -- Create the WF process
6312: wf_engine.CreateProcess
6313: ( ItemType => l_wf_item_type

Line 7081: FROM dual;

7077: FOR rec IN distinct_approvers LOOP
7078:
7079: SELECT PA_WF_NTF_PERFORMERS_S.nextval
7080: INTO l_approver_group_id
7081: FROM dual;
7082:
7083: /* Commented and altered as below for bug 5595003
7084: UPDATE pa_wf_ntf_performers
7085: SET approver_group_id = l_approver_group_id

Line 7425: FROM dual;

7421:
7422: -- Create the unique item key to launch WF with
7423: SELECT pa_prm_wf_item_key_s.nextval
7424: INTO l_itemkey
7425: FROM dual;
7426:
7427: log_message('The value of p_mode is:' || p_mode );
7428: log_message('The value of item_key is :' || l_itemkey );
7429: -----------------------------------------------------------------------------