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_PROGRESS_PUB dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 786: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);

782: END LOOP;
783: END IF ; -- p_calling_module='TEAM_MEM_HOME'
784: --end add by rtarway for BUG 4085882
785:
786: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);
787: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_object_version_id,p_object_type); -- Bug 3784904
788: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
789:
790: --bug 3824042

Line 4178: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'Y'))

4174: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y')
4175: AND
4176: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_object_id) = 'Y') --Bug 3784405 Satish
4177: AND
4178: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'Y'))
4179: THEN
4180: --copy to transaction dates
4181: PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES(
4182: p_validate_only => FND_API.G_FALSE

Line 5135: IF ('Y'=PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id) AND (l_template_flag = 'N') AND (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'N')) THEN

5131: --3035902: process update flag changes; added check for
5132: --sharing disabled
5133: --set update flag to N when changing to MANUAL and
5134: --if this is split structure; otherwise no change
5135: IF ('Y'=PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id) AND (l_template_flag = 'N') AND (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'N')) THEN
5136: --versioning enabled
5137: OPEN cur_get_wk_ver_struct_id;
5138: LOOP
5139: --------------dbms_output.put_line('in loop '||p_project_id);

Line 5166: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'N' THEN

5162: END LOOP;
5163: CLOSE cur_get_wk_ver_struct_id;
5164: ELSE
5165: -- Added if clause for bug#3066833
5166: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'N' THEN
5167: --get only version, project or template
5168: OPEN cur_get_only_ver_struct_id;
5169: FETCH cur_get_only_ver_struct_id Into l_updt_struc_ver_id;
5170: --------------dbms_output.put_line('update '||l_updt_struc_ver_id);

Line 6899: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);

6895: IF x_return_status <> 'S' THEN
6896: RAISE FND_API.G_EXC_ERROR;
6897: END IF;
6898:
6899: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);
6900:
6901: IF (l_base_struct_ver_id = -1) THEN
6902: l_base_struct_ver_id := l_structure_version_id;
6903: END IF;

Line 8672: l_baselined_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id);

8668: BEGIN
8669:
8670: -- Bug 3846353 : Baselined str version also need to be passed, otherwise it will be null at task level
8671:
8672: l_baselined_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id);
8673:
8674: IF l_baselined_str_ver_id = -1 OR l_baselined_str_ver_id IS NULL THEN
8675: l_baselined_str_ver_id := p_working_str_version_id;
8676: END IF;

Line 8782: ,schedule_dirty_flag = decode( PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_project_id), --bug 3844689

8778: --- END IF; -- If workplan versioning is enabled
8779:
8780: UPDATE pa_proj_elem_ver_structure
8781: set date_prog_applied_on_wver = sysdate
8782: ,schedule_dirty_flag = decode( PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_project_id), --bug 3844689
8783: 'Y', 'Y', schedule_dirty_flag ) --set this flag to indicate re-scheduling is required.
8784: WHERE project_id = p_project_id
8785: AND element_version_id = p_working_str_version_id;
8786:

Line 9052: IF NOT NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(P_Project_ID),'X') = 'SHARE_FULL'

9048:
9049: x_return_status := FND_API.G_RET_STS_SUCCESS;
9050:
9051: --bug 4573340
9052: IF NOT NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(P_Project_ID),'X') = 'SHARE_FULL'
9053: THEN
9054: return;
9055: END IF;
9056: --end bug 4573340 This check is not related to bugfix 4573340. This is added while fixing that bug.

Line 9124: l_program_enable_flag := PA_PROJECT_STRUCTURE_UTILS.check_program_flag_enable(P_Project_ID);

9120: CLOSE c_check_prog_exists;
9121:
9122: -- Bug 5961235 : For programs if sub projects has progress then we need to rollup at program task level
9123: IF nvl(l_check_prog_exists,'N') = 'N' THEN
9124: l_program_enable_flag := PA_PROJECT_STRUCTURE_UTILS.check_program_flag_enable(P_Project_ID);
9125:
9126: If l_program_enable_flag = 'Y' then
9127: OPEN c_check_prog_exists_prg;
9128: FETCH c_check_prog_exists_prg INTO l_check_prog_exists;

Line 9448: PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_DETAILS

9444: x_return_status := FND_API.G_RET_STS_SUCCESS;
9445:
9446: -- Begin fix for Bug # 4524977.
9447:
9448: PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_DETAILS
9449: (p_project_id => p_project_id
9450: ,p_structure_type => p_structure_type
9451: ,x_request_id => l_request_id
9452: ,x_process_code => l_process_code

Line 9537: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id); -- Bug 3586648

9533: */
9534:
9535: -- END: Code to fix Bug # 3821106.
9536:
9537: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id); -- Bug 3586648
9538: -- Bug 3722011 Begin
9539: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
9540: IF (l_sharing_Enabled = 'N' OR (l_sharing_Enabled = 'Y' AND l_structure_sharing_code <> 'SHARE_FULL')) AND p_structure_type = 'WORKPLAN' THEN
9541: l_split_workplan := 'Y';

Line 9539: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);

9535: -- END: Code to fix Bug # 3821106.
9536:
9537: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id); -- Bug 3586648
9538: -- Bug 3722011 Begin
9539: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
9540: IF (l_sharing_Enabled = 'N' OR (l_sharing_Enabled = 'Y' AND l_structure_sharing_code <> 'SHARE_FULL')) AND p_structure_type = 'WORKPLAN' THEN
9541: l_split_workplan := 'Y';
9542: ELSE
9543: l_split_workplan := 'N';

Line 9971: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);

9967: RAISE FND_API.G_EXC_ERROR;
9968: END IF;
9969:
9970:
9971: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);
9972:
9973: IF (l_base_struct_ver_id = -1) THEN
9974: l_base_struct_ver_id := l_structure_version_id; --maansari7/6 bug 3742356
9975: END IF;

Line 10085: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'Y'))

10081: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y')
10082: AND
10083: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_task_id) = 'Y') --Bug 3784405 Satish
10084: AND
10085: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'Y'))
10086: THEN
10087: --copy to transaction dates
10088: PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES(
10089: p_validate_only => FND_API.G_FALSE

Line 10337: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_project_id);

10333: l_plan_version_id := pa_progress_utils.get_app_cost_budget_cb_wor_ver(p_project_id);
10334:
10335: /* End fix for Bug # 4115607. */
10336:
10337: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_project_id);
10338: END IF;
10339:
10340: BEGIN
10341: -- Bug 3627315 : Added code to conditionally call PJI API with diff parameters

Line 10571: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);

10567: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
10568:
10569: IF NVL(p_structure_version_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3625085
10570: THEN
10571: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);
10572: ELSE
10573: l_structure_version_id := p_structure_version_id;
10574: END IF;
10575:

Line 10879: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id); -- Bug 3586648

10875: -- Now we will not use POPULATE_PRG_ACT_TBL_SINGLE to poulate the PA_PROG_ACT_BY_PERIOD_TEMP
10876: -- it was populating the cumulative amount.
10877: -- Now we will populate the incrmental amount and will call API MAINTAIN_ACTUAL_AMT_WRP
10878: -- with p_extraction_type as INCRMENTAL
10879: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id); -- Bug 3586648
10880: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
10881: IF (l_sharing_Enabled = 'N' OR (l_sharing_Enabled = 'Y' AND l_structure_sharing_code <> 'SHARE_FULL')) THEN
10882: l_split_workplan := 'Y';
10883: ELSE

Line 10880: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);

10876: -- it was populating the cumulative amount.
10877: -- Now we will populate the incrmental amount and will call API MAINTAIN_ACTUAL_AMT_WRP
10878: -- with p_extraction_type as INCRMENTAL
10879: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id); -- Bug 3586648
10880: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
10881: IF (l_sharing_Enabled = 'N' OR (l_sharing_Enabled = 'Y' AND l_structure_sharing_code <> 'SHARE_FULL')) THEN
10882: l_split_workplan := 'Y';
10883: ELSE
10884: l_split_workplan := 'N';

Line 11265: IF PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled(p_project_id) = 'N'

11261:
11262: l_fin_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'FINANCIAL');
11263:
11264:
11265: IF PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled(p_project_id) = 'N'
11266: THEN
11267: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
11268: ,p_msg_name => 'PA_PS_WORKPLAN_DISABLED');
11269: x_msg_data := 'PA_PS_WORKPLAN_DISABLED';

Line 11356: l_baselined_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id);

11352: RAISE FND_API.G_EXC_ERROR;
11353: END IF;
11354: -- Bug 3696820 : begin
11355: BEGIN
11356: l_baselined_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id);
11357: EXCEPTION
11358: WHEN OTHERS THEN
11359: l_baselined_str_ver_id := null;
11360: END;

Line 13372: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(ppa.project_id) shared_structure

13368:
13369: l_no_rate_exception Exception;
13370: cursor projects_in_range is
13371: select ppa.org_id, ppa.project_currency_code, ppa.projfunc_currency_code,
13372: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(ppa.project_id) shared_structure
13373: from pa_projects_all ppa
13374: where ppa.project_id = l_project_id;
13375:
13376: -- tables to hold project_ids, latest WP ids and res list ids.

Line 14455: l_latest_wp_struct_ver_id := pa_project_structure_utils.get_latest_wp_version(l_project_id);

14451:
14452: /* Commented for Bug 6414995 and reverted as above.
14453:
14454: if p_extraction_type = 'PUBLISH' then -- Added If block for bug#5659575
14455: l_latest_wp_struct_ver_id := pa_project_structure_utils.get_latest_wp_version(l_project_id);
14456: else
14457: l_latest_wp_struct_ver_id := pa_project_structure_utils.GET_LATEST_FIN_STRUC_VER_ID(l_project_id);
14458: end if;
14459: Bug 6414995 */

Line 14457: l_latest_wp_struct_ver_id := pa_project_structure_utils.GET_LATEST_FIN_STRUC_VER_ID(l_project_id);

14453:
14454: if p_extraction_type = 'PUBLISH' then -- Added If block for bug#5659575
14455: l_latest_wp_struct_ver_id := pa_project_structure_utils.get_latest_wp_version(l_project_id);
14456: else
14457: l_latest_wp_struct_ver_id := pa_project_structure_utils.GET_LATEST_FIN_STRUC_VER_ID(l_project_id);
14458: end if;
14459: Bug 6414995 */
14460: l_latest_wp_struct_ver_id := pa_project_structure_utils.get_latest_wp_version(l_project_id); -- Bug 6414995
14461: if l_latest_wp_struct_ver_id is not null then

Line 14460: l_latest_wp_struct_ver_id := pa_project_structure_utils.get_latest_wp_version(l_project_id); -- Bug 6414995

14456: else
14457: l_latest_wp_struct_ver_id := pa_project_structure_utils.GET_LATEST_FIN_STRUC_VER_ID(l_project_id);
14458: end if;
14459: Bug 6414995 */
14460: l_latest_wp_struct_ver_id := pa_project_structure_utils.get_latest_wp_version(l_project_id); -- Bug 6414995
14461: if l_latest_wp_struct_ver_id is not null then
14462: IF g1_debug_mode = 'Y' THEN
14463: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.get_summarized_actuals',
14464: x_Msg => 'Project:'||l_project_id||' Structure:'||l_latest_wp_struct_ver_id,

Line 14539: base_struct_ver_ids_tbl(l_index) := pa_project_structure_utils.get_baseline_struct_ver(l_project_id);

14535: end if;
14536:
14537: -- Added for bug 5464875
14538: if (p_plan_res_level = 'N') then
14539: base_struct_ver_ids_tbl(l_index) := pa_project_structure_utils.get_baseline_struct_ver(l_project_id);
14540: if (base_struct_ver_ids_tbl(l_index) = -1) then
14541: base_struct_ver_ids_tbl(l_index) := null;
14542: end if;
14543: end if;

Line 14676: l_wp_prl_res_class_flag := PA_PROJECT_STRUCTURE_UTILS.get_resource_class_flag(l_project_id); -- CBS Changes

14672: SAVEPOINT ACT_PROJECT;
14673: /* End: Fix for Bug # 5526638. */
14674:
14675: l_project_id := proj_ids_tbl(l_index);
14676: l_wp_prl_res_class_flag := PA_PROJECT_STRUCTURE_UTILS.get_resource_class_flag(l_project_id); -- CBS Changes
14677: l_temp_as_of_date := proj_thru_dates_tbl(l_index);
14678: pa_debug.log_message('GET_SUMM_ACT: Project Id: '||l_project_id||' As of Date: '||l_temp_as_of_date||' Project Level: '||proj_pgm_level_tbl(l_index), 1);
14679: l_latest_wp_struct_ver_id := latest_wp_struct_ver_ids_tbl(l_index);
14680:

Line 14761: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(l_project_id);

14757:
14758: /**** Commented for bug 5464875 and moved above for batch processing
14759: --- here call populate_workplan_data when plan_res_level is 'N'
14760: if (p_plan_res_level = 'N' and l_return_status = 'S') then
14761: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(l_project_id);
14762: if (l_base_struct_ver_id = -1) then
14763: l_base_struct_ver_id := null;
14764: end if;
14765: begin

Line 18055: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)

18051: IF l_asgmt_count > 0 then
18052: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
18053: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
18054: ,p_project_id => l_project_id
18055: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
18056: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
18057: ,x_return_status => x_return_status
18058: ,x_msg_count => x_msg_count
18059: ,x_msg_data => x_msg_data);

Line 18056: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)

18052: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
18053: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
18054: ,p_project_id => l_project_id
18055: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
18056: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
18057: ,x_return_status => x_return_status
18058: ,x_msg_count => x_msg_count
18059: ,x_msg_data => x_msg_data);
18060:

Line 19785: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE(proj_ids_tbl(l_index),

19781: p_err_flag => l_act_err_flag(l_index),
19782: p_err_msg => l_act_err_msg(l_index));
19783: DELETE PJI_FM_EXTR_PLAN_LINES where PROJECT_ID = proj_ids_tbl(l_index);
19784: DELETE PA_PROG_ACT_BY_PERIOD_TEMP where PROJECT_ID = proj_ids_tbl(l_index);
19785: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE(proj_ids_tbl(l_index),
19786: latest_wp_struct_ver_ids_tbl(l_index),
19787: 'PRE',
19788: l_conc_request_id,
19789: l_return_status);

Line 19797: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE(proj_ids_tbl(l_index),

19793: PJI_FM_XBS_ACCUM_UTILS.DELETE_FIN8 (p_project_id => proj_ids_tbl(l_index),
19794: p_calendar_type => calendar_type_tbl(l_index),
19795: p_end_Date => proj_thru_dates_tbl(l_index));
19796: end if;
19797: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE(proj_ids_tbl(l_index),
19798: latest_wp_struct_ver_ids_tbl(l_index),
19799: NULL,
19800: l_conc_request_id,
19801: l_return_status);

Line 19812: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE(proj_ids_tbl(l_index),

19808: PJI_FM_XBS_ACCUM_UTILS.DELETE_FIN8 (p_project_id => proj_ids_tbl(l_index),
19809: p_calendar_type => calendar_type_tbl(l_index),
19810: p_end_Date => proj_thru_dates_tbl(l_index));
19811: if p_extraction_type <> 'PUBLISH' then
19812: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE(proj_ids_tbl(l_index),
19813: latest_wp_struct_ver_ids_tbl(l_index),
19814: NULL,
19815: l_conc_request_id,
19816: l_return_status);

Line 21012: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);

21008: -- Bug 3764224 : calling it here as this procedure gets called two times in publishing flow. One for
21009: -- Publsihed version and one for working version
21010: -- Bug 3693757 : 13-Jul-04 PJI tmp1 table shd be populated so that rollup API can access actuals values in RE_ROLLUP_PROGRESS
21011: BEGIN
21012: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);
21013: pa_progress_pub.populate_pji_tab_for_plan(
21014: p_init_msg_list => FND_API.G_FALSE,
21015: p_project_id => p_project_id,
21016: p_structure_version_id => p_structure_version_id,

Line 21175: l_baseline_version_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(rec.project_id);

21171: x_return_status := FND_API.G_RET_STS_SUCCESS;
21172:
21173: FOR rec IN c_get_distinct_str_ver_id LOOP
21174: l_baseline_version_id := null;
21175: l_baseline_version_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(rec.project_id);
21176: IF l_baseline_version_id = -1 THEN
21177: l_baseline_version_id := null;
21178: END IF;
21179:

Line 21650: l_src_str_ver_publsihed := PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(p_project_id, p_src_str_ver_id);

21646: -- as in this context there will never be working wp version progress
21647: -- For PJI context, it should first check whthere the source str version id is publihed or not.
21648:
21649:
21650: l_src_str_ver_publsihed := PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(p_project_id, p_src_str_ver_id);
21651:
21652:
21653: open proj_info;
21654: fetch proj_info into l_org_id,l_proj_curr_code,l_proj_func_curr_code;

Line 22888: PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_DETAILS

22884: END IF;
22885:
22886: -- Begin fix for Bug # 4524977.
22887:
22888: PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_DETAILS
22889: (p_project_id => p_project_id_tbl(i)
22890: ,p_structure_type => p_structure_type
22891: ,x_request_id => l_request_id
22892: ,x_process_code => l_process_code

Line 22971: l_last_str_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_last_project_id);

22967:
22968: IF l_last_project_id <> p_project_id_tbl(i) THEN
22969: l_last_project_id := p_project_id_tbl(i);
22970: PA_PROGRESS_PUB.G_PROJECT_ID :=l_last_project_id; --Added for huawei
22971: l_last_str_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_last_project_id);
22972: l_last_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(l_last_project_id);
22973: IF (l_last_sharing_Enabled = 'N' OR (l_last_sharing_Enabled = 'Y' AND l_last_str_sharing_code <> 'SHARE_FULL'))
22974: AND p_structure_type = 'WORKPLAN'
22975: THEN

Line 22972: l_last_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(l_last_project_id);

22968: IF l_last_project_id <> p_project_id_tbl(i) THEN
22969: l_last_project_id := p_project_id_tbl(i);
22970: PA_PROGRESS_PUB.G_PROJECT_ID :=l_last_project_id; --Added for huawei
22971: l_last_str_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_last_project_id);
22972: l_last_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(l_last_project_id);
22973: IF (l_last_sharing_Enabled = 'N' OR (l_last_sharing_Enabled = 'Y' AND l_last_str_sharing_code <> 'SHARE_FULL'))
22974: AND p_structure_type = 'WORKPLAN'
22975: THEN
22976: l_last_split_workplan := 'Y';

Line 23491: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id_tbl(i));

23487: RAISE FND_API.G_EXC_ERROR;
23488: END;
23489: END IF;
23490:
23491: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id_tbl(i));
23492:
23493: IF (l_base_struct_ver_id = -1) THEN
23494: l_base_struct_ver_id := l_structure_version_id_tbl(i);
23495: END IF;

Line 23722: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id_tbl(i)) = 'Y'))

23718: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y')
23719: AND
23720: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_task_id_tbl(i)) = 'Y') --Bug 3784405 Satish
23721: AND
23722: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id_tbl(i)) = 'Y'))
23723: THEN
23724: --copy to transaction dates
23725: PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES(
23726: p_validate_only => FND_API.G_FALSE