DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_PROJ_ELEMENT_VERSIONS_S

Line 668: SELECT pa_proj_element_versions_s.nextval

664: CURSOR getid is select project_id from pa_proj_elements
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

Line 3243: SELECT pa_proj_element_versions_s.nextval

3239: --end bug 3047602
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

Line 4661: pa_proj_element_versions_s.nextval

4657: ,source_object_type
4658: ,financial_task_flag
4659: )
4660: SELECT
4661: pa_proj_element_versions_s.nextval
4662: ,ppev.proj_element_id
4663: ,ppev.object_type
4664: ,l_project_id
4665: ,l_new_struct_ver_id

Line 12996: SELECT pa_proj_element_versions_s.nextval

12992: l_user_id number;
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);

Line 13294: pa_proj_element_versions_s.nextval

13290: ,source_object_id
13291: ,source_object_type
13292: )
13293: SELECT
13294: pa_proj_element_versions_s.nextval
13295: ,ppev.proj_element_id
13296: ,ppev.object_type
13297: ,l_project_id
13298: ,l_new_struct_ver_id