APPS.PJI_REP_UTIL dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 77: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

73: PLAN_TYPE_CODE)
74: select bv.project_id , bv.budget_version_id
75: , DECODE ( NVL(bv.wp_version_flag, 'N')
76: , 'Y', bv.project_structure_version_id
77: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
78: ) wbs_struct_version_id
79: , NVL(bv.wp_version_flag, 'N')
80: , decode(bv.current_flag|| DECODE(bv.baselined_date, NULL, 'N', 'Y'),'YY','Y','N' )
81: , decode(bv.current_original_flag|| DECODE(bv.baselined_date, NULL, 'N', 'Y'),'YY','Y','N' )

Line 108: t_element_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(1008);

104: AND fpo.rbs_version_id = rvb.rbs_version_id
105: AND map.project_id = bv.project_id ;
106:
107:
108: t_element_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(1008);
109:
110: select proj_element_id into p_elem_id from pa_proj_element_versions
111: where element_version_id = t_element_version_id;
112:

Line 2088: SELECT pa_project_structure_utils.GET_FIN_STRUC_VER_ID(p_project_id)

2084: hdr.project_id = p.project_id
2085: AND hdr.plan_version_id = p_plan_version_id
2086: AND NVL(p.pjt_rollup_enabled_flag,0) = 'N'
2087: UNION ALL
2088: SELECT pa_project_structure_utils.GET_FIN_STRUC_VER_ID(p_project_id)
2089: FROM pa_projects_all p ,
2090: pa_budget_versions b
2091: WHERE p.project_id = p_project_id
2092: AND b.project_id = p.project_id

Line 3019: l_struct_sharing_code := Pa_Project_Structure_Utils.get_Structure_sharing_code(

3015: IF g_debug_mode = 'Y' THEN
3016: Pji_Utils.WRITE2LOG( 'get_work_plan_actual_version: begining', TRUE , g_proc);
3017: END IF;
3018:
3019: l_struct_sharing_code := Pa_Project_Structure_Utils.get_Structure_sharing_code(
3020: p_project_id=> p_project_id );
3021: -- SHARE_FULL
3022: -- SHARE_PARTIAL
3023: -- SPLIT_NO_MAPPING

Line 3419: l_struct_version_id := Pa_Project_Structure_Utils.GET_LATEST_WP_VERSION(p_project_id);

3415:
3416:
3417: /* Get the latest wp published version */
3418:
3419: l_struct_version_id := Pa_Project_Structure_Utils.GET_LATEST_WP_VERSION(p_project_id);
3420:
3421:
3422: /* If latest published version is null then get it from currenct working version */
3423:

Line 3427: l_struct_version_id := Pa_Project_Structure_Utils.get_current_working_ver_id(p_project_id);

3423:
3424:
3425: IF l_struct_version_id IS NULL THEN
3426:
3427: l_struct_version_id := Pa_Project_Structure_Utils.get_current_working_ver_id(p_project_id);
3428:
3429: END IF;
3430:
3431: x_struct_version_id := l_struct_version_id;

Line 4297: AND Pa_Project_Structure_Utils.Check_Struc_Ver_Published(ele.project_id,denorm.sub_id) <> c_published_flag;

4293: AND denorm.sup_id = c_wbs_version_id
4294: AND denorm.struct_type = 'PRG'
4295: AND denorm.struct_version_id IS NULL
4296: AND denorm.sub_emt_id = ele.proj_element_id
4297: AND Pa_Project_Structure_Utils.Check_Struc_Ver_Published(ele.project_id,denorm.sub_id) <> c_published_flag;
4298:
4299: l_msg_count NUMBER := 0;
4300: l_data VARCHAR2(2000);
4301: l_msg_data VARCHAR2(2000);

Line 5833: Pa_Project_Structure_Utils.GET_STRUCTURE_MSG(

5829: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5830: END IF;
5831:
5832: IF p_prg_flag = 'N' THEN
5833: Pa_Project_Structure_Utils.GET_STRUCTURE_MSG(
5834: p_project_id => p_project_id
5835: , p_structure_type => p_structure_type
5836: , p_structure_version_id => p_structure_version_id
5837: , x_message_name => x_message_name

Line 5855: Pa_Project_Structure_Utils.GET_STRUCTURE_MSG(

5851:
5852: LOOP
5853: FETCH struct_list INTO l_structure_version_id,l_project_id;
5854: EXIT WHEN struct_list%NOTFOUND;
5855: Pa_Project_Structure_Utils.GET_STRUCTURE_MSG(
5856: p_project_id => l_project_id
5857: , p_structure_type => p_structure_type
5858: , p_structure_version_id => l_structure_version_id
5859: , x_message_name => x_message_name