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_RESOURCES

Line 252: l_unit_of_measure pa_resources.unit_of_measure%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;
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);

Line 255: l_unc_unit_of_measure pa_resources.unit_of_measure%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;
259: l_debug_level5 CONSTANT NUMBER := 5;

Line 617: * pa_resources table. Due to this, the below api may not be suitable for usage

613: END IF;
614:
615:
616: /* After bug fix for bug 4052562, note that the below API returns UOM from rlm table as DOLLARS instead of
617: * pa_resources table. Due to this, the below api may not be suitable for usage
618: * for old budgets model which retrieves UOM from pa_resources (HOURS). As such,
619: * since UOM is not used in create_draft_budget api FOR OLD BUDGETS MODEL, reusing
620: * the below api for both old and new budget model resource lists. If for some
621: * reason in future, UOM of uncatrlm is to be used even for old budgets model,

Line 618: * for old budgets model which retrieves UOM from pa_resources (HOURS). As such,

614:
615:
616: /* After bug fix for bug 4052562, note that the below API returns UOM from rlm table as DOLLARS instead of
617: * pa_resources table. Due to this, the below api may not be suitable for usage
618: * for old budgets model which retrieves UOM from pa_resources (HOURS). As such,
619: * since UOM is not used in create_draft_budget api FOR OLD BUDGETS MODEL, reusing
620: * the below api for both old and new budget model resource lists. If for some
621: * reason in future, UOM of uncatrlm is to be used even for old budgets model,
622: * we should consider using pa_get_resource.get_uncateg_Resource_info. Not

Line 625: * and pa_resources tables. */

621: * reason in future, UOM of uncatrlm is to be used even for old budgets model,
622: * we should consider using pa_get_resource.get_uncateg_Resource_info. Not
623: * changing it now, since, pa_get_resource.get_uncateg_resource_info owned by RF
624: * team, as of now, has the same performance issue of full table scans on RLM
625: * and pa_resources tables. */
626: --Get the uncategorized resource list info.
627: pa_fin_plan_utils.Get_Uncat_Resource_List_Info
628: (x_resource_list_id => l_uncategorized_res_list_id,
629: x_resource_list_member_id => l_uncategorized_rlmid,

Line 9327: l_unit_of_measure pa_resources.unit_of_measure%TYPE;

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.
9331: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;

Line 9329: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;

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);
9333:

Line 11656: FROM pa_resources pr

11652: SELECT pr.unit_of_measure
11653: ,prlm.track_as_labor_flag
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

Line 14114: -- instead of PA_RESOURCES_PKG.GET_RESOURCE_NAME(rlm.resource_id,rlm.resource_type_id)

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:
14118: CURSOR l_resource_assignment_csr