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_BUDGET_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 244: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;

240: l_msg_data VARCHAR2(2000);
241: l_msg_index_out NUMBER;
242: l_budget_lines_in budget_line_in_tbl_type;
243: l_allow_qty_flag VARCHAR2(1);
244: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
245: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
246: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
247: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
248: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

Line 245: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;

241: l_msg_index_out NUMBER;
242: l_budget_lines_in budget_line_in_tbl_type;
243: l_allow_qty_flag VARCHAR2(1);
244: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
245: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
246: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
247: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
248: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
249: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;

Line 246: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;

242: l_budget_lines_in budget_line_in_tbl_type;
243: l_allow_qty_flag VARCHAR2(1);
244: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
245: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
246: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
247: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
248: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
249: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
250: l_amg_segment1 pa_projects_all.segment1%TYPE;

Line 253: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

249: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
250: l_amg_segment1 pa_projects_all.segment1%TYPE;
251: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
252: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
253: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
254: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
255: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;
256: l_debug_mode VARCHAR2(1);
257: l_module_name VARCHAR2(80);

Line 254: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

250: l_amg_segment1 pa_projects_all.segment1%TYPE;
251: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
252: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
253: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
254: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
255: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;
256: l_debug_mode VARCHAR2(1);
257: l_module_name VARCHAR2(80);
258: l_debug_level3 CONSTANT NUMBER := 3;

Line 1685: -- Bug 3807633.. We can directly fetch UOM from pa_resource_list_members

1681: -- Get UOM and track as labor flag only if the resource list is not uncategorized
1682: -- If it is is uncategorized then we can make use of the uom and track as labor
1683: -- flag obtained earlier
1684: IF (l_resource_list_id <> l_uncategorized_res_list_id) THEN
1685: -- Bug 3807633.. We can directly fetch UOM from pa_resource_list_members
1686: -- for FINPLAN MODEL(FP.M Changes) as old non-migrated resource
1687: -- list cannot be used and only New and Migrated resource
1688: -- list can be used for FINPLAN Model.
1689: SELECT prlm.unit_of_measure

Line 1691: FROM pa_resource_list_members prlm

1687: -- list cannot be used and only New and Migrated resource
1688: -- list can be used for FINPLAN Model.
1689: SELECT prlm.unit_of_measure
1690: INTO l_unit_of_measure
1691: FROM pa_resource_list_members prlm
1692: WHERE prlm.resource_list_member_id = l_budget_lines_in(i).resource_list_member_id;
1693:
1694: END IF;
1695:

Line 8109: , pa_resource_list_members prlm

8105: CURSOR l_uncategorized_list_csr
8106: IS
8107: SELECT prlm.resource_list_member_id
8108: FROM pa_resource_lists prl
8109: , pa_resource_list_members prlm
8110: WHERE prl.resource_list_id = prlm.resource_list_id
8111: AND prl.uncategorized_flag='Y'
8112: and prlm.resource_class_code = 'FINANCIAL_ELEMENTS';
8113:

Line 9301: , pa_resource_list_members prlm

9297: CURSOR l_uncategorized_list_csr
9298: IS
9299: SELECT prlm.resource_list_member_id
9300: FROM pa_resource_lists prl
9301: , pa_resource_list_members prlm
9302: WHERE prl.resource_list_id = prlm.resource_list_id
9303: AND prl.uncategorized_flag='Y';
9304:
9305: */

Line 9313: , pa_resource_list_members prlm

9309: CURSOR l_uncategorized_list_csr
9310: IS
9311: SELECT prlm.resource_list_member_id
9312: FROM pa_resource_lists prl
9313: , pa_resource_list_members prlm
9314: WHERE prl.resource_list_id = prlm.resource_list_id
9315: AND prl.uncategorized_flag='Y'
9316: and prlm.resource_class_code = 'FINANCIAL_ELEMENTS';
9317:

Line 9509: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;

9505: l_baselined_Ver_options_id VARCHAR2(15);
9506: l_budget_lines_in budget_line_in_tbl_type;
9507: l_debug_level3 CONSTANT NUMBER := 3;
9508: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
9509: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
9510: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
9511: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
9512: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;
9513: -- Bug Fix: 4569365. Removed MRC code.

Line 9511: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

9507: l_debug_level3 CONSTANT NUMBER := 3;
9508: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
9509: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
9510: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
9511: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
9512: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;
9513: -- Bug Fix: 4569365. Removed MRC code.
9514: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
9515: l_calling_context VARCHAR2(30);

Line 11873: ,pa_resource_list_members prlm

11869: INTO l_unit_of_measure
11870: ,l_track_as_labor_flag
11871: FROM pa_resources pr
11872: ,pa_resource_lists prl
11873: ,pa_resource_list_members prlm
11874: WHERE prl.resource_list_id = lx_resource_list_id -- bug 3453650
11875: AND pr.resource_id = prlm.resource_id
11876: AND prl.resource_list_id = prlm.resource_list_id
11877: AND prlm.resource_list_member_id = l_budget_lines_in(i).resource_list_member_id;

Line 14359: -- Modified the select statement to selecy alias name directly from pa_resource_list_members table

14355: -- view definition. Changing the pa_budget_lines_v view could have a large impact.
14356: -- So, cursor has been modified to be based on the direct tables.
14357:
14358: ---- Bug # 3507156
14359: -- Modified the select statement to selecy alias name directly from pa_resource_list_members table
14360: -- instead of PA_RESOURCES_PKG.GET_RESOURCE_NAME(rlm.resource_id,rlm.resource_type_id)
14361:
14362:
14363:

Line 14394: pa_resource_list_members rlm

14390: ,bl.burdened_cost projfunc_burdened_cost
14391: ,bl.revenue projfunc_revenue
14392: FROM pa_budget_lines bl,
14393: pa_resource_assignments ra,
14394: pa_resource_list_members rlm
14395: WHERE bl.budget_version_id = c_budget_version_id
14396: AND bl.resource_assignment_id = ra.resource_assignment_id
14397: AND ra.resource_list_member_id = rlm.resource_list_member_id;
14398:

Line 17428: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

17424: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17425: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17426: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17427: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
17428: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
17429: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
17430: -- Bug Fix: 4569365. Removed MRC code.
17431: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE := PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT;
17432: l_calling_context VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT;