eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 40: from pa_proj_element_versions v, pa_proj_elem_ver_structure s

36: and f.user_id = p_user_id;
37:
38: cursor get_lock_user(p_person_id NUMBER) IS
39: select '1'
40: from pa_proj_element_versions v, pa_proj_elem_ver_structure s
41: where v.element_version_id = p_structure_version_id
42: and v.project_id = s.project_id
43: and v.element_version_id = s.element_version_id
44: and (locked_by_person_id IS NULL

Line 212: select name from pa_proj_elem_ver_structure

208: ,p_structure_id IN NUMBER
209: ) return varchar2
210: IS
211: cursor c1 is
212: select name from pa_proj_elem_ver_structure
213: where project_id = p_project_id
214: and proj_element_id = p_structure_id
215: and name = p_structure_version_name;
216: c1_rec c1%rowtype;

Line 219: select name from pa_proj_elem_ver_structure

215: and name = p_structure_version_name;
216: c1_rec c1%rowtype;
217:
218: cursor c2 is
219: select name from pa_proj_elem_ver_structure
220: where project_id = p_project_id
221: and proj_element_id = p_structure_id
222: and name = p_structure_version_name
223: and pev_structure_id <> p_pev_structure_id;

Line 483: pa_proj_elem_ver_structure c

479: cursor get_other_unpub_ver IS
480: select b.element_version_id
481: from pa_proj_element_versions a,
482: pa_proj_element_versions b,
483: pa_proj_elem_ver_structure c
484: where a.element_version_id = p_structure_version_id
485: and a.project_id = b.project_id
486: and a.proj_element_id = b.proj_element_id
487: and b.element_version_id <> p_structure_version_id

Line 544: from pa_proj_elem_ver_structure

540: ) return VARCHAR2
541: IS
542: cursor c1 is
543: select '1'
544: from pa_proj_elem_ver_structure
545: where project_id = p_project_id
546: and element_version_id = p_structure_version_id
547: and status_code = 'STRUCTURE_PUBLISHED';
548: c1_rec c1%rowtype;

Line 597: l_name PA_PROJ_ELEM_VER_STRUCTURE.name%TYPE;

593: ,x_error_message_code OUT NOCOPY VARCHAR2 -- 4537865
594: )
595: IS
596: l_posA NUMBER;
597: l_name PA_PROJ_ELEM_VER_STRUCTURE.name%TYPE;
598: l_suffix NUMBER;
599: l_new_name PA_PROJ_ELEM_VER_STRUCTURE.name%TYPE;
600: l_project_id PA_PROJECTS_ALL.project_id%TYPE;
601: l_proj_element_id PA_PROJ_ELEMENTS.proj_element_id%TYPE;

Line 599: l_new_name PA_PROJ_ELEM_VER_STRUCTURE.name%TYPE;

595: IS
596: l_posA NUMBER;
597: l_name PA_PROJ_ELEM_VER_STRUCTURE.name%TYPE;
598: l_suffix NUMBER;
599: l_new_name PA_PROJ_ELEM_VER_STRUCTURE.name%TYPE;
600: l_project_id PA_PROJECTS_ALL.project_id%TYPE;
601: l_proj_element_id PA_PROJ_ELEMENTS.proj_element_id%TYPE;
602:
603: l_dummy VARCHAR2(1);

Line 607: from pa_proj_element_versions v, pa_proj_elem_ver_structure s

603: l_dummy VARCHAR2(1);
604:
605: cursor getname is
606: select s.name, v.project_id, v.proj_element_id
607: from pa_proj_element_versions v, pa_proj_elem_ver_structure s
608: where v.element_version_id = p_structure_version_id and
609: s.project_id = v.project_id and
610: s.element_version_id = v.element_version_id;
611:

Line 616: from pa_proj_elem_ver_structure

612: cursor new_name_valid(p_project_id PA_PROJECTS_ALL.project_id%TYPE,
613: p_structure_id PA_PROJ_ELEMENTS.proj_element_id%TYPE,
614: p_new_name VARCHAR2) is
615: select '1'
616: from pa_proj_elem_ver_structure
617: where project_id = p_project_id
618: and proj_element_id = p_structure_id
619: and name = p_new_name;
620: BEGIN

Line 744: -- pa_proj_elem_ver_structure pevs,

740: IF (p_check_id_flag = 'Y') THEN
741: select pev.element_version_id
742: into x_structure_version_id
743: from pa_proj_element_versions pev
744: -- pa_proj_elem_ver_structure pevs,
745: -- pa_proj_elements pe
746: where
747: -- pe.proj_element_id = p_structure_id
748: pev.element_version_id = p_structure_version_id;

Line 758: from pa_proj_elem_ver_structure pevs,

754: ELSE
755: --get by name
756: select pevs.element_version_id
757: into x_structure_version_id
758: from pa_proj_elem_ver_structure pevs,
759: pa_proj_elements pe
760: where pe.proj_element_id = p_structure_id
761: and pevs.project_id = pe.project_id
762: and pevs.proj_element_id = pe.proj_element_id

Line 901: pa_proj_elem_ver_structure s

897:
898: cursor get_lock_user IS
899: select s.locked_by_person_id
900: from pa_proj_element_versions v,
901: pa_proj_elem_ver_structure s
902: where v.element_version_id = p_structure_version_id
903: and v.project_id = s.project_id
904: and v.element_version_id = s.element_version_id;
905:

Line 991: pa_proj_elem_ver_structure s

987: --Cursor to get the locked by person id for a structure version
988: cursor get_lock_user IS
989: select s.locked_by_person_id
990: from pa_proj_element_versions v,
991: pa_proj_elem_ver_structure s
992: where v.element_version_id = p_structure_version_id
993: and v.project_id = s.project_id
994: and v.element_version_id = s.element_version_id;
995:

Line 997: l_locked_person_id pa_proj_elem_ver_structure.locked_by_person_id%TYPE;

993: and v.project_id = s.project_id
994: and v.element_version_id = s.element_version_id;
995:
996: l_person_id per_all_people_f.person_id%TYPE;
997: l_locked_person_id pa_proj_elem_ver_structure.locked_by_person_id%TYPE;
998:
999: l_module_name VARCHAR2(100) := 'pa.plsql.IS_STRUC_VER_LOCKED_BY_USER1';
1000: l_debug_mode varchar2(1);
1001:

Line 1172: from pa_proj_elem_ver_structure

1168: return VARCHAR2
1169: IS
1170: CURSOR c1 IS
1171: select '1'
1172: from pa_proj_elem_ver_structure
1173: where project_id = p_project_id
1174: and proj_element_id = p_structure_id
1175: and status_code = 'STRUCTURE_PUBLISHED';
1176: l_dummy VARCHAR2(1);

Line 1556: pa_proj_elem_ver_structure b

1552:
1553: CURSOR get_latest_pub_ver IS
1554: select b.element_version_id
1555: from pa_proj_element_versions a,
1556: pa_proj_elem_ver_structure b
1557: where a.project_id = b.project_id
1558: and a.element_version_id = p_structure_version_id
1559: and a.proj_element_id = b.proj_element_id
1560: and b.LATEST_EFF_PUBLISHED_FLAG = 'Y'

Line 2281: from pa_proj_elem_ver_structure str,

2277: ) return NUMBER
2278: IS
2279: CURSOR c1 IS
2280: select str.element_version_id
2281: from pa_proj_elem_ver_structure str,
2282: pa_proj_elements ppe
2283: where ppe.proj_element_id = p_structure_id
2284: and ppe.project_id = str.project_id
2285: and ppe.proj_element_id = str.proj_element_id

Line 2292: pa_proj_elem_ver_structure c

2288: CURSOR c1 IS
2289: SELECT MAX(a.last_update_date), b.parent_structure_version_id
2290: FROM pa_proj_element_versions b,
2291: pa_proj_elem_ver_schedule a,
2292: pa_proj_elem_ver_structure c
2293: WHERE a.element_version_id (+)= b.element_version_id
2294: AND a.project_id (+) = b.project_id
2295: AND a.proj_element_id (+) = b.proj_element_id
2296: AND b.parent_structure_version_id = c.element_version_id

Line 2477: pa_proj_elem_ver_structure b

2473: IS
2474: CURSOR c1 IS
2475: select 1
2476: from pa_proj_elements a,
2477: pa_proj_elem_ver_structure b
2478: where a.proj_element_id = p_proj_element_id
2479: and a.project_id = b.project_id
2480: and a.proj_element_id = b.proj_element_id
2481: and b.status_code <> 'STRUCTURE_PUBLISHED';

Line 2632: pa_proj_elem_ver_structure ppevs

2628: select ppevs.element_version_id
2629: from pa_proj_elements ppe,
2630: pa_proj_structure_types ppst,
2631: pa_structure_types pst,
2632: pa_proj_elem_ver_structure ppevs
2633: where ppe.project_id = p_project_id
2634: and ppe.proj_element_id = ppst.proj_element_id
2635: and ppe.project_id = ppevs.project_id
2636: and ppe.proj_element_id = ppevs.proj_element_id

Line 2652: pa_proj_elem_ver_structure ppevs

2648: select ppevs.element_version_id
2649: from pa_proj_elements ppe,
2650: pa_proj_structure_types ppst,
2651: pa_structure_types pst,
2652: pa_proj_elem_ver_structure ppevs
2653: where ppe.project_id = p_project_id
2654: and ppe.proj_element_id = ppst.proj_element_id
2655: and ppe.project_id = ppevs.project_id
2656: and ppe.proj_element_id = ppevs.proj_element_id

Line 2735: pa_proj_elem_ver_structure ppevs

2731: select ppevs.element_version_id
2732: from pa_proj_elements ppe,
2733: pa_proj_structure_types ppst,
2734: pa_structure_types pst,
2735: pa_proj_elem_ver_structure ppevs
2736: where ppe.project_id = p_project_id
2737: and ppe.proj_element_id = ppst.proj_element_id
2738: and ppe.project_id = ppevs.project_id
2739: and ppe.proj_element_id = ppevs.proj_element_id

Line 2784: from pa_proj_elem_ver_structure

2780: where element_version_id = p_structure_version_id;
2781:
2782: CURSOR c2 IS
2783: select count(1)
2784: from pa_proj_elem_ver_structure
2785: where project_Id = l_project_id
2786: and proj_element_id = l_structure_id
2787: and status_code <> 'STRUCTURE_PUBLISHED';
2788:

Line 3090: from pa_proj_elem_ver_structure

3086: ) return NUMBER
3087: IS
3088: CURSOR c1 IS
3089: select count(1)
3090: from pa_proj_elem_ver_structure
3091: where project_id = p_project_id
3092: and proj_element_id =
3093: (select proj_element_id
3094: from pa_proj_element_versions

Line 3129: FROM pa_proj_elem_ver_structure

3125:
3126: CURSOR cur_pa_proj_elem_ver_str
3127: IS
3128: SELECT status_code
3129: FROM pa_proj_elem_ver_structure
3130: WHERE project_id = p_project_id
3131: AND element_version_id = p_structure_version_id;
3132: l_str_status_code VARCHAR2(150);
3133: BEGIN

Line 3158: from pa_proj_elem_ver_structure

3154: l_template_flag VARCHAR2(1);
3155:
3156: cursor c2 IS
3157: select 1
3158: from pa_proj_elem_ver_structure
3159: where project_id = l_project_id
3160: and element_version_id = p_structure_version_id
3161: and status_code = 'STRUCTURE_WORKING';
3162: l_dummy NUMBER;

Line 3262: from pa_proj_elem_ver_structure

3258: cursor cur_update_wbs_flag(c_project_id pa_projects_all.project_id%TYPE,
3259: c_structure_version_id pa_proj_element_versions.element_version_id%TYPE)
3260: IS
3261: select process_update_wbs_flag
3262: from pa_proj_elem_ver_structure
3263: where project_id = c_project_id
3264: and element_version_id = c_structure_version_id;
3265:
3266: l_update_wbs_flag pa_proj_elem_ver_structure.process_update_wbs_flag%TYPE;

Line 3266: l_update_wbs_flag pa_proj_elem_ver_structure.process_update_wbs_flag%TYPE;

3262: from pa_proj_elem_ver_structure
3263: where project_id = c_project_id
3264: and element_version_id = c_structure_version_id;
3265:
3266: l_update_wbs_flag pa_proj_elem_ver_structure.process_update_wbs_flag%TYPE;
3267: BEGIN
3268: OPEN cur_update_wbs_flag(p_project_id,p_structure_version_id);
3269: fetch cur_update_wbs_flag into l_update_wbs_flag;
3270: close cur_update_wbs_flag;

Line 3289: from pa_proj_elem_ver_structure

3285: cursor cur_process_code(c_project_id pa_projects_all.project_id%TYPE,
3286: c_structure_version_id pa_proj_element_versions.element_version_id%TYPE)
3287: is
3288: select process_code
3289: from pa_proj_elem_ver_structure
3290: where project_id = c_project_id
3291: and element_version_id = c_structure_version_id;
3292: l_process_code pa_proj_elem_ver_structure.process_code%TYPE;
3293: BEGIN

Line 3292: l_process_code pa_proj_elem_ver_structure.process_code%TYPE;

3288: select process_code
3289: from pa_proj_elem_ver_structure
3290: where project_id = c_project_id
3291: and element_version_id = c_structure_version_id;
3292: l_process_code pa_proj_elem_ver_structure.process_code%TYPE;
3293: BEGIN
3294: open cur_process_code(p_project_id,p_structure_version_id);
3295: fetch cur_process_code into l_process_code;
3296: close cur_process_code;

Line 3406: from pa_proj_elem_ver_structure vs,

3402: Cursor cur_proc_ver(c_project_id pa_projects_all.project_id%TYPE,
3403: c_structure_type pa_structure_types.structure_type%TYPE)
3404: is
3405: select vs.process_code
3406: from pa_proj_elem_ver_structure vs,
3407: pa_proj_structure_types pst,
3408: pa_structure_types st
3409: where
3410: vs.project_id = c_project_id

Line 3520: ,x_request_id OUT NOCOPY pa_proj_elem_ver_structure.conc_request_id%TYPE -- 4537865

3516: -- the WORKPLAN structure.
3517: PROCEDURE GET_CONC_REQUEST_DETAILS(
3518: p_project_id IN pa_projects_all.project_id%TYPE
3519: ,p_structure_type IN pa_structure_types.structure_type%TYPE
3520: ,x_request_id OUT NOCOPY pa_proj_elem_ver_structure.conc_request_id%TYPE -- 4537865
3521: ,x_process_code OUT NOCOPY pa_proj_elem_ver_structure.process_code%TYPE -- 4537865
3522: ,x_structure_version_id OUT NOCOPY pa_proj_elem_ver_structure.element_version_id%TYPE -- 4537865
3523: ,x_return_status OUT NOCOPY VARCHAR2 -- 4537865
3524: ,x_msg_count OUT NOCOPY NUMBER -- 4537865

Line 3521: ,x_process_code OUT NOCOPY pa_proj_elem_ver_structure.process_code%TYPE -- 4537865

3517: PROCEDURE GET_CONC_REQUEST_DETAILS(
3518: p_project_id IN pa_projects_all.project_id%TYPE
3519: ,p_structure_type IN pa_structure_types.structure_type%TYPE
3520: ,x_request_id OUT NOCOPY pa_proj_elem_ver_structure.conc_request_id%TYPE -- 4537865
3521: ,x_process_code OUT NOCOPY pa_proj_elem_ver_structure.process_code%TYPE -- 4537865
3522: ,x_structure_version_id OUT NOCOPY pa_proj_elem_ver_structure.element_version_id%TYPE -- 4537865
3523: ,x_return_status OUT NOCOPY VARCHAR2 -- 4537865
3524: ,x_msg_count OUT NOCOPY NUMBER -- 4537865
3525: ,x_msg_data OUT NOCOPY VARCHAR2 -- 4537865

Line 3522: ,x_structure_version_id OUT NOCOPY pa_proj_elem_ver_structure.element_version_id%TYPE -- 4537865

3518: p_project_id IN pa_projects_all.project_id%TYPE
3519: ,p_structure_type IN pa_structure_types.structure_type%TYPE
3520: ,x_request_id OUT NOCOPY pa_proj_elem_ver_structure.conc_request_id%TYPE -- 4537865
3521: ,x_process_code OUT NOCOPY pa_proj_elem_ver_structure.process_code%TYPE -- 4537865
3522: ,x_structure_version_id OUT NOCOPY pa_proj_elem_ver_structure.element_version_id%TYPE -- 4537865
3523: ,x_return_status OUT NOCOPY VARCHAR2 -- 4537865
3524: ,x_msg_count OUT NOCOPY NUMBER -- 4537865
3525: ,x_msg_data OUT NOCOPY VARCHAR2 -- 4537865
3526: )

Line 3537: from pa_proj_elem_ver_structure vs,

3533: cursor cur_request_details(c_project_id pa_projects_all.project_id%TYPE,
3534: c_structure_type pa_structure_types.structure_type%TYPE)
3535: IS
3536: select vs.conc_request_id, vs.process_code, vs.element_version_id
3537: from pa_proj_elem_ver_structure vs,
3538: pa_proj_structure_types pst,
3539: pa_structure_types st
3540: where vs.project_id = c_project_id
3541: and vs.process_code in ('WUP','WUE')

Line 3694: from pa_proj_elem_ver_structure vs,

3690: cursor cur_request_details(c_project_id pa_projects_all.project_id%TYPE,
3691: c_structure_type pa_structure_types.structure_type%TYPE)
3692: IS
3693: select vs.conc_request_id
3694: from pa_proj_elem_ver_structure vs,
3695: pa_proj_structure_types pst,
3696: pa_structure_types st
3697: where vs.project_id = c_project_id
3698: and vs.process_code in ('WUP','WUE')

Line 3703: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;

3699: and pst.PROJ_ELEMENT_ID = vs.proj_element_id
3700: and pst.structure_type_id = st.structure_type_id
3701: and st.structure_type = c_structure_type;
3702:
3703: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
3704:
3705: BEGIN
3706: open cur_request_details(p_project_id,p_structure_type);
3707: fetch cur_request_details into l_request_id;

Line 3724: from pa_proj_elem_ver_structure vs

3720: -- Returns the conc. request id for the structure version id .
3721: cursor cur_request_details(c_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE )
3722: IS
3723: select vs.conc_request_id
3724: from pa_proj_elem_ver_structure vs
3725: where vs.element_version_id = c_structure_version_id
3726: and vs.project_id = p_project_id ; -- Included for Performance Fix : 3968091
3727:
3728: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;

Line 3728: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;

3724: from pa_proj_elem_ver_structure vs
3725: where vs.element_version_id = c_structure_version_id
3726: and vs.project_id = p_project_id ; -- Included for Performance Fix : 3968091
3727:
3728: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
3729: BEGIN
3730: open cur_request_details(p_structure_version_id);
3731: fetch cur_request_details into l_request_id;
3732: close cur_request_details;

Line 3788: pa_proj_elem_ver_structure ppevs

3784: SELECT ppevs.element_version_id
3785: FROM pa_proj_elements ppe,
3786: pa_proj_structure_types ppst,
3787: pa_structure_types pst,
3788: pa_proj_elem_ver_structure ppevs
3789: WHERE ppe.project_id = p_project_id
3790: AND ppe.proj_element_id = ppst.proj_element_id
3791: AND ppe.project_id = ppevs.project_id
3792: AND ppe.proj_element_id = ppevs.proj_element_id

Line 3950: pa_proj_elem_ver_structure c

3946: CURSOR c1 IS
3947: SELECT MAX(a.last_update_date), b.parent_structure_version_id
3948: FROM pa_proj_element_versions b,
3949: pa_proj_elem_ver_schedule a,
3950: pa_proj_elem_ver_structure c
3951: WHERE a.element_version_id (+)= b.element_version_id
3952: AND a.project_id (+) = b.project_id
3953: AND a.proj_element_id (+) = b.proj_element_id
3954: AND b.parent_structure_version_id = c.element_version_id

Line 3979: select process_update_wbs_flag from pa_proj_elem_ver_structure

3975: where element_version_id = p_structure_version_id;
3976: l_proj_id NUMBER;
3977:
3978: CURSOR c2(c_project_id NUMBER) IS
3979: select process_update_wbs_flag from pa_proj_elem_ver_structure
3980: where project_id = c_project_id and element_version_id = p_structure_Version_id;
3981: l_flag VARCHAR2(1);
3982: BEGIN
3983: OPEN c1;

Line 4009: pa_proj_elem_ver_structure ppevs,

4005: /* CURSOR get_baseline_wp_ver(cp_proj_id NUMBER) IS
4006: SELECT ppev.element_version_id
4007: FROM pa_proj_elements ppe,
4008: pa_proj_element_versions ppev,
4009: pa_proj_elem_ver_structure ppevs,
4010: pa_proj_structure_types ppst,
4011: pa_structure_types pst
4012: WHERE ppe.proj_element_id = ppev.proj_element_id
4013: AND ppe.project_id = ppev.project_id

Line 4026: pa_proj_elem_ver_structure ppevs,

4022: CURSOR get_baseline_wp_ver(cp_proj_id NUMBER) IS
4023: SELECT ppev.element_version_id
4024: FROM pa_proj_elements ppe,
4025: pa_proj_element_versions ppev,
4026: pa_proj_elem_ver_structure ppevs,
4027: pa_proj_structure_types ppst,
4028: pa_structure_types pst
4029: WHERE ppe.proj_element_id = ppev.proj_element_id
4030: AND ppe.project_id = ppev.project_id

Line 4064: FROM pa_proj_elem_ver_structure

4060: IS
4061: --
4062: CURSOR get_sch_dirty_fl(cp_project_id NUMBER,cp_structure_version_id NUMBER) IS
4063: SELECT schedule_dirty_flag
4064: FROM pa_proj_elem_ver_structure
4065: WHERE project_id = cp_project_id
4066: AND element_version_id = cp_structure_version_id;
4067: l_dirty_flag pa_proj_elem_ver_structure.schedule_dirty_flag%TYPE;
4068: --

Line 4067: l_dirty_flag pa_proj_elem_ver_structure.schedule_dirty_flag%TYPE;

4063: SELECT schedule_dirty_flag
4064: FROM pa_proj_elem_ver_structure
4065: WHERE project_id = cp_project_id
4066: AND element_version_id = cp_structure_version_id;
4067: l_dirty_flag pa_proj_elem_ver_structure.schedule_dirty_flag%TYPE;
4068: --
4069: BEGIN
4070: --
4071: OPEN get_sch_dirty_fl(p_project_id,p_structure_version_id);

Line 4285: from pa_proj_elem_ver_structure vs

4281:
4282: cursor cur_proc_ver(c_project_id pa_projects_all.project_id%TYPE
4283: , c_structure_type pa_structure_types.structure_type%TYPE) is
4284: select vs.process_code, vs.element_version_id, vs.conc_request_id
4285: from pa_proj_elem_ver_structure vs
4286: , pa_proj_structure_types pst
4287: , pa_structure_types st
4288: where vs.project_id = c_project_id
4289: and pst.PROJ_ELEMENT_ID = vs.proj_element_id

Line 4297: from pa_proj_elem_ver_structure

4293:
4294: cursor cur_process_code(c_project_id pa_projects_all.project_id%TYPE
4295: , c_structure_version_id pa_proj_element_versions.element_version_id%TYPE) is
4296: select process_code, element_version_id, conc_request_id
4297: from pa_proj_elem_ver_structure
4298: where project_id = c_project_id
4299: and element_version_id = c_structure_version_id;
4300:
4301: l_process_code FND_LOOKUPS.lookup_code%TYPE := null;

Line 4480: update pa_proj_elem_ver_structure

4476: BEGIN
4477:
4478: l_return_status := FND_API.G_RET_STS_SUCCESS;
4479:
4480: update pa_proj_elem_ver_structure
4481: set process_code = decode(p_calling_context, 'APPLY_PROGRESS', 'APP'
4482: , 'CONC_PUBLISH', 'PUP'
4483: , 'CONC_UPDATE', 'WUP'
4484: , 'ASGMT_PLAN_CHANGE', 'WUP'

Line 4520: update pa_proj_elem_ver_structure

4516: BEGIN
4517:
4518: l_return_status := FND_API.G_RET_STS_SUCCESS;
4519:
4520: update pa_proj_elem_ver_structure
4521: set process_code = decode(p_calling_context, 'APPLY_PROGRESS', 'APE'
4522: , 'CONC_PUBLISH', 'PUE'
4523: , 'CONC_UPDATE', 'WUE', null)
4524: , conc_request_id = p_conc_request_id

Line 4561: update pa_proj_elem_ver_structure

4557: BEGIN
4558:
4559: l_return_status := FND_API.G_RET_STS_SUCCESS;
4560: if p_process_code = 'PRE' then
4561: update pa_proj_elem_ver_structure
4562: set process_code = p_process_code
4563: , conc_request_id = p_conc_request_id
4564: where element_version_id = p_structure_version_id
4565: and project_id = p_project_id

Line 4568: update pa_proj_elem_ver_structure

4564: where element_version_id = p_structure_version_id
4565: and project_id = p_project_id
4566: and process_code is null;
4567: else
4568: update pa_proj_elem_ver_structure
4569: set process_code = NULL
4570: where project_id = p_project_id
4571: and process_code = 'PRE';
4572: end if;

Line 4609: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst, pa_structure_types pst

4605: l_str_sharing_code VARCHAR2(30) := null;
4606:
4607: cursor cur_proc_upd_flag(c_project_id NUMBER, c_structure_version_id VARCHAR2) is
4608: select ppevs.process_update_wbs_flag, ppevs.process_code
4609: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst, pa_structure_types pst
4610: where ppevs.proj_element_id = ppst.proj_element_id
4611: and ppst.structure_type_id = pst.structure_type_id
4612: and ppevs.project_id = c_project_id
4613: and ppevs.element_version_id = c_structure_version_id;

Line 4746: from pa_proj_elem_ver_structure ppevs

4742: l_wp_str VARCHAR2(30);
4743:
4744: cursor l_cur_ppevs(c_project_id NUMBER, c_str_ver_id NUMBER) is
4745: select ppevs.name, ppevs.pev_structure_id, ppevs.record_version_number
4746: from pa_proj_elem_ver_structure ppevs
4747: where ppevs.project_id = c_project_id
4748: and ppevs.element_version_id = c_str_ver_id;
4749:
4750: l_rec_ppevs l_cur_ppevs%rowtype;

Line 4843: from pa_proj_elem_ver_structure ppevs

4839: l_wp_str VARCHAR2(30);
4840:
4841: cursor l_cur_ppevs(c_project_id NUMBER, c_str_ver_id NUMBER) is
4842: select ppevs.name, ppevs.pev_structure_id, ppevs.record_version_number
4843: from pa_proj_elem_ver_structure ppevs
4844: where ppevs.project_id = c_project_id
4845: and ppevs.element_version_id = c_str_ver_id;
4846:
4847: l_rec_ppevs l_cur_ppevs%rowtype;

Line 4987: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;

4983: ,p_project_id IN NUMBER
4984: ) return VARCHAR2
4985: IS
4986: l_object_relationship_id NUMBER;
4987: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;
4988: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;
4989: l_version_name pa_proj_elem_ver_structure.name%TYPE;
4990: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;
4991:

Line 4988: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;

4984: ) return VARCHAR2
4985: IS
4986: l_object_relationship_id NUMBER;
4987: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;
4988: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;
4989: l_version_name pa_proj_elem_ver_structure.name%TYPE;
4990: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;
4991:
4992: -- Checks whether the published workplan structure version is part of a program

Line 4989: l_version_name pa_proj_elem_ver_structure.name%TYPE;

4985: IS
4986: l_object_relationship_id NUMBER;
4987: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;
4988: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;
4989: l_version_name pa_proj_elem_ver_structure.name%TYPE;
4990: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;
4991:
4992: -- Checks whether the published workplan structure version is part of a program
4993:

Line 4990: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;

4986: l_object_relationship_id NUMBER;
4987: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;
4988: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;
4989: l_version_name pa_proj_elem_ver_structure.name%TYPE;
4990: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;
4991:
4992: -- Checks whether the published workplan structure version is part of a program
4993:
4994: CURSOR link_exists_cur IS

Line 5018: FROM pa_proj_elem_ver_structure ppevs

5014: SELECT ppevs.current_flag,
5015: ppevs.LATEST_EFF_PUBLISHED_FLAG,
5016: ppevs.name,
5017: ppevs.version_number
5018: FROM pa_proj_elem_ver_structure ppevs
5019: WHERE ppevs.element_version_id = p_structure_version_id
5020: AND ppevs.project_id = p_project_id;
5021:
5022: BEGIN