DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 3147: SELECT PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

3143:
3144: ELSIF ( (p_context IN ('BASELINE', 'ORIGINAL') )
3145: AND (l_fp_version_ids(l_count) > 0)) THEN -- 2
3146:
3147: SELECT PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3148: INTO l_wbs_version_id
3149: FROM pa_budget_versions bv
3150: WHERE budget_version_id = l_fp_version_ids(l_count);
3151:

Line 3190: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id

3186: )
3187: SELECT -- DISTINCT
3188: den.sup_project_id project_id
3189: , cbco.plan_version_id -- bv.budget_version_id -- -3 --
3190: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
3191: , bv.rbs_struct_version_id
3192: , bv.plan_type_code
3193: , bv.plan_type_id
3194: , bv.time_phased_type_code

Line 4267: l_struct_sharing_code := Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);

4263: END IF;
4264: l_prg_event_id:=null;
4265: END;
4266:
4267: l_struct_sharing_code := Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);
4268: IF l_old_wbs_version_id IS NULL THEN
4269: -- Fix for bug : 4191390
4270: If l_struct_sharing_code LIKE '%SHARE%' then
4271: UPDATE pji_pjp_wbs_header SET

Line 4681: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_IN_PROC(

4677: p_calling_context, -- second parameter
4678: p_rerun_flag );
4679:
4680:
4681: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_IN_PROC(
4682: p_project_id => l_project_id,
4683: p_structure_version_id => l_struct_version_id,
4684: p_calling_context => p_calling_context,
4685: p_conc_request_id => l_request_id,

Line 4697: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(

4693: CONC_REQUEST_ID = l_request_id
4694: WHERE ELEMENT_VERSION_ID = l_struct_version_id
4695: AND PROJECT_ID = l_project_id;
4696: */
4697: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
4698: p_project_id => l_project_id,
4699: p_structure_version_id => l_struct_version_id,
4700: p_calling_context => p_calling_context,
4701: p_conc_request_id => l_request_id,

Line 4759: Pa_Project_Structure_Utils.get_structure_sharing_code (p_project_id);

4755: --versioned/non-versioned structure
4756: --l_struct_type :=
4757: -- Fix for bug : 4191390
4758: l_struct_sharing_code :=
4759: Pa_Project_Structure_Utils.get_structure_sharing_code (p_project_id);
4760:
4761:
4762: IF l_struct_sharing_code LIKE '%SHARE%' THEN
4763: l_shared_flag := 'Y';

Line 5203: Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);

5199:
5200: --Identify if the project has shared/split
5201: --versioned/non-versioned structure
5202: l_struct_type :=
5203: Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);
5204: IF l_struct_type LIKE 'SHARE%' THEN
5205: l_shared_flag := 'Y';
5206: ELSE
5207: l_shared_flag := 'N';

Line 5263: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(

5259: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
5260: WHERE ELEMENT_VERSION_ID = l_struct_version_id
5261: AND PROJECT_ID = l_project_id;
5262: /*
5263: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
5264: p_project_id => l_project_id,
5265: p_structure_version_id => l_struct_version_id,
5266: p_calling_context => p_calling_context,
5267: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,

Line 5300: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(

5296: EXCEPTION
5297: WHEN OTHERS THEN
5298: rollback to process_proj_sum_conc;
5299: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
5300: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
5301: p_project_id => l_project_id,
5302: p_structure_version_id => l_struct_version_id,
5303: p_calling_context => l_calling_context, --Bug fix 6456711
5304: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,

Line 5430: Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);

5426:
5427: --Identify if the project has shared/split
5428: --versioned/non-versioned structure
5429: l_struct_type :=
5430: Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);
5431:
5432: IF l_struct_type LIKE 'SHARE%' THEN
5433: l_shared_flag := 'Y';
5434: ELSE