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 4494: FROM dual;

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

Line 5086: FROM dual;

5082:
5083: -- Create the unique item key to launch WF with
5084: SELECT pa_prm_wf_item_key_s.nextval
5085: INTO l_itemkey
5086: FROM dual;
5087:
5088: -- Create the WF process
5089: wf_engine.CreateProcess
5090: ( ItemType => l_wf_item_type

Line 5947: from dual) temp, */

5943: fnd_user fnd,
5944: pa_resources_denorm res,
5945: /* Commenting this for performance tuning Bug#2499051
5946: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5947: from dual) temp, */
5948: pa_project_assignments asgn,
5949: pa_wf_ntf_performers ntf,
5950: wf_roles wf,
5951: per_all_people_f per

Line 6293: FROM dual;

6289:
6290: -- Create the unique item key to launch WF with
6291: SELECT pa_prm_wf_item_key_s.nextval
6292: INTO l_itemkey
6293: FROM dual;
6294:
6295: -- Create the WF process
6296: wf_engine.CreateProcess
6297: ( ItemType => l_wf_item_type

Line 7065: FROM dual;

7061: FOR rec IN distinct_approvers LOOP
7062:
7063: SELECT PA_WF_NTF_PERFORMERS_S.nextval
7064: INTO l_approver_group_id
7065: FROM dual;
7066:
7067: /* Commented and altered as below for bug 5595003
7068: UPDATE pa_wf_ntf_performers
7069: SET approver_group_id = l_approver_group_id

Line 7409: FROM dual;

7405:
7406: -- Create the unique item key to launch WF with
7407: SELECT pa_prm_wf_item_key_s.nextval
7408: INTO l_itemkey
7409: FROM dual;
7410:
7411: log_message('The value of p_mode is:' || p_mode );
7412: log_message('The value of item_key is :' || l_itemkey );
7413: -----------------------------------------------------------------------------