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 619: * pa_resources table. Due to this, the below api may not be suitable for usage

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

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

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

Line 627: * and pa_resources tables. */

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

Line 9510: l_unit_of_measure pa_resources.unit_of_measure%TYPE;

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

Line 9512: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;

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

Line 11871: FROM pa_resources pr

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

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

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