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_CLIENT_EXTN_BUDGET_WF dependencies on PA_BUDGET_VERSIONS

Line 52: -- p_pm_product_code - The PM vendor's product code stored in pa_budget_versions.

48: -- IN Parameters
49: -- p_project_id - Unique identifier for the project of the budget for which approval
50: -- is requested.
51: -- p_budget_type_code - Unique identifier for budget submitted for approval
52: -- p_pm_product_code - The PM vendor's product code stored in pa_budget_versions.
53: --
54: -- OUT Parameters
55: -- p_result - 'T' or 'F' (True/False)
56: -- p_err_code - Standard error code: 0, Success; x < 0, Unexpected Error;

Line 369: FROM pa_budget_versions

365: ,version_name
366: ,budget_type_code
367: ,fin_plan_type_id
368: ,version_type
369: FROM pa_budget_versions
370: WHERE budget_version_id = p_draft_version_id
371: AND budget_status_code = 'S';
372: --
373: CURSOR l_resource_list_csr( p_resource_list_id NUMBER )

Line 436: l_pm_budget_reference pa_budget_versions.pm_budget_reference%TYPE;

432: l_carrying_out_org_id NUMBER;
433: l_carrying_out_org_name hr_organization_units.name%TYPE;
434: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
435:
436: l_pm_budget_reference pa_budget_versions.pm_budget_reference%TYPE;
437: l_budget_description pa_budget_versions.description%TYPE;
438: l_budget_change_reason_code pa_budget_versions.change_reason_code%TYPE;
439: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
440: l_budget_entry_method pa_budget_entry_methods.budget_entry_method%TYPE;

Line 437: l_budget_description pa_budget_versions.description%TYPE;

433: l_carrying_out_org_name hr_organization_units.name%TYPE;
434: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
435:
436: l_pm_budget_reference pa_budget_versions.pm_budget_reference%TYPE;
437: l_budget_description pa_budget_versions.description%TYPE;
438: l_budget_change_reason_code pa_budget_versions.change_reason_code%TYPE;
439: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
440: l_budget_entry_method pa_budget_entry_methods.budget_entry_method%TYPE;
441: l_pm_budget_product_code pa_budget_versions.pm_product_code%TYPE;

Line 438: l_budget_change_reason_code pa_budget_versions.change_reason_code%TYPE;

434: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
435:
436: l_pm_budget_reference pa_budget_versions.pm_budget_reference%TYPE;
437: l_budget_description pa_budget_versions.description%TYPE;
438: l_budget_change_reason_code pa_budget_versions.change_reason_code%TYPE;
439: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
440: l_budget_entry_method pa_budget_entry_methods.budget_entry_method%TYPE;
441: l_pm_budget_product_code pa_budget_versions.pm_product_code%TYPE;
442: l_mark_as_original pa_budget_versions.original_flag%TYPE;

Line 439: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;

435:
436: l_pm_budget_reference pa_budget_versions.pm_budget_reference%TYPE;
437: l_budget_description pa_budget_versions.description%TYPE;
438: l_budget_change_reason_code pa_budget_versions.change_reason_code%TYPE;
439: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
440: l_budget_entry_method pa_budget_entry_methods.budget_entry_method%TYPE;
441: l_pm_budget_product_code pa_budget_versions.pm_product_code%TYPE;
442: l_mark_as_original pa_budget_versions.original_flag%TYPE;
443: l_version_name pa_budget_versions.version_name%TYPE;

Line 441: l_pm_budget_product_code pa_budget_versions.pm_product_code%TYPE;

437: l_budget_description pa_budget_versions.description%TYPE;
438: l_budget_change_reason_code pa_budget_versions.change_reason_code%TYPE;
439: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
440: l_budget_entry_method pa_budget_entry_methods.budget_entry_method%TYPE;
441: l_pm_budget_product_code pa_budget_versions.pm_product_code%TYPE;
442: l_mark_as_original pa_budget_versions.original_flag%TYPE;
443: l_version_name pa_budget_versions.version_name%TYPE;
444: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
445:

Line 442: l_mark_as_original pa_budget_versions.original_flag%TYPE;

438: l_budget_change_reason_code pa_budget_versions.change_reason_code%TYPE;
439: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
440: l_budget_entry_method pa_budget_entry_methods.budget_entry_method%TYPE;
441: l_pm_budget_product_code pa_budget_versions.pm_product_code%TYPE;
442: l_mark_as_original pa_budget_versions.original_flag%TYPE;
443: l_version_name pa_budget_versions.version_name%TYPE;
444: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
445:
446: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

Line 443: l_version_name pa_budget_versions.version_name%TYPE;

439: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
440: l_budget_entry_method pa_budget_entry_methods.budget_entry_method%TYPE;
441: l_pm_budget_product_code pa_budget_versions.pm_product_code%TYPE;
442: l_mark_as_original pa_budget_versions.original_flag%TYPE;
443: l_version_name pa_budget_versions.version_name%TYPE;
444: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
445:
446: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
447: l_version_type pa_budget_versions.version_type%TYPE;

Line 444: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

440: l_budget_entry_method pa_budget_entry_methods.budget_entry_method%TYPE;
441: l_pm_budget_product_code pa_budget_versions.pm_product_code%TYPE;
442: l_mark_as_original pa_budget_versions.original_flag%TYPE;
443: l_version_name pa_budget_versions.version_name%TYPE;
444: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
445:
446: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
447: l_version_type pa_budget_versions.version_type%TYPE;
448: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 446: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

442: l_mark_as_original pa_budget_versions.original_flag%TYPE;
443: l_version_name pa_budget_versions.version_name%TYPE;
444: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
445:
446: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
447: l_version_type pa_budget_versions.version_type%TYPE;
448: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
449: l_fin_plan_level pa_lookups.meaning%TYPE;
450: l_fin_plan_time_phase pa_lookups.meaning%TYPE;

Line 447: l_version_type pa_budget_versions.version_type%TYPE;

443: l_version_name pa_budget_versions.version_name%TYPE;
444: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
445:
446: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
447: l_version_type pa_budget_versions.version_type%TYPE;
448: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
449: l_fin_plan_level pa_lookups.meaning%TYPE;
450: l_fin_plan_time_phase pa_lookups.meaning%TYPE;
451: