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

Line 398: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;

394: l_balance_type VARCHAR2(1) := NULL;
395:
396: -- --------------------------------------------------------
397: l_uncategorized_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
398: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
399: l_err_code NUMBER;
400: l_err_stage VARCHAR2(120);
401: l_err_stack VARCHAR2(630);
402: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

Line 402: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

398: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
399: l_err_code NUMBER;
400: l_err_stage VARCHAR2(120);
401: l_err_stack VARCHAR2(630);
402: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
403: l_period_type VARCHAR2(2);
404: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
405: l_start_period pa_proj_period_profiles.period_name1%TYPE;
406: l_end_period pa_proj_period_profiles.profile_end_period_name%TYPE;

Line 427: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;

423: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
424: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
425: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
426: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
427: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
428: l_is_rate_type_valid BOOLEAN;
429: l_planning_level_lookup CONSTANT VARCHAR2(30) := 'BUDGET ENTRY LEVEL';
430: l_time_phasing_lookup CONSTANT VARCHAR2(30) := 'BUDGET TIME PHASED TYPE';
431: l_validate_mc_attributes VARCHAR2(1);

Line 448: l_res_list_migration_code pa_resource_list_members.migration_code%TYPE := FND_API.G_MISS_CHAR;

444: l_workplan_flag VARCHAR2(1) := NULL;
445: l_exists VARCHAR2(1) := NULL;
446:
447: -- for bug 3954329
448: l_res_list_migration_code pa_resource_list_members.migration_code%TYPE := FND_API.G_MISS_CHAR;
449: l_targ_request_id pa_budget_versions.request_id%TYPE;
450: px_pa_project_id_in pa_projects_all.project_id%TYPE;
451: px_resource_list_id_in pa_resource_lists_all_bg.resource_list_id%TYPE;
452: px_fin_plan_type_id_in pa_fin_plan_types_b.fin_plan_type_id%TYPE;

Line 4076: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693

4072: l_revenue NUMBER;
4073: -- Following local variables added as part of bug 3062294
4074: l_pa_task_id pa_resource_assignments.task_id%TYPE;
4075: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4076: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4077: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4078: l_budget_start_date pa_budget_lines.start_date%TYPE;
4079: l_budget_end_date pa_budget_lines.start_date%TYPE;
4080: l_period_name pa_budget_lines.period_name%TYPE;

Line 4077: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

4073: -- Following local variables added as part of bug 3062294
4074: l_pa_task_id pa_resource_assignments.task_id%TYPE;
4075: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4076: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4077: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4078: l_budget_start_date pa_budget_lines.start_date%TYPE;
4079: l_budget_end_date pa_budget_lines.start_date%TYPE;
4080: l_period_name pa_budget_lines.period_name%TYPE;
4081: l_description pa_budget_lines.description%TYPE;

Line 4124: ,pa_resource_list_members prlm

4120: SELECT pr.unit_of_measure
4121: ,prlm.track_as_labor_flag
4122: FROM pa_resources pr
4123: ,pa_resource_lists prl
4124: ,pa_resource_list_members prlm
4125: WHERE prl.resource_list_id = c_resource_list_id
4126: AND pr.resource_id = prlm.resource_id
4127: AND prl.resource_list_id = prlm.resource_list_id
4128: AND prlm.resource_list_member_id = c_resource_list_member_id;

Line 5791: ,pa_resource_list_members prlm

5787: ,prlm.track_as_labor_flag
5788: ,prlm.migration_code
5789: FROM pa_resources pr
5790: ,pa_resource_lists prl
5791: ,pa_resource_list_members prlm
5792: WHERE prl.resource_list_id = c_resource_list_id
5793: AND pr.resource_id = prlm.resource_id
5794: AND prl.resource_list_id = prlm.resource_list_id
5795: AND prlm.resource_list_member_id = c_resource_list_member_id;

Line 5803: FROM pa_resource_list_members prlm

5799: (c_resource_list_member_id NUMBER)
5800: IS
5801: SELECT prlm.unit_of_measure,
5802: prlm.migration_code
5803: FROM pa_resource_list_members prlm
5804: WHERE prlm.resource_list_member_id = c_resource_list_member_id;
5805:
5806: --cursor to get the field values associated to a AMG message
5807: CURSOR l_amg_project_csr

Line 5881: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

5877: l_txn_tbl_index NUMBER;
5878: i NUMBER;
5879: l_valid_txn_curr BOOLEAN;
5880: l_txn_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5881: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
5882: l_conv_attrs_to_be_validated VARCHAR2(10);
5883: l_module_name VARCHAR2(80);
5884: l_top_task_id pa_tasks.top_task_id%TYPE;
5885: l_dummy VARCHAR2(1);

Line 5896: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;

5892: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
5893: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
5894: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;
5895: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5896: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
5897: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
5898: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5899: l_res_group_name pa_resource_list_members.alias%TYPE;
5900: l_valid_rlmid VARCHAR2(1);

Line 5897: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;

5893: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
5894: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;
5895: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5896: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
5897: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
5898: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5899: l_res_group_name pa_resource_list_members.alias%TYPE;
5900: l_valid_rlmid VARCHAR2(1);
5901: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 5898: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;

5894: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;
5895: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5896: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
5897: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
5898: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5899: l_res_group_name pa_resource_list_members.alias%TYPE;
5900: l_valid_rlmid VARCHAR2(1);
5901: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5902: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;

Line 5899: l_res_group_name pa_resource_list_members.alias%TYPE;

5895: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5896: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
5897: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
5898: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5899: l_res_group_name pa_resource_list_members.alias%TYPE;
5900: l_valid_rlmid VARCHAR2(1);
5901: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5902: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;
5903: l_context_info pa_fin_plan_types_tl.name%TYPE;

Line 5902: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;

5898: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5899: l_res_group_name pa_resource_list_members.alias%TYPE;
5900: l_valid_rlmid VARCHAR2(1);
5901: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5902: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;
5903: l_context_info pa_fin_plan_types_tl.name%TYPE;
5904: l_pm_product_code pa_budget_lines.pm_product_code%TYPE;
5905:
5906: -- Cursor used in validating the product code

Line 5990: l_resource_alias pa_resource_list_members.alias%type;

5986: l_plan_end_date_tbl varchr_32_index_date_tbl_typ;
5987: l_task_name_tbl varchr_32_index_varchr_tbl_typ;
5988: l_resource_alias_tbl varchr_32_index_varchr_tbl_typ;
5989: l_distinct_taskid_rlmid_index VARCHAR2(32); --Index to store task id and rlm id comnination.
5990: l_resource_alias pa_resource_list_members.alias%type;
5991:
5992: TYPE varchr_120_index_num_tbl_typ IS TABLE OF NUMBER(15) INDEX BY VARCHAR2(120);
5993: l_distinct_rlmid_idx VARCHAR2(120); --Index to store rlm id and resource alias
5994: l_rlm_id_tbl varchr_120_index_num_tbl_typ;

Line 7190: FROM pa_resource_list_members

7186: ,alias
7187: INTO l_parent_member_id
7188: ,l_resource_type_code
7189: ,pa_budget_pvt.g_resource_alias
7190: FROM pa_resource_list_members
7191: WHERE resource_list_member_id = px_budget_lines_in(i).resource_list_member_id;
7192:
7193: IF l_resource_type_code = 'UNCLASSIFIED' THEN
7194:

Line 7308: FROM pa_resource_list_members

7304: IF p_calling_context= 'UPDATE_PLANNING_ELEMENT_ATTR' then
7305: IF l_valid_rlmid ='Y' then
7306: SELECT ALIAS
7307: INTO px_budget_lines_in(i).resource_alias
7308: FROM pa_resource_list_members
7309: WHERE resource_list_member_id = px_budget_lines_in(i).resource_list_member_id;
7310: END IF;
7311: -- DBMS_OUTPUT.PUT_LINE('resource alias '||i||' '||px_budget_lines_in(i).resource_alias);
7312: END IF;

Line 7809: pa_resource_list_members prlm

7805: INTO l_plan_start_date,
7806: l_plan_end_date,
7807: l_resource_alias
7808: FROM pa_resource_assignments pra,
7809: pa_resource_list_members prlm
7810: WHERE pra.budget_version_id = p_version_info_rec.x_budget_version_id
7811: AND pra.resource_list_member_id = px_budget_lines_in(i).resource_list_member_id
7812: AND pra.task_id = px_budget_lines_in(i).pa_task_id
7813: AND prlm.resource_list_member_id = pra.resource_list_member_id;