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

Line 158: ,px_resource_list_name IN OUT NOCOPY pa_resource_lists_tl.name%TYPE --File.Sql.39 bug 4440895

154: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE
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

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 4129: ,pa_resource_lists prl

4125: IS
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

Line 5698: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE

5694: ,p_pa_project_id IN pa_projects_all.project_id%TYPE
5695: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
5696: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5697: ,p_version_type IN pa_budget_versions.version_type%TYPE
5698: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
5699: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
5700: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
5701: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
5702: ,p_allow_qty_flag IN VARCHAR2

Line 5807: ,pa_resource_lists prl

5803: SELECT pr.unit_of_measure
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

Line 5953: l_rlm_migration_code pa_resource_lists_all_bg.migration_code%TYPE;

5949: TYPE web_adi_err_code_lookup IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30);
5950: l_wa_error_code_lookup web_adi_err_code_lookup;
5951:
5952: -- for bug 3954329
5953: l_rlm_migration_code pa_resource_lists_all_bg.migration_code%TYPE;
5954:
5955: l_wa_project_cost_rate_typ pa_proj_fp_options.project_cost_rate_type%TYPE;
5956: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;
5957: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;

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

8664: l_tmp_return_status VARCHAR2(1);
8665: I NUMBER;
8666: l_count NUMBER;
8667: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; -- Added for BUG 6847497
8668: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE; -- Added for BUG 6847497
8669: l_budget_type_code pa_budget_versions.budget_type_code%TYPE; -- Added for BUG 6653796
8670:
8671: CURSOR get_primary_key_csr IS
8672: SELECT ra.task_id,

Line 8794: FROM pa_proj_fp_options , pa_resource_lists_all_bg prl

8790:
8791: SELECT nvl(cost_time_phased_code,NVL(revenue_time_phased_code,all_time_phased_code)), -- Added for BUG 6847497
8792: prl.uncategorized_flag
8793: INTO l_time_phased_code, l_uncategorized_flag
8794: FROM pa_proj_fp_options , pa_resource_lists_all_bg prl
8795: WHERE fin_plan_version_id=p_fin_plan_version_id
8796: AND nvl(cost_resource_list_id,nvl(revenue_resource_list_id,all_resource_list_id))=
8797: prl.resource_list_id;
8798: