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

Line 2751: l_res_class_flag := PA_PROJECT_STRUCTURE_UTILS.get_resource_class_flag(p_project_id);

2747: IF (((p_context = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN)
2748: OR (p_context = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_TASK))
2749: AND p_struct_elem_version_id IS NOT NULL)
2750: THEN
2751: l_res_class_flag := PA_PROJECT_STRUCTURE_UTILS.get_resource_class_flag(p_project_id);
2752: IF l_res_class_flag = 'N'
2753: THEN
2754: FOR i IN l_rate_based_flag_tbl.FIRST..l_rate_based_flag_tbl.LAST LOOP
2755: --l_rate_based_flag_tbl(i) := 'N';

Line 3976: ,p_project_structure_version_id => PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id => p_project_id )

3972: -- Bug 3793623 - Added new params p_planning_start_date_tbl and p_planning_end_date_tbl
3973: PA_PLANNING_TRANSACTION_UTILS.get_default_planning_dates
3974: ( p_project_id => p_project_id
3975: ,p_element_version_id_tbl => p_task_elem_version_id_tbl
3976: ,p_project_structure_version_id => PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id => p_project_id )
3977: ,p_planning_start_date_tbl => p_planning_start_date_tbl
3978: ,p_planning_end_date_tbl => p_planning_end_date_tbl
3979: ,x_planning_start_date_tbl => l_start_date_tbl
3980: ,x_planning_end_date_tbl => l_compl_date_tbl

Line 5726: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)

5722: /* Bug 13419867 starts */
5723: /* PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
5724: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
5725: ,p_project_id => p_project_id
5726: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5727: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5728: ,x_return_status => l_return_status
5729: ,x_msg_count => l_msg_count
5730: ,x_msg_data => l_msg_data);

Line 5727: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)

5723: /* PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
5724: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
5725: ,p_project_id => p_project_id
5726: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5727: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5728: ,x_return_status => l_return_status
5729: ,x_msg_count => l_msg_count
5730: ,x_msg_data => l_msg_data);
5731:

Line 5737: values(p_project_id, pa_project_structure_utils.get_latest_wp_version(p_project_id),

5733: */
5734: IF (p_extraction_type IN ('INCREMENTAL', 'FULL')) THEN
5735: -- Log the occurence, so that request can be submitted at the end
5736: insert into pa_asgmt_plan_change_t (project_id, strcut_ver_id, pub_strcut_ver_id)
5737: values(p_project_id, pa_project_structure_utils.get_latest_wp_version(p_project_id),
5738: pa_project_structure_utils.get_latest_wp_version(p_project_id));
5739: ELSE
5740: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
5741: ( p_calling_context => 'ASGMT_PLAN_CHANGE'

Line 5738: pa_project_structure_utils.get_latest_wp_version(p_project_id));

5734: IF (p_extraction_type IN ('INCREMENTAL', 'FULL')) THEN
5735: -- Log the occurence, so that request can be submitted at the end
5736: insert into pa_asgmt_plan_change_t (project_id, strcut_ver_id, pub_strcut_ver_id)
5737: values(p_project_id, pa_project_structure_utils.get_latest_wp_version(p_project_id),
5738: pa_project_structure_utils.get_latest_wp_version(p_project_id));
5739: ELSE
5740: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
5741: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
5742: ,p_project_id => p_project_id

Line 5743: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)

5739: ELSE
5740: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
5741: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
5742: ,p_project_id => p_project_id
5743: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5744: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5745: ,x_return_status => l_return_status
5746: ,x_msg_count => l_msg_count
5747: ,x_msg_data => l_msg_data);

Line 5744: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)

5740: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
5741: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
5742: ,p_project_id => p_project_id
5743: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5744: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5745: ,x_return_status => l_return_status
5746: ,x_msg_count => l_msg_count
5747: ,x_msg_data => l_msg_data);
5748:

Line 8114: l_res_class_flag := PA_PROJECT_STRUCTURE_UTILS.get_resource_class_flag(l_project_id);

8110: IF (((p_context = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN)
8111: OR (p_context = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_TASK))
8112: AND p_struct_elem_version_id IS NOT NULL)
8113: THEN
8114: l_res_class_flag := PA_PROJECT_STRUCTURE_UTILS.get_resource_class_flag(l_project_id);
8115: IF l_res_class_flag = 'N'
8116: THEN
8117: FORALL i IN l_resource_assignment_id_tbl.FIRST .. l_resource_assignment_id_tbl.LAST
8118: UPDATE PA_RESOURCE_ASSIGNMENTS

Line 9152: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)

9148:
9149: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
9150: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
9151: ,p_project_id => p_target_project_id
9152: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)
9153: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)
9154: ,x_return_status => x_return_status
9155: ,x_msg_data => x_msg_data
9156: ,x_msg_count => x_msg_count );

Line 9153: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)

9149: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
9150: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
9151: ,p_project_id => p_target_project_id
9152: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)
9153: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)
9154: ,x_return_status => x_return_status
9155: ,x_msg_data => x_msg_data
9156: ,x_msg_count => x_msg_count );
9157:

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

10775:
10776: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
10777: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
10778: ,p_project_id => l_project_id
10779: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
10780: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
10781: ,x_return_status => x_return_status
10782: ,x_msg_data => x_msg_data
10783: ,x_msg_count => x_msg_count );

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

10776: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
10777: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
10778: ,p_project_id => l_project_id
10779: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
10780: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
10781: ,x_return_status => x_return_status
10782: ,x_msg_data => x_msg_data
10783: ,x_msg_count => x_msg_count );
10784:

Line 12194: ,PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) STRUCTURE_VERSION_ID --Bug 3546208

12190: -- End of variables used for debugging purpose
12191:
12192: CURSOR version_info_cur (c_budget_version_id number) is
12193: select bv.project_id
12194: ,PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) STRUCTURE_VERSION_ID --Bug 3546208
12195: ,bv.fin_plan_type_id
12196: ,Decode(bv.version_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code
12197: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,pfo.revenue_fin_plan_level_code
12198: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code) plan_level_code

Line 12833: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y')) THEN

12829: with negative values of budget lines */
12830: IF nvl(p_resource_list_change, 'N') = 'Y' OR nvl(p_time_phase_change, 'N') = 'Y'
12831: OR nvl(p_track_costs_flag_change, 'N') = 'Y' OR (nvl(p_rbs_version_change, 'N') = 'Y' AND
12832: (nvl(PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id),'N') = 'N'
12833: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y')) THEN
12834:
12835: IF l_debug_mode = 'Y' THEN
12836: pa_debug.g_err_stage:='About to insert negative lines';
12837: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);

Line 13071: IF (PA_PROJECT_STRUCTURE_UTILS.get_resource_class_flag(p_project_id) = 'Y') then

13067: OR nvl(p_track_costs_flag_change, 'N') = 'Y' -- bug 3797057
13068: THEN
13069:
13070: --CBS changes: Bug 13639638 start
13071: IF (PA_PROJECT_STRUCTURE_UTILS.get_resource_class_flag(p_project_id) = 'Y') then
13072: OPEN data_for_delete_plan_txns_cur(l_budget_version_id_tbl(i));
13073: FETCH data_for_delete_plan_txns_cur
13074: BULK COLLECT INTO l_task_version_id_tbl
13075: ,l_task_name_tbl

Line 13221: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y') -- Jun-28-2004 Bug 3725414

13217: -- workplan versions even though versioning is enbled but shared structure
13218:
13219: IF nvl(p_rbs_version_change, 'N') = 'Y' AND
13220: (nvl(PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id),'N') = 'N' -- Jun-15-2004 Bug 3619687
13221: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y') -- Jun-28-2004 Bug 3725414
13222: THEN
13223: /** Bug 3725414
13224: -- Fetch all the workplan versions
13225: OPEN all_workplan_versions_cur;

Line 13358: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y')) THEN

13354: with positive values of budget lines */
13355: IF nvl(p_resource_list_change, 'N') = 'Y' OR nvl(p_time_phase_change, 'N') = 'Y'
13356: OR nvl(p_track_costs_flag_change, 'N') = 'Y' OR ( nvl(p_rbs_version_change, 'N') = 'Y' AND
13357: (nvl(PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id),'N') = 'N'
13358: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y')) THEN
13359: IF l_debug_mode = 'Y' THEN
13360: pa_debug.g_err_stage:='About to insert positive values with new rbs element ids';
13361: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
13362: END IF;