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_PROJECTS_ALL

Line 600: l_project_id PA_PROJECTS_ALL.project_id%TYPE;

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);
604:

Line 612: cursor new_name_valid(p_project_id PA_PROJECTS_ALL.project_id%TYPE,

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:
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

Line 1902: from pa_projects_all

1898: )
1899: IS
1900: CURSOR get_calendar_id IS
1901: select CALENDAR_ID
1902: from pa_projects_all
1903: where project_id = p_project_id;
1904: l_cal_id NUMBER;
1905:
1906: CURSOR get_hrs_per_day IS

Line 3149: from pa_projects_all ppa,

3145: p_structure_version_id IN NUMBER
3146: ) return VARCHAR2 IS
3147: cursor c1 IS
3148: select ppa.project_id, ppa.template_flag
3149: from pa_projects_all ppa,
3150: pa_proj_element_versions ppev
3151: where ppev.element_version_id = p_structure_version_id
3152: and ppev.project_id = ppa.project_id;
3153: l_project_id NUMBER;

Line 3253: p_project_id IN pa_projects_all.project_id%TYPE

3249:
3250: -- Bug 3010538
3251: -- This function will return the process_update_wbs_flag of the structure version.
3252: FUNCTION GET_UPDATE_WBS_FLAG(
3253: p_project_id IN pa_projects_all.project_id%TYPE
3254: ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
3255: )
3256: return VARCHAR2 IS
3257: -- This cursor gets the process_update_wbs_flag for the structure version.

Line 3258: cursor cur_update_wbs_flag(c_project_id pa_projects_all.project_id%TYPE,

3254: ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
3255: )
3256: return VARCHAR2 IS
3257: -- This cursor gets the process_update_wbs_flag for the structure version.
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

Line 3280: p_project_id IN pa_projects_all.project_id%TYPE

3276: -- This is a function that returns the status of the cocurrent program for any
3277: -- particular structure version. If the process code is null, the function returns
3278: -- null and the caller has to do suitable null handling.
3279: FUNCTION GET_PROCESS_STATUS_CODE(
3280: p_project_id IN pa_projects_all.project_id%TYPE
3281: ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
3282: )
3283: return VARCHAR2 IS
3284: -- This cursor fetches the process code for the structure version.

Line 3285: cursor cur_process_code(c_project_id pa_projects_all.project_id%TYPE,

3281: ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
3282: )
3283: return VARCHAR2 IS
3284: -- This cursor fetches the process code for the structure version.
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

Line 3396: p_project_id IN pa_projects_all.project_id%TYPE

3392: -- and return the status code of the only structure version that can be either in status WUP / WUE.
3393: -- If none of the structure versions are in the above mentioned statuses, the function will return NULL.
3394:
3395: FUNCTION GET_PROCESS_STATUS_CODE(
3396: p_project_id IN pa_projects_all.project_id%TYPE
3397: ,p_structure_type IN pa_structure_types.structure_type%TYPE
3398: )
3399: return VARCHAR2 IS
3400: -- This cursor fetches the process code of WUP or WUE if the process is in

Line 3402: Cursor cur_proc_ver(c_project_id pa_projects_all.project_id%TYPE,

3398: )
3399: return VARCHAR2 IS
3400: -- This cursor fetches the process code of WUP or WUE if the process is in
3401: -- progress for any of the structure versions or if the process has errored out.
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,

Line 3431: select TEMPLATE_FLAG from pa_projects_all where project_id = p_project_id;

3427:
3428: function GET_FIN_STRUC_VER_ID(p_project_id IN NUMBER) return NUMBER
3429: IS
3430: cursor projOrTemp IS
3431: select TEMPLATE_FLAG from pa_projects_all where project_id = p_project_id;
3432: l_template_flag VARCHAR2(1);
3433:
3434: l_struc_ver_id NUMBER;
3435: cursor getFinOnlyStrucVer(c_project_id NUMBER) IS

Line 3518: p_project_id IN pa_projects_all.project_id%TYPE

3514: -- type parameter is required as when the structure is split, there could be two
3515: -- concurrent programs running one for the FINANCIAL structure and the other for
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

Line 3533: cursor cur_request_details(c_project_id pa_projects_all.project_id%TYPE,

3529:
3530: -- This cursor returns the concurrent request id, process code and the
3531: -- structure version for which the concurrent request was launched - This
3532: -- currently could be in process or could have completed with errors.
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,

Line 3683: p_project_id IN pa_projects_all.project_id%TYPE

3679: -- structure_type. The structure type parameter is required as when the structure
3680: -- is split, there could be two concurrent programs running one for the FINANCIAL
3681: -- structure and the other for the WORKPLAN structure.
3682: FUNCTION GET_CONC_REQUEST_ID(
3683: p_project_id IN pa_projects_all.project_id%TYPE
3684: ,p_structure_type IN pa_structure_types.structure_type%TYPE
3685: )
3686: return NUMBER IS
3687: -- This cursor returns the concurrent request id, process code and the

Line 3690: cursor cur_request_details(c_project_id pa_projects_all.project_id%TYPE,

3686: return NUMBER IS
3687: -- This cursor returns the concurrent request id, process code and the
3688: -- structure version for which the concurrent request was launched - This
3689: -- currently could be in process or could have completed with errors.
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,

Line 3717: ,p_project_id IN pa_projects_all.project_id%TYPE -- Included for Performance Fix : 3968091

3713: --Below function is added for bug#3049157
3714:
3715: FUNCTION GET_STRUCT_CONC_ID(
3716: p_structure_version_id IN pa_proj_element_versions.parent_structure_version_id%TYPE
3717: ,p_project_id IN pa_projects_all.project_id%TYPE -- Included for Performance Fix : 3968091
3718: )
3719: return NUMBER IS
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 )

Line 3877: from pa_projects_all

3873: RETURN VARCHAR2
3874: IS
3875: CURSOR c1 IS
3876: select STRUCTURE_SHARING_CODE
3877: from pa_projects_all
3878: where project_id = p_project_id;
3879: l_sharing_code varchar2(30);
3880: BEGIN
3881: OPEN c1;

Line 4243: FROM pa_projects_all

4239: IS
4240: CURSOR chk_project(cp_project_id NUMBER)
4241: IS
4242: SELECT 'Y'
4243: FROM pa_projects_all
4244: WHERE project_id = cp_project_id;
4245: --
4246: l_dummy VARCHAR2(1) := 'N';
4247: --

Line 4265: p_project_id IN pa_projects_all.project_id%TYPE

4261: --
4262: -- Begin fix for Bug # 4373055.
4263:
4264: PROCEDURE GET_PROCESS_STATUS_MSG(
4265: p_project_id IN pa_projects_all.project_id%TYPE
4266: , p_structure_type IN pa_structure_types.structure_type%TYPE := NULL
4267: , p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE := NULL
4268: , p_context IN VARCHAR2 := NULL
4269: , x_message_name OUT NOCOPY VARCHAR2 -- 4537865

Line 4282: cursor cur_proc_ver(c_project_id pa_projects_all.project_id%TYPE

4278: on the structure version / structure type or a process has failed with errors on the structure version /
4279: structure type.
4280: */
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

Line 4294: cursor cur_process_code(c_project_id pa_projects_all.project_id%TYPE

4290: and pst.structure_type_id = st.structure_type_id
4291: and st.structure_type = c_structure_type
4292: and vs.process_code is not null; -- Fix for Bug # 4373055.
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

Line 4602: from pa_projects_all ppa

4598: is
4599:
4600: cursor cur_str_sharing_code(c_project_id NUMBER) is
4601: select ppa.structure_sharing_code
4602: from pa_projects_all ppa
4603: where ppa.project_id = c_project_id;
4604:
4605: l_str_sharing_code VARCHAR2(30) := null;
4606:

Line 4931: FROM pa_projects_all

4927:
4928: CURSOR cur_proj
4929: IS
4930: SELECT sys_program_flag
4931: FROM pa_projects_all
4932: WHERE project_id=p_project_id
4933: ;
4934: l_return_value VARCHAR2(1);
4935: BEGIN