DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PA_PROJECT_STRUCTURE_UTILS

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

1471: return;
1472: END IF;
1473:
1474: --bug 4045979
1475: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);
1476:
1477: --BUG 4355204, rtarway
1478: --IF (p_commit = FND_API.G_TRUE) THEN
1479: savepoint ROLLUP_PROGRESS_PVT2;

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

1486: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1487: FND_MSG_PUB.initialize;
1488: END IF;
1489:
1490: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
1491: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --bug 3830434
1492: -- 4746476 : added org_id in below select
1493: SELECT project_currency_code, org_id INTO l_prj_currency_code, l_org_id FROM pa_projects_all WHERE project_id = p_project_id;
1494:

Line 3535: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_THIRD_PARTY_SCH_FLAG(p_project_id)= 'Y' THEN

3531: -- 5119716 Begin
3532: -- In early Rollup API, there used to be call of PA_TASK_PUB1.update_schedule_version API
3533: -- For performance changes, it was removed and replaced with direct update statement
3534: -- The follwoing portion for dirty schedule was missing out.
3535: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_THIRD_PARTY_SCH_FLAG(p_project_id)= 'Y' THEN
3536:
3537: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
3538: p_structure_version_id => p_structure_version_id
3539: ,p_dirty_flag => 'Y'

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

4270: -- Bug 4573257 Begin
4271: -- We need to call PJI tmp table population
4272: -- otherwise we will get incorrect actual and etc for future dates records
4273: IF l_last_as_of_date IS NULL OR cur_tree_rollup_rec.as_of_date <> l_last_as_of_date THEN
4274: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);
4275: IF (l_base_struct_ver_id = -1) THEN
4276: l_base_struct_ver_id := p_structure_version_id;
4277: END IF;
4278:

Line 4711: ,p_baselined_str_ver_id => PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(l_c1rec.parent_project_id)

4707: ,p_commit => FND_API.G_FALSE
4708: ,p_calling_module => l_calling_module
4709: ,p_project_id => l_c1rec.parent_project_id
4710: ,p_structure_version_id => l_c1rec.parent_structure_ver_id
4711: ,p_baselined_str_ver_id => PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(l_c1rec.parent_project_id)
4712: ,p_structure_type => 'WORKPLAN'
4713: ,p_program_rollup_flag => 'Y'
4714: ,p_calling_context => 'SUMMARIZE'
4715: ,p_as_of_date => l_parent_as_of_date

Line 4947: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(l_c1rec.parent_project_id);

4943:
4944:
4945: /* Bug 4392189 : No need to call populate_pji_tab_for_plan for parnet here.
4946: The temp table will be having data up in the complete hierrachy of program
4947: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(l_c1rec.parent_project_id);
4948:
4949: pa_progress_pub.populate_pji_tab_for_plan(
4950: p_init_msg_list => 'F',
4951: p_calling_module => l_calling_module,

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

6951: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
6952: FND_MSG_PUB.initialize;
6953: END IF;
6954:
6955: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
6956: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);
6957:
6958: --bug 3949093
6959: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;

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

6952: FND_MSG_PUB.initialize;
6953: END IF;
6954:
6955: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
6956: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);
6957:
6958: --bug 3949093
6959: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;
6960:

Line 10379: ,p_baselined_str_ver_id => PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(rec_subprojs.project_id)

10375: ,p_commit => FND_API.G_FALSE
10376: ,p_calling_module => p_calling_module
10377: ,p_project_id => rec_subprojs.project_id
10378: ,p_structure_version_id => rec_subprojs.element_version_id
10379: ,p_baselined_str_ver_id => PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(rec_subprojs.project_id)
10380: ,p_structure_type => 'WORKPLAN'
10381: ,p_program_rollup_flag => 'Y'
10382: ,p_calling_context => 'SUMMARIZE'
10383: ,p_as_of_date => rec_subprojs.as_of_date

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

11764: return;
11765: END IF;
11766:
11767: --bug 4045979
11768: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);
11769:
11770: --BUG 4355204, rtarway
11771: --IF (p_commit = FND_API.G_TRUE) THEN
11772: savepoint ROLLUP_PVT2;

Line 11787: ,p_baselined_str_ver_id => pa_project_structure_utils.get_baseline_struct_ver(p_project_id)

11783: PA_PROGRESS_PUB.POPULATE_PJI_TAB_FOR_PLAN(
11784: p_calling_module => 'AMG'
11785: ,p_project_id => p_project_id
11786: ,p_structure_version_id => p_structure_version_id
11787: ,p_baselined_str_ver_id => pa_project_structure_utils.get_baseline_struct_ver(p_project_id)
11788: ,p_program_rollup_flag => 'Y'
11789: ,p_calling_context => 'SUMMARIZE'
11790: ,p_as_of_date => p_as_of_date -- Fix for Bug # 4251406.
11791: ,x_return_status => l_return_status

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

11792: ,x_msg_count => l_msg_count
11793: ,x_msg_data => l_msg_data
11794: );
11795:
11796: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
11797: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --bug 3830434
11798: -- 4746476 : added org_id in below select
11799: SELECT project_currency_code, org_id INTO l_prj_currency_code, l_org_id FROM pa_projects_all WHERE project_id = p_project_id;
11800:

Line 13614: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_THIRD_PARTY_SCH_FLAG(p_project_id)= 'Y'

13610: -- 5119716 Begin
13611: -- In early Rollup API, there used to be call of PA_TASK_PUB1.update_schedule_version API
13612: -- For performance changes, it was removed and replaced with direct update statement
13613: -- The follwoing portion for dirty schedule was missing out.
13614: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_THIRD_PARTY_SCH_FLAG(p_project_id)= 'Y'
13615: THEN
13616: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
13617: p_structure_version_id => p_structure_version_id
13618: ,p_dirty_flag => 'Y'

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

15334: return;
15335: END IF;
15336:
15337: --bug 4045979
15338: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(p_project_id);
15339:
15340: --BUG 4355204, rtarway
15341: --IF (p_commit = FND_API.G_TRUE) THEN
15342: savepoint ROLLUP_PVT2;

Line 15358: ,p_baselined_str_ver_id => pa_project_structure_utils.get_baseline_struct_ver(p_project_id)

15354: PA_PROGRESS_PUB.POPULATE_PJI_TAB_FOR_PLAN(
15355: p_calling_module => 'AMG'
15356: ,p_project_id => p_project_id
15357: ,p_structure_version_id => p_structure_version_id
15358: ,p_baselined_str_ver_id => pa_project_structure_utils.get_baseline_struct_ver(p_project_id)
15359: ,p_program_rollup_flag => 'Y'
15360: ,p_calling_context => 'SUMMARIZE'
15361: ,p_as_of_date => p_as_of_date -- Fix for Bug # 4251406.
15362: ,x_return_status => l_return_status

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

15363: ,x_msg_count => l_msg_count
15364: ,x_msg_data => l_msg_data
15365: );
15366: */
15367: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
15368: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --bug 3830434
15369: -- 4746476 : added org_id in below select
15370: SELECT project_currency_code, org_id INTO l_prj_currency_code, l_org_id FROM pa_projects_all WHERE project_id = p_project_id;
15371:

Line 17235: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_THIRD_PARTY_SCH_FLAG(p_project_id)= 'Y'

17231: -- 5119716 Begin
17232: -- In early Rollup API, there used to be call of PA_TASK_PUB1.update_schedule_version API
17233: -- For performance changes, it was removed and replaced with direct update statement
17234: -- The follwoing portion for dirty schedule was missing out.
17235: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_THIRD_PARTY_SCH_FLAG(p_project_id)= 'Y'
17236: THEN
17237: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
17238: p_structure_version_id => p_structure_version_id
17239: ,p_dirty_flag => 'Y'