APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on DUAL

Line 336: select PA_TASKS_S.NEXTVAL into l_proj_element_id from sys.dual;

332: RAISE FND_API.G_EXC_ERROR;
333: END IF;
334:
335: --Insert into pa_proj_elements
336: select PA_TASKS_S.NEXTVAL into l_proj_element_id from sys.dual;
337:
338: PA_PROJ_ELEMENTS_PKG.insert_row(
339: X_ROW_ID => l_rowid
340: ,X_PROJ_ELEMENT_ID => l_proj_element_id

Line 669: FROM sys.dual;

665: where proj_element_id = p_structure_id;
666:
667: CURSOR cur_elem_ver_seq IS
668: SELECT pa_proj_element_versions_s.nextval
669: FROM sys.dual;
670:
671: BEGIN
672: IF (p_debug_mode = 'Y') THEN
673: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION begin');

Line 3244: FROM sys.dual;

3240:
3241: l_rowid VARCHAR2(255);
3242: CURSOR cur_elem_ver_seq IS
3243: SELECT pa_proj_element_versions_s.nextval
3244: FROM sys.dual;
3245:
3246: l_last_pub_str_ver_id NUMBER; --Bug No. 3450684 Smukka 01/03/2004
3247: l_chk_deliverable VARCHAR2(80); --Summuka For checking deliverables
3248:

Line 7994: select PA_TASKS_S.NEXTVAL into l_task_id from sys.dual;

7990: -- If (l_is_workplan = 'Y') AND (l_is_billing = 'N') AND (l_is_costing = 'N') THEN
7991: l_task_id := NULL;
7992: IF (l_structure_type = 'WORKPLAN') THEN
7993: --get new id
7994: select PA_TASKS_S.NEXTVAL into l_task_id from sys.dual;
7995: ELSE
7996: --id exists in pa_tasks. Need to find matching id by using task_number
7997: OPEN l_get_pa_tasks_csr(p_dest_project_id, l_tasks_rec.PA_TASK_NUMBER);
7998: FETCH l_get_pa_tasks_csr into l_task_id;

Line 8825: select 'Y' from dual

8821: and element_version_id = p_structure_version_id;
8822:
8823: /* Bug 2683138 */
8824: /* CURSOR get_start_wf IS
8825: select 'Y' from dual
8826: where exists (
8827: select 1 from pa_product_installation_v
8828: where product_short_code = 'PJT' AND INSTALLED_FLAG = 'Y'); */
8829:

Line 8831: select 'Y' from dual;

8827: select 1 from pa_product_installation_v
8828: where product_short_code = 'PJT' AND INSTALLED_FLAG = 'Y'); */
8829:
8830: CURSOR get_start_wf IS
8831: select 'Y' from dual;
8832:
8833: CURSOR get_wf_info(c_status_code VARCHAR2) IS
8834: select enable_wf_flag, workflow_item_type,
8835: workflow_process, wf_success_status_code,

Line 9130: select 'Y' from dual

9126: l_msg_data VARCHAR2(250);
9127:
9128: /* Bug 2683138 */
9129: /* CURSOR get_start_wf IS
9130: select 'Y' from dual
9131: where exists (
9132: select 1 from pa_product_installation_v
9133: where product_short_code = 'PJT' AND INSTALLED_FLAG = 'Y'); */
9134:

Line 9136: select 'Y' from dual;

9132: select 1 from pa_product_installation_v
9133: where product_short_code = 'PJT' AND INSTALLED_FLAG = 'Y'); */
9134:
9135: CURSOR get_start_wf IS
9136: select 'Y' from dual;
9137:
9138: CURSOR get_wf_info(c_status_code VARCHAR2) IS
9139: select enable_wf_flag, workflow_item_type,
9140: workflow_process, wf_success_status_code,

Line 12997: FROM sys.dual;

12993: l_login_id number;
12994:
12995: CURSOR cur_elem_ver_seq IS
12996: SELECT pa_proj_element_versions_s.nextval
12997: FROM sys.dual;
12998:
12999: l_wp_struc VARCHAR2(1);
13000: l_fin_struc VARCHAR2(1);
13001: