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_LISTS_ALL_BG

Line 159: ,px_resource_list_id IN OUT NOCOPY pa_resource_lists_all_bg.resource_list_id%TYPE --File.Sql.39 bug 4440895

155: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
156: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
157: ,p_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
158: ,px_resource_list_name IN OUT NOCOPY pa_resource_lists_tl.name%TYPE --File.Sql.39 bug 4440895
159: ,px_resource_list_id IN OUT NOCOPY pa_resource_lists_all_bg.resource_list_id%TYPE --File.Sql.39 bug 4440895
160: ,px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
161: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
162: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
163: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895

Line 397: l_uncategorized_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

393: l_encum_type_id NUMBER := NULL;
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);

Line 451: px_resource_list_id_in pa_resource_lists_all_bg.resource_list_id%TYPE;

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;
453:
454: BEGIN
455:

Line 1114: FROM pa_resource_lists_all_bg

1110: /* changes for bug 3954329: following check included */
1111: BEGIN
1112: SELECT migration_code
1113: INTO l_res_list_migration_code
1114: FROM pa_resource_lists_all_bg
1115: WHERE resource_list_id = px_resource_list_id;
1116: EXCEPTION
1117: WHEN NO_DATA_FOUND THEN
1118: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1791: FROM pa_resource_lists_all_bg

1787: /* changes for bug 3954329: following check included */
1788: BEGIN
1789: SELECT migration_code
1790: INTO l_res_list_migration_code
1791: FROM pa_resource_lists_all_bg
1792: WHERE resource_list_id = px_resource_list_id;
1793: EXCEPTION
1794: WHEN NO_DATA_FOUND THEN
1795: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5681: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE

5677: ,p_pa_project_id IN pa_projects_all.project_id%TYPE
5678: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
5679: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5680: ,p_version_type IN pa_budget_versions.version_type%TYPE
5681: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
5682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
5683: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
5684: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
5685: ,p_allow_qty_flag IN VARCHAR2

Line 5936: l_rlm_migration_code pa_resource_lists_all_bg.migration_code%TYPE;

5932: TYPE web_adi_err_code_lookup IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30);
5933: l_wa_error_code_lookup web_adi_err_code_lookup;
5934:
5935: -- for bug 3954329
5936: l_rlm_migration_code pa_resource_lists_all_bg.migration_code%TYPE;
5937:
5938: l_wa_project_cost_rate_typ pa_proj_fp_options.project_cost_rate_type%TYPE;
5939: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;
5940: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;

Line 8550: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE; -- Added for BUG 6847497

8546: l_tmp_return_status VARCHAR2(1);
8547: I NUMBER;
8548: l_count NUMBER;
8549: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; -- Added for BUG 6847497
8550: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE; -- Added for BUG 6847497
8551:
8552: CURSOR get_primary_key_csr IS
8553: SELECT ra.task_id,
8554: ra.resource_list_member_id,

Line 8661: FROM pa_proj_fp_options , pa_resource_lists_all_bg prl

8657:
8658: SELECT nvl(cost_time_phased_code,NVL(revenue_time_phased_code,all_time_phased_code)), -- Added for BUG 6847497
8659: prl.uncategorized_flag
8660: INTO l_time_phased_code, l_uncategorized_flag
8661: FROM pa_proj_fp_options , pa_resource_lists_all_bg prl
8662: WHERE fin_plan_version_id=p_fin_plan_version_id
8663: AND nvl(cost_resource_list_id,nvl(revenue_resource_list_id,all_resource_list_id))=
8664: prl.resource_list_id;
8665: