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 3273: SELECT pa_proj_element_versions_s.nextval

3269: --end bug 3047602
3270:
3271: l_rowid VARCHAR2(255);
3272: CURSOR cur_elem_ver_seq IS
3273: SELECT pa_proj_element_versions_s.nextval
3274: FROM sys.dual;
3275:
3276: l_last_pub_str_ver_id NUMBER; --Bug No. 3450684 Smukka 01/03/2004
3277: l_chk_deliverable VARCHAR2(80); --Summuka For checking deliverables

Line 4721: pa_proj_element_versions_s.nextval

4717: ,source_object_type
4718: ,financial_task_flag
4719: )
4720: SELECT
4721: pa_proj_element_versions_s.nextval
4722: ,ppev.proj_element_id
4723: ,ppev.object_type
4724: ,l_project_id
4725: ,l_new_struct_ver_id

Line 13368: SELECT pa_proj_element_versions_s.nextval

13364: l_user_id number;
13365: l_login_id number;
13366:
13367: CURSOR cur_elem_ver_seq IS
13368: SELECT pa_proj_element_versions_s.nextval
13369: FROM sys.dual;
13370:
13371: l_wp_struc VARCHAR2(1);
13372: l_fin_struc VARCHAR2(1);

Line 13666: pa_proj_element_versions_s.nextval

13662: ,source_object_id
13663: ,source_object_type
13664: )
13665: SELECT
13666: pa_proj_element_versions_s.nextval
13667: ,ppev.proj_element_id
13668: ,ppev.object_type
13669: ,l_project_id
13670: ,l_new_struct_ver_id