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 3758: FROM pa_proj_elem_ver_structure a, -- Bug 16325665

3754: ) Return VARCHAR2
3755: IS
3756: CURSOR c1 IS
3757: SELECT 'Y'
3758: FROM pa_proj_elem_ver_structure a, -- Bug 16325665
3759: pa_proj_structure_types b,
3760: pa_structure_types c
3761: WHERE c.structure_type_class_code = 'DELIVERABLE'
3762: AND c.structure_type_id = b.structure_type_id

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 3975: pa_proj_elem_ver_structure c

3971: CURSOR c1 IS
3972: SELECT MAX(a.last_update_date), b.parent_structure_version_id
3973: FROM pa_proj_element_versions b,
3974: pa_proj_elem_ver_schedule a,
3975: pa_proj_elem_ver_structure c
3976: WHERE a.element_version_id (+)= b.element_version_id
3977: AND a.project_id (+) = b.project_id
3978: AND a.proj_element_id (+) = b.proj_element_id
3979: AND b.parent_structure_version_id = c.element_version_id

Line 4004: select process_update_wbs_flag from pa_proj_elem_ver_structure

4000: where element_version_id = p_structure_version_id;
4001: l_proj_id NUMBER;
4002:
4003: CURSOR c2(c_project_id NUMBER) IS
4004: select process_update_wbs_flag from pa_proj_elem_ver_structure
4005: where project_id = c_project_id and element_version_id = p_structure_Version_id;
4006: l_flag VARCHAR2(1);
4007: BEGIN
4008: OPEN c1;

Line 4034: pa_proj_elem_ver_structure ppevs,

4030: /* CURSOR get_baseline_wp_ver(cp_proj_id NUMBER) IS
4031: SELECT ppev.element_version_id
4032: FROM pa_proj_elements ppe,
4033: pa_proj_element_versions ppev,
4034: pa_proj_elem_ver_structure ppevs,
4035: pa_proj_structure_types ppst,
4036: pa_structure_types pst
4037: WHERE ppe.proj_element_id = ppev.proj_element_id
4038: AND ppe.project_id = ppev.project_id

Line 4051: pa_proj_elem_ver_structure ppevs,

4047: CURSOR get_baseline_wp_ver(cp_proj_id NUMBER) IS
4048: SELECT ppev.element_version_id
4049: FROM pa_proj_elements ppe,
4050: pa_proj_element_versions ppev,
4051: pa_proj_elem_ver_structure ppevs,
4052: pa_proj_structure_types ppst,
4053: pa_structure_types pst
4054: WHERE ppe.proj_element_id = ppev.proj_element_id
4055: AND ppe.project_id = ppev.project_id

Line 4089: FROM pa_proj_elem_ver_structure

4085: IS
4086: --
4087: CURSOR get_sch_dirty_fl(cp_project_id NUMBER,cp_structure_version_id NUMBER) IS
4088: SELECT schedule_dirty_flag
4089: FROM pa_proj_elem_ver_structure
4090: WHERE project_id = cp_project_id
4091: AND element_version_id = cp_structure_version_id;
4092: l_dirty_flag pa_proj_elem_ver_structure.schedule_dirty_flag%TYPE;
4093: --

Line 4092: l_dirty_flag pa_proj_elem_ver_structure.schedule_dirty_flag%TYPE;

4088: SELECT schedule_dirty_flag
4089: FROM pa_proj_elem_ver_structure
4090: WHERE project_id = cp_project_id
4091: AND element_version_id = cp_structure_version_id;
4092: l_dirty_flag pa_proj_elem_ver_structure.schedule_dirty_flag%TYPE;
4093: --
4094: BEGIN
4095: --
4096: OPEN get_sch_dirty_fl(p_project_id,p_structure_version_id);

Line 4310: from pa_proj_elem_ver_structure vs

4306:
4307: cursor cur_proc_ver(c_project_id pa_projects_all.project_id%TYPE
4308: , c_structure_type pa_structure_types.structure_type%TYPE) is
4309: select vs.process_code, vs.element_version_id, vs.conc_request_id
4310: from pa_proj_elem_ver_structure vs
4311: , pa_proj_structure_types pst
4312: , pa_structure_types st
4313: where vs.project_id = c_project_id
4314: and pst.PROJ_ELEMENT_ID = vs.proj_element_id

Line 4322: from pa_proj_elem_ver_structure

4318:
4319: cursor cur_process_code(c_project_id pa_projects_all.project_id%TYPE
4320: , c_structure_version_id pa_proj_element_versions.element_version_id%TYPE) is
4321: select process_code, element_version_id, conc_request_id
4322: from pa_proj_elem_ver_structure
4323: where project_id = c_project_id
4324: and element_version_id = c_structure_version_id;
4325:
4326: l_process_code FND_LOOKUPS.lookup_code%TYPE := null;

Line 4505: update pa_proj_elem_ver_structure

4501: BEGIN
4502:
4503: l_return_status := FND_API.G_RET_STS_SUCCESS;
4504:
4505: update pa_proj_elem_ver_structure
4506: set process_code = decode(p_calling_context, 'APPLY_PROGRESS', 'APP'
4507: , 'CONC_PUBLISH', 'PUP'
4508: , 'CONC_UPDATE', 'WUP'
4509: , 'ASGMT_PLAN_CHANGE', 'WUP'

Line 4545: update pa_proj_elem_ver_structure

4541: BEGIN
4542:
4543: l_return_status := FND_API.G_RET_STS_SUCCESS;
4544:
4545: update pa_proj_elem_ver_structure
4546: set process_code = decode(p_calling_context, 'APPLY_PROGRESS', 'APE'
4547: , 'CONC_PUBLISH', 'PUE'
4548: , 'CONC_UPDATE', 'WUE', null)
4549: , conc_request_id = p_conc_request_id

Line 4586: update pa_proj_elem_ver_structure

4582: BEGIN
4583:
4584: l_return_status := FND_API.G_RET_STS_SUCCESS;
4585: if p_process_code = 'PRE' then
4586: update pa_proj_elem_ver_structure
4587: set process_code = p_process_code
4588: , conc_request_id = p_conc_request_id
4589: where element_version_id = p_structure_version_id
4590: and project_id = p_project_id

Line 4593: update pa_proj_elem_ver_structure

4589: where element_version_id = p_structure_version_id
4590: and project_id = p_project_id
4591: and process_code is null;
4592: else
4593: update pa_proj_elem_ver_structure
4594: set process_code = NULL
4595: where project_id = p_project_id
4596: and process_code = 'PRE';
4597: end if;

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

4630: l_str_sharing_code VARCHAR2(30) := null;
4631:
4632: cursor cur_proc_upd_flag(c_project_id NUMBER, c_structure_version_id VARCHAR2) is
4633: select ppevs.process_update_wbs_flag, ppevs.process_code
4634: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst, pa_structure_types pst
4635: where ppevs.proj_element_id = ppst.proj_element_id
4636: and ppst.structure_type_id = pst.structure_type_id
4637: and ppevs.project_id = c_project_id
4638: and ppevs.element_version_id = c_structure_version_id;

Line 4783: from pa_proj_elem_ver_structure ppevs

4779: l_wp_str VARCHAR2(30);
4780:
4781: cursor l_cur_ppevs(c_project_id NUMBER, c_str_ver_id NUMBER) is
4782: select ppevs.name, ppevs.pev_structure_id, ppevs.record_version_number
4783: from pa_proj_elem_ver_structure ppevs
4784: where ppevs.project_id = c_project_id
4785: and ppevs.element_version_id = c_str_ver_id;
4786:
4787: l_rec_ppevs l_cur_ppevs%rowtype;

Line 4880: from pa_proj_elem_ver_structure ppevs

4876: l_wp_str VARCHAR2(30);
4877:
4878: cursor l_cur_ppevs(c_project_id NUMBER, c_str_ver_id NUMBER) is
4879: select ppevs.name, ppevs.pev_structure_id, ppevs.record_version_number
4880: from pa_proj_elem_ver_structure ppevs
4881: where ppevs.project_id = c_project_id
4882: and ppevs.element_version_id = c_str_ver_id;
4883:
4884: l_rec_ppevs l_cur_ppevs%rowtype;

Line 5024: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;

5020: ,p_project_id IN NUMBER
5021: ) return VARCHAR2
5022: IS
5023: l_object_relationship_id NUMBER;
5024: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;
5025: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;
5026: l_version_name pa_proj_elem_ver_structure.name%TYPE;
5027: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;
5028:

Line 5025: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;

5021: ) return VARCHAR2
5022: IS
5023: l_object_relationship_id NUMBER;
5024: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;
5025: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;
5026: l_version_name pa_proj_elem_ver_structure.name%TYPE;
5027: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;
5028:
5029: -- Checks whether the published workplan structure version is part of a program

Line 5026: l_version_name pa_proj_elem_ver_structure.name%TYPE;

5022: IS
5023: l_object_relationship_id NUMBER;
5024: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;
5025: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;
5026: l_version_name pa_proj_elem_ver_structure.name%TYPE;
5027: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;
5028:
5029: -- Checks whether the published workplan structure version is part of a program
5030:

Line 5027: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;

5023: l_object_relationship_id NUMBER;
5024: l_current_flag pa_proj_elem_ver_structure.current_flag%TYPE;
5025: l_LATEST_EFF_PUBLISHED_FLAG pa_proj_elem_ver_structure.LATEST_EFF_PUBLISHED_FLAG%TYPE;
5026: l_version_name pa_proj_elem_ver_structure.name%TYPE;
5027: l_version_number pa_proj_elem_ver_structure.version_number%TYPE;
5028:
5029: -- Checks whether the published workplan structure version is part of a program
5030:
5031: CURSOR link_exists_cur IS

Line 5055: FROM pa_proj_elem_ver_structure ppevs

5051: SELECT ppevs.current_flag,
5052: ppevs.LATEST_EFF_PUBLISHED_FLAG,
5053: ppevs.name,
5054: ppevs.version_number
5055: FROM pa_proj_elem_ver_structure ppevs
5056: WHERE ppevs.element_version_id = p_structure_version_id
5057: AND ppevs.project_id = p_project_id;
5058:
5059: BEGIN

Line 5265: l_structure_id pa_proj_elem_ver_structure.proj_element_id%TYPE;

5261: l_msg_count NUMBER;
5262: l_return_status VARCHAR2(1);
5263: l_msg_data VARCHAR2(2000);
5264:
5265: l_structure_id pa_proj_elem_ver_structure.proj_element_id%TYPE;
5266: l_buffer pa_proj_workplan_attr.txn_date_sync_buf_days%TYPE;
5267:
5268: l_old_task_start_date DATE;
5269: l_old_task_finish_date DATE;

Line 5285: CURSOR get_buffer(c_structure_id pa_proj_elem_ver_structure.proj_element_id%TYPE)

5281: AND a.project_id = p_project_id
5282: AND b.structure_type_id = c.structure_type_id
5283: AND c.structure_type = 'WORKPLAN';
5284:
5285: CURSOR get_buffer(c_structure_id pa_proj_elem_ver_structure.proj_element_id%TYPE)
5286: IS
5287: SELECT NVL(txn_date_sync_buf_days, 0)
5288: FROM pa_proj_workplan_attr
5289: WHERE proj_element_id = c_structure_id;