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 4081: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693

4077: l_revenue NUMBER;
4078: -- Following local variables added as part of bug 3062294
4079: l_pa_task_id pa_resource_assignments.task_id%TYPE;
4080: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4081: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4082: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes
4084: l_budget_start_date pa_budget_lines.start_date%TYPE;
4085: l_budget_end_date pa_budget_lines.start_date%TYPE;

Line 4082: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

4078: -- Following local variables added as part of bug 3062294
4079: l_pa_task_id pa_resource_assignments.task_id%TYPE;
4080: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4081: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4082: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes
4084: l_budget_start_date pa_budget_lines.start_date%TYPE;
4085: l_budget_end_date pa_budget_lines.start_date%TYPE;
4086: l_period_name pa_budget_lines.period_name%TYPE;

Line 4130: ,pa_resource_list_members prlm

4126: SELECT pr.unit_of_measure
4127: ,prlm.track_as_labor_flag
4128: FROM pa_resources pr
4129: ,pa_resource_lists prl
4130: ,pa_resource_list_members prlm
4131: WHERE prl.resource_list_id = c_resource_list_id
4132: AND pr.resource_id = prlm.resource_id
4133: AND prl.resource_list_id = prlm.resource_list_id
4134: AND prlm.resource_list_member_id = c_resource_list_member_id;

Line 5808: ,pa_resource_list_members prlm

5804: ,prlm.track_as_labor_flag
5805: ,prlm.migration_code
5806: FROM pa_resources pr
5807: ,pa_resource_lists prl
5808: ,pa_resource_list_members prlm
5809: WHERE prl.resource_list_id = c_resource_list_id
5810: AND pr.resource_id = prlm.resource_id
5811: AND prl.resource_list_id = prlm.resource_list_id
5812: AND prlm.resource_list_member_id = c_resource_list_member_id;

Line 5820: FROM pa_resource_list_members prlm

5816: (c_resource_list_member_id NUMBER)
5817: IS
5818: SELECT prlm.unit_of_measure,
5819: prlm.migration_code
5820: FROM pa_resource_list_members prlm
5821: WHERE prlm.resource_list_member_id = c_resource_list_member_id;
5822:
5823: --cursor to get the field values associated to a AMG message
5824: CURSOR l_amg_project_csr

Line 5898: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

5894: l_txn_tbl_index NUMBER;
5895: i NUMBER;
5896: l_valid_txn_curr BOOLEAN;
5897: l_txn_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5898: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
5899: l_conv_attrs_to_be_validated VARCHAR2(10);
5900: l_module_name VARCHAR2(80);
5901: l_top_task_id pa_tasks.top_task_id%TYPE;
5902: l_dummy VARCHAR2(1);

Line 5913: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;

5909: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
5910: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
5911: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;
5912: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5913: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
5914: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
5915: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5916: l_res_group_name pa_resource_list_members.alias%TYPE;
5917: l_valid_rlmid VARCHAR2(1);

Line 5914: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;

5910: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
5911: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;
5912: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5913: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
5914: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
5915: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5916: l_res_group_name pa_resource_list_members.alias%TYPE;
5917: l_valid_rlmid VARCHAR2(1);
5918: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 5915: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;

5911: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;
5912: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5913: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
5914: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
5915: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5916: l_res_group_name pa_resource_list_members.alias%TYPE;
5917: l_valid_rlmid VARCHAR2(1);
5918: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5919: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;

Line 5916: l_res_group_name pa_resource_list_members.alias%TYPE;

5912: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5913: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
5914: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
5915: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5916: l_res_group_name pa_resource_list_members.alias%TYPE;
5917: l_valid_rlmid VARCHAR2(1);
5918: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5919: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;
5920: l_context_info pa_fin_plan_types_tl.name%TYPE;

Line 5919: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;

5915: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5916: l_res_group_name pa_resource_list_members.alias%TYPE;
5917: l_valid_rlmid VARCHAR2(1);
5918: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5919: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;
5920: l_context_info pa_fin_plan_types_tl.name%TYPE;
5921: l_pm_product_code pa_budget_lines.pm_product_code%TYPE;
5922:
5923: -- Cursor used in validating the product code

Line 6007: l_resource_alias pa_resource_list_members.alias%type;

6003: l_plan_end_date_tbl varchr_32_index_date_tbl_typ;
6004: l_task_name_tbl varchr_32_index_varchr_tbl_typ;
6005: l_resource_alias_tbl varchr_32_index_varchr_tbl_typ;
6006: l_distinct_taskid_rlmid_index VARCHAR2(32); --Index to store task id and rlm id comnination.
6007: l_resource_alias pa_resource_list_members.alias%type;
6008:
6009: TYPE varchr_120_index_num_tbl_typ IS TABLE OF NUMBER(15) INDEX BY VARCHAR2(120);
6010: l_distinct_rlmid_idx VARCHAR2(120); --Index to store rlm id and resource alias
6011: l_rlm_id_tbl varchr_120_index_num_tbl_typ;

Line 7267: FROM pa_resource_list_members

7263: ,alias
7264: INTO l_parent_member_id
7265: ,l_resource_type_code
7266: ,pa_budget_pvt.g_resource_alias
7267: FROM pa_resource_list_members
7268: WHERE resource_list_member_id = px_budget_lines_in(i).resource_list_member_id;
7269:
7270: IF l_resource_type_code = 'UNCLASSIFIED' THEN
7271:

Line 7385: FROM pa_resource_list_members

7381: IF p_calling_context= 'UPDATE_PLANNING_ELEMENT_ATTR' then
7382: IF l_valid_rlmid ='Y' then
7383: SELECT ALIAS
7384: INTO px_budget_lines_in(i).resource_alias
7385: FROM pa_resource_list_members
7386: WHERE resource_list_member_id = px_budget_lines_in(i).resource_list_member_id;
7387: END IF;
7388: -- DBMS_OUTPUT.PUT_LINE('resource alias '||i||' '||px_budget_lines_in(i).resource_alias);
7389: END IF;

Line 7892: FROM pa_resource_list_members

7888: ELSE
7889:
7890: SELECT alias
7891: INTO px_budget_lines_in(i).resource_alias
7892: FROM pa_resource_list_members
7893: WHERE resource_list_member_id = px_budget_lines_in(i).resource_list_member_id;
7894:
7895: l_resource_alias := px_budget_lines_in(i).resource_alias;
7896:

Line 7926: pa_resource_list_members prlm

7922: INTO l_plan_start_date,
7923: l_plan_end_date,
7924: l_resource_alias
7925: FROM pa_resource_assignments pra,
7926: pa_resource_list_members prlm
7927: WHERE pra.budget_version_id = p_version_info_rec.x_budget_version_id
7928: AND pra.resource_list_member_id = px_budget_lines_in(i).resource_list_member_id
7929: AND pra.task_id = px_budget_lines_in(i).pa_task_id
7930: AND NVL(pra.CBS_ELEMENT_ID,-1) = NVL(px_budget_lines_in(i).cbs_element_id,-1) --16604257