DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJECT_STRUCTURE_UTILS

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

2767:
2768: ELSIF ( (p_context IN ('BASELINE', 'ORIGINAL') )
2769: AND (l_fp_version_ids(l_count) > 0)) THEN -- 2
2770:
2771: SELECT PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2772: INTO l_wbs_version_id
2773: FROM pa_budget_versions bv
2774: WHERE budget_version_id = l_fp_version_ids(l_count);
2775:

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

2810: )
2811: SELECT -- DISTINCT
2812: den.sup_project_id project_id
2813: , cbco.plan_version_id -- bv.budget_version_id -- -3 --
2814: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
2815: , bv.rbs_struct_version_id
2816: , bv.plan_type_code
2817: , bv.plan_type_id
2818: , bv.time_phased_type_code

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

3887: END IF;
3888: l_prg_event_id:=null;
3889: END;
3890:
3891: l_struct_sharing_code := Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);
3892: IF l_old_wbs_version_id IS NULL THEN
3893: -- Fix for bug : 4191390
3894: If l_struct_sharing_code LIKE '%SHARE%' then
3895: UPDATE pji_pjp_wbs_header SET

Line 4303: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_IN_PROC(

4299: p_calling_context, -- second parameter
4300: p_rerun_flag );
4301:
4302:
4303: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_IN_PROC(
4304: p_project_id => l_project_id,
4305: p_structure_version_id => l_struct_version_id,
4306: p_calling_context => p_calling_context,
4307: p_conc_request_id => l_request_id,

Line 4319: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(

4315: CONC_REQUEST_ID = l_request_id
4316: WHERE ELEMENT_VERSION_ID = l_struct_version_id
4317: AND PROJECT_ID = l_project_id;
4318: */
4319: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
4320: p_project_id => l_project_id,
4321: p_structure_version_id => l_struct_version_id,
4322: p_calling_context => p_calling_context,
4323: p_conc_request_id => l_request_id,

Line 4381: Pa_Project_Structure_Utils.get_structure_sharing_code (p_project_id);

4377: --versioned/non-versioned structure
4378: --l_struct_type :=
4379: -- Fix for bug : 4191390
4380: l_struct_sharing_code :=
4381: Pa_Project_Structure_Utils.get_structure_sharing_code (p_project_id);
4382:
4383:
4384: IF l_struct_sharing_code LIKE '%SHARE%' THEN
4385: l_shared_flag := 'Y';

Line 4825: Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);

4821:
4822: --Identify if the project has shared/split
4823: --versioned/non-versioned structure
4824: l_struct_type :=
4825: Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);
4826: IF l_struct_type LIKE 'SHARE%' THEN
4827: l_shared_flag := 'Y';
4828: ELSE
4829: l_shared_flag := 'N';

Line 4885: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(

4881: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
4882: WHERE ELEMENT_VERSION_ID = l_struct_version_id
4883: AND PROJECT_ID = l_project_id;
4884: /*
4885: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
4886: p_project_id => l_project_id,
4887: p_structure_version_id => l_struct_version_id,
4888: p_calling_context => p_calling_context,
4889: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,

Line 4922: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(

4918: EXCEPTION
4919: WHEN OTHERS THEN
4920: rollback to process_proj_sum_conc;
4921: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
4922: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
4923: p_project_id => l_project_id,
4924: p_structure_version_id => l_struct_version_id,
4925: p_calling_context => p_calling_context,
4926: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,

Line 5052: Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);

5048:
5049: --Identify if the project has shared/split
5050: --versioned/non-versioned structure
5051: l_struct_type :=
5052: Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);
5053:
5054: IF l_struct_type LIKE 'SHARE%' THEN
5055: l_shared_flag := 'Y';
5056: ELSE