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 1663: -- Bug 3807633.. We can directly fetch UOM from pa_resource_list_members

1659: -- Get UOM and track as labor flag only if the resource list is not uncategorized
1660: -- If it is is uncategorized then we can make use of the uom and track as labor
1661: -- flag obtained earlier
1662: IF (l_resource_list_id <> l_uncategorized_res_list_id) THEN
1663: -- Bug 3807633.. We can directly fetch UOM from pa_resource_list_members
1664: -- for FINPLAN MODEL(FP.M Changes) as old non-migrated resource
1665: -- list cannot be used and only New and Migrated resource
1666: -- list can be used for FINPLAN Model.
1667: SELECT prlm.unit_of_measure

Line 1669: FROM pa_resource_list_members prlm

1665: -- list cannot be used and only New and Migrated resource
1666: -- list can be used for FINPLAN Model.
1667: SELECT prlm.unit_of_measure
1668: INTO l_unit_of_measure
1669: FROM pa_resource_list_members prlm
1670: WHERE prlm.resource_list_member_id = l_budget_lines_in(i).resource_list_member_id;
1671:
1672: END IF;
1673:

Line 7949: , pa_resource_list_members prlm

7945: CURSOR l_uncategorized_list_csr
7946: IS
7947: SELECT prlm.resource_list_member_id
7948: FROM pa_resource_lists prl
7949: , pa_resource_list_members prlm
7950: WHERE prl.resource_list_id = prlm.resource_list_id
7951: AND prl.uncategorized_flag='Y'
7952: and prlm.resource_class_code = 'FINANCIAL_ELEMENTS';
7953:

Line 9120: , pa_resource_list_members prlm

9116: CURSOR l_uncategorized_list_csr
9117: IS
9118: SELECT prlm.resource_list_member_id
9119: FROM pa_resource_lists prl
9120: , pa_resource_list_members prlm
9121: WHERE prl.resource_list_id = prlm.resource_list_id
9122: AND prl.uncategorized_flag='Y';
9123:
9124: */

Line 9132: , pa_resource_list_members prlm

9128: CURSOR l_uncategorized_list_csr
9129: IS
9130: SELECT prlm.resource_list_member_id
9131: FROM pa_resource_lists prl
9132: , pa_resource_list_members prlm
9133: WHERE prl.resource_list_id = prlm.resource_list_id
9134: AND prl.uncategorized_flag='Y'
9135: and prlm.resource_class_code = 'FINANCIAL_ELEMENTS';
9136:

Line 9326: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;

9322: l_baselined_Ver_options_id VARCHAR2(15);
9323: l_budget_lines_in budget_line_in_tbl_type;
9324: l_debug_level3 CONSTANT NUMBER := 3;
9325: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
9326: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
9327: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
9328: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
9329: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;
9330: -- Bug Fix: 4569365. Removed MRC code.

Line 9328: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

9324: l_debug_level3 CONSTANT NUMBER := 3;
9325: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
9326: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
9327: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
9328: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
9329: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;
9330: -- Bug Fix: 4569365. Removed MRC code.
9331: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
9332: l_calling_context VARCHAR2(30);

Line 11658: ,pa_resource_list_members prlm

11654: INTO l_unit_of_measure
11655: ,l_track_as_labor_flag
11656: FROM pa_resources pr
11657: ,pa_resource_lists prl
11658: ,pa_resource_list_members prlm
11659: WHERE prl.resource_list_id = lx_resource_list_id -- bug 3453650
11660: AND pr.resource_id = prlm.resource_id
11661: AND prl.resource_list_id = prlm.resource_list_id
11662: AND prlm.resource_list_member_id = l_budget_lines_in(i).resource_list_member_id;

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

14109: -- view definition. Changing the pa_budget_lines_v view could have a large impact.
14110: -- So, cursor has been modified to be based on the direct tables.
14111:
14112: ---- Bug # 3507156
14113: -- Modified the select statement to selecy alias name directly from pa_resource_list_members table
14114: -- instead of PA_RESOURCES_PKG.GET_RESOURCE_NAME(rlm.resource_id,rlm.resource_type_id)
14115:
14116:
14117:

Line 14148: pa_resource_list_members rlm

14144: ,bl.burdened_cost projfunc_burdened_cost
14145: ,bl.revenue projfunc_revenue
14146: FROM pa_budget_lines bl,
14147: pa_resource_assignments ra,
14148: pa_resource_list_members rlm
14149: WHERE bl.budget_version_id = c_budget_version_id
14150: AND bl.resource_assignment_id = ra.resource_assignment_id
14151: AND ra.resource_list_member_id = rlm.resource_list_member_id;
14152:

Line 17169: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

17165: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17166: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17167: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17168: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
17169: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
17170: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
17171: -- Bug Fix: 4569365. Removed MRC code.
17172: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE := PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT;
17173: l_calling_context VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT;