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_PLANNING_ELEMENT_UTILS dependencies on PA_BUDGET_LINES

Line 683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

679: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
680: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
681: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
682: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
686: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895

Line 684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),

680: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
681: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
682: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
686: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895

Line 685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),

681: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
682: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
686: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

Line 692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895

688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895

691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895

694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes
702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

Line 701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes

697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes
702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
704: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
705: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes
702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
704: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
705: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
706: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes
702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
704: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
705: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
706: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
707: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 704: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes
702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
704: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
705: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
706: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
707: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
708: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 705: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes
702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
704: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
705: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
706: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
707: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
708: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
709: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 706: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
704: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
705: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
706: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
707: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
708: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
709: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
710: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 707: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
704: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
705: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
706: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
707: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
708: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
709: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
710: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
711: x_margin_pct OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 712: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

708: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
709: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
710: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
711: x_margin_pct OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
712: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
713: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
714: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
715: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
716: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 713: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

709: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
710: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
711: x_margin_pct OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
712: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
713: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
714: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
715: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
716: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
717: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

Line 714: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

710: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
711: x_margin_pct OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
712: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
713: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
714: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
715: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
716: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
717: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
718:

Line 727: l_start_date pa_budget_lines.start_date%TYPE;

723: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
724:
725: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
726:
727: l_start_date pa_budget_lines.start_date%TYPE;
728: l_end_date pa_budget_lines.end_date%TYPE;
729: l_period_name pa_budget_lines.period_name%TYPE;
730: l_quantity pa_budget_lines.quantity%TYPE;
731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;

Line 728: l_end_date pa_budget_lines.end_date%TYPE;

724:
725: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
726:
727: l_start_date pa_budget_lines.start_date%TYPE;
728: l_end_date pa_budget_lines.end_date%TYPE;
729: l_period_name pa_budget_lines.period_name%TYPE;
730: l_quantity pa_budget_lines.quantity%TYPE;
731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

Line 729: l_period_name pa_budget_lines.period_name%TYPE;

725: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
726:
727: l_start_date pa_budget_lines.start_date%TYPE;
728: l_end_date pa_budget_lines.end_date%TYPE;
729: l_period_name pa_budget_lines.period_name%TYPE;
730: l_quantity pa_budget_lines.quantity%TYPE;
731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
733: l_txn_revenue pa_budget_lines.revenue%TYPE;

Line 730: l_quantity pa_budget_lines.quantity%TYPE;

726:
727: l_start_date pa_budget_lines.start_date%TYPE;
728: l_end_date pa_budget_lines.end_date%TYPE;
729: l_period_name pa_budget_lines.period_name%TYPE;
730: l_quantity pa_budget_lines.quantity%TYPE;
731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
733: l_txn_revenue pa_budget_lines.revenue%TYPE;
734: l_init_quantity pa_budget_lines.init_quantity%TYPE;

Line 731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;

727: l_start_date pa_budget_lines.start_date%TYPE;
728: l_end_date pa_budget_lines.end_date%TYPE;
729: l_period_name pa_budget_lines.period_name%TYPE;
730: l_quantity pa_budget_lines.quantity%TYPE;
731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
733: l_txn_revenue pa_budget_lines.revenue%TYPE;
734: l_init_quantity pa_budget_lines.init_quantity%TYPE;
735: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

Line 732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

728: l_end_date pa_budget_lines.end_date%TYPE;
729: l_period_name pa_budget_lines.period_name%TYPE;
730: l_quantity pa_budget_lines.quantity%TYPE;
731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
733: l_txn_revenue pa_budget_lines.revenue%TYPE;
734: l_init_quantity pa_budget_lines.init_quantity%TYPE;
735: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
736: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

Line 733: l_txn_revenue pa_budget_lines.revenue%TYPE;

729: l_period_name pa_budget_lines.period_name%TYPE;
730: l_quantity pa_budget_lines.quantity%TYPE;
731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
733: l_txn_revenue pa_budget_lines.revenue%TYPE;
734: l_init_quantity pa_budget_lines.init_quantity%TYPE;
735: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
736: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
737: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;

Line 734: l_init_quantity pa_budget_lines.init_quantity%TYPE;

730: l_quantity pa_budget_lines.quantity%TYPE;
731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
733: l_txn_revenue pa_budget_lines.revenue%TYPE;
734: l_init_quantity pa_budget_lines.init_quantity%TYPE;
735: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
736: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
737: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
738: l_init_raw_cost_rate NUMBER;

Line 735: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

731: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
733: l_txn_revenue pa_budget_lines.revenue%TYPE;
734: l_init_quantity pa_budget_lines.init_quantity%TYPE;
735: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
736: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
737: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
738: l_init_raw_cost_rate NUMBER;
739: l_init_burd_cost_rate NUMBER;

Line 736: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

732: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
733: l_txn_revenue pa_budget_lines.revenue%TYPE;
734: l_init_quantity pa_budget_lines.init_quantity%TYPE;
735: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
736: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
737: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
738: l_init_raw_cost_rate NUMBER;
739: l_init_burd_cost_rate NUMBER;
740: l_init_revenue_rate NUMBER;

Line 737: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;

733: l_txn_revenue pa_budget_lines.revenue%TYPE;
734: l_init_quantity pa_budget_lines.init_quantity%TYPE;
735: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
736: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
737: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
738: l_init_raw_cost_rate NUMBER;
739: l_init_burd_cost_rate NUMBER;
740: l_init_revenue_rate NUMBER;
741: l_etc_init_raw_cost_rate NUMBER;

Line 757: from pa_budget_lines

753: raid_rec raid_csr%ROWTYPE;
754:
755: cursor budget_lines_csr is
756: select 'Y'
757: from pa_budget_lines
758: where resource_assignment_id = l_resource_assignment_id and
759: txn_currency_code = p_txn_currency_code;
760: budget_lines_rec budget_lines_csr%ROWTYPE;
761:

Line 766: -- with pa_budget_lines once again because this cursor is called

762: -- Bug Fix 3732157
763: -- Moving the code from the body to here as a cursor.
764:
765: -- Bug 6459226: Replacing the queries from pa_resource_asgn_curr
766: -- with pa_budget_lines once again because this cursor is called
767: -- in case budget lines exist and on Edit Budget Line page, we
768: -- have to show the periodic split up of amounts.
769:
770:

Line 773: -- Reverting the changes coz the budget line infomatin should be picked from pa_budget_lines in order view

769:
770:
771: --Bug 6836806 Modifying the cursor to display periodic level information under current budget columns
772: --for budget lines when viewed at period level data.
773: -- Reverting the changes coz the budget line infomatin should be picked from pa_budget_lines in order view
774: -- data periodically when planning start/end dates are passed.
775: CURSOR get_budget_line_amts_for_dates IS
776: select ra.planning_start_date,
777: ra.planning_end_date,

Line 845: pa_budget_lines bl,

841: 0, 0,
842: null, 0,
843: (SUM(bl.txn_burdened_cost) - SUM(nvl(bl.txn_init_burdened_cost,0)))/(SUM(bl.quantity) - SUM(nvl(init_quantity,0))))
844: from pa_resource_assignments ra,
845: pa_budget_lines bl,
846: pa_budget_versions bv,
847: pa_proj_fp_options po
848: where ra.resource_assignment_id = l_resource_assignment_id and
849: ra.resource_assignment_id = bl.resource_assignment_id and

Line 972: -- -- pa_budget_lines bl,

968: -- (SUM(bl.txn_burdened_cost) - SUM(NVL(bl.txn_init_burdened_cost,0)))/(SUM(bl.quantity) - SUM(NVL(init_quantity,0))))
969: -- */
970: -- DECODE(ra.rate_based_flag, 'Y', rac.txn_etc_burden_cost_rate, TO_NUMBER(NULL))
971: -- FROM pa_resource_assignments ra,
972: -- -- pa_budget_lines bl,
973: -- pa_resource_asgn_curr rac,
974: -- pa_budget_versions bv,
975: -- pa_proj_fp_options po
976: -- WHERE ra.resource_assignment_id = l_resource_assignment_id AND

Line 1185: -- budget lines exist, so query pa_resource_assignment and pa_budget_lines

1181: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',
1182: p_procedure_name => 'get_common_budget_version_info');
1183: end;
1184: else
1185: -- budget lines exist, so query pa_resource_assignment and pa_budget_lines
1186: -- Bug Fix 3732157.
1187: -- Budget lines cursor is not considering the dates while checking the
1188: -- lines existence. While fetching the data within a certain date range
1189: -- is failing as the lines doesnt exist in that range.

Line 1399: -- pa_budget_lines bl,

1395: x_etc_avg_rev_rate,
1396: x_etc_avg_raw_cost_rate,
1397: x_etc_avg_burd_cost_rate
1398: FROM pa_resource_assignments ra,
1399: -- pa_budget_lines bl,
1400: pa_resource_asgn_curr rac,
1401: pa_budget_versions bv,
1402: pa_proj_fp_options po
1403: WHERE ra.resource_assignment_id = l_resource_assignment_id AND

Line 1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

1513: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1514: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
1515: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
1516: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
1520: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895

Line 1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),

1514: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
1515: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
1516: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
1520: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895

Line 1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),

1515: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
1516: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
1520: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

Line 1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895

1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

Line 1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895

1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

Line 1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895

1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895

1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895

1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895

1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895

1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895

1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895

1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

Line 1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1560: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1560: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1561: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1560: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1561: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1562: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1560: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1561: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1562: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1563: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 1560: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1560: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1561: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1562: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1563: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1564: x_act_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1561: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1560: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1561: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1562: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1563: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1564: x_act_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1565: x_act_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1562: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1560: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1561: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1562: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1563: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1564: x_act_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1565: x_act_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1566: x_act_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1563: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

1559: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1560: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1561: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1562: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1563: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
1564: x_act_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1565: x_act_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1566: x_act_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1567: x_etc_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1589: l_start_date pa_budget_lines.start_date%TYPE;

1585: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1586:
1587: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
1588:
1589: l_start_date pa_budget_lines.start_date%TYPE;
1590: l_end_date pa_budget_lines.end_date%TYPE;
1591: l_period_name pa_budget_lines.period_name%TYPE;
1592: l_quantity pa_budget_lines.quantity%TYPE;
1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;

Line 1590: l_end_date pa_budget_lines.end_date%TYPE;

1586:
1587: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
1588:
1589: l_start_date pa_budget_lines.start_date%TYPE;
1590: l_end_date pa_budget_lines.end_date%TYPE;
1591: l_period_name pa_budget_lines.period_name%TYPE;
1592: l_quantity pa_budget_lines.quantity%TYPE;
1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

Line 1591: l_period_name pa_budget_lines.period_name%TYPE;

1587: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
1588:
1589: l_start_date pa_budget_lines.start_date%TYPE;
1590: l_end_date pa_budget_lines.end_date%TYPE;
1591: l_period_name pa_budget_lines.period_name%TYPE;
1592: l_quantity pa_budget_lines.quantity%TYPE;
1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
1595: l_txn_revenue pa_budget_lines.revenue%TYPE;

Line 1592: l_quantity pa_budget_lines.quantity%TYPE;

1588:
1589: l_start_date pa_budget_lines.start_date%TYPE;
1590: l_end_date pa_budget_lines.end_date%TYPE;
1591: l_period_name pa_budget_lines.period_name%TYPE;
1592: l_quantity pa_budget_lines.quantity%TYPE;
1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
1595: l_txn_revenue pa_budget_lines.revenue%TYPE;
1596: l_init_quantity pa_budget_lines.init_quantity%TYPE;

Line 1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;

1589: l_start_date pa_budget_lines.start_date%TYPE;
1590: l_end_date pa_budget_lines.end_date%TYPE;
1591: l_period_name pa_budget_lines.period_name%TYPE;
1592: l_quantity pa_budget_lines.quantity%TYPE;
1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
1595: l_txn_revenue pa_budget_lines.revenue%TYPE;
1596: l_init_quantity pa_budget_lines.init_quantity%TYPE;
1597: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

Line 1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

1590: l_end_date pa_budget_lines.end_date%TYPE;
1591: l_period_name pa_budget_lines.period_name%TYPE;
1592: l_quantity pa_budget_lines.quantity%TYPE;
1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
1595: l_txn_revenue pa_budget_lines.revenue%TYPE;
1596: l_init_quantity pa_budget_lines.init_quantity%TYPE;
1597: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
1598: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

Line 1595: l_txn_revenue pa_budget_lines.revenue%TYPE;

1591: l_period_name pa_budget_lines.period_name%TYPE;
1592: l_quantity pa_budget_lines.quantity%TYPE;
1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
1595: l_txn_revenue pa_budget_lines.revenue%TYPE;
1596: l_init_quantity pa_budget_lines.init_quantity%TYPE;
1597: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
1598: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
1599: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;

Line 1596: l_init_quantity pa_budget_lines.init_quantity%TYPE;

1592: l_quantity pa_budget_lines.quantity%TYPE;
1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
1595: l_txn_revenue pa_budget_lines.revenue%TYPE;
1596: l_init_quantity pa_budget_lines.init_quantity%TYPE;
1597: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
1598: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
1599: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
1600: l_init_raw_cost_rate NUMBER;

Line 1597: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

1593: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
1595: l_txn_revenue pa_budget_lines.revenue%TYPE;
1596: l_init_quantity pa_budget_lines.init_quantity%TYPE;
1597: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
1598: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
1599: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
1600: l_init_raw_cost_rate NUMBER;
1601: l_init_burd_cost_rate NUMBER;

Line 1598: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

1594: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
1595: l_txn_revenue pa_budget_lines.revenue%TYPE;
1596: l_init_quantity pa_budget_lines.init_quantity%TYPE;
1597: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
1598: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
1599: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
1600: l_init_raw_cost_rate NUMBER;
1601: l_init_burd_cost_rate NUMBER;
1602: l_init_revenue_rate NUMBER;

Line 1599: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;

1595: l_txn_revenue pa_budget_lines.revenue%TYPE;
1596: l_init_quantity pa_budget_lines.init_quantity%TYPE;
1597: l_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
1598: l_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
1599: l_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
1600: l_init_raw_cost_rate NUMBER;
1601: l_init_burd_cost_rate NUMBER;
1602: l_init_revenue_rate NUMBER;
1603: l_etc_init_raw_cost_rate NUMBER;

Line 1619: from pa_budget_lines

1615: raid_rec raid_csr%ROWTYPE;
1616:
1617: cursor budget_lines_csr is
1618: select 'Y'
1619: from pa_budget_lines
1620: where resource_assignment_id = l_resource_assignment_id and
1621: txn_currency_code = p_txn_currency_code;
1622: budget_lines_rec budget_lines_csr%ROWTYPE;
1623:

Line 1756: -- pa_budget_lines bl,

1752: NULL, -- x_etc_margin_pct (TO BE POPULATED)
1753: NULL, -- x_fcst_margin_pct (TO BE POPULATED)
1754: po.margin_derived_from_code
1755: FROM pa_resource_assignments ra,
1756: -- pa_budget_lines bl,
1757: pa_resource_asgn_curr rac,
1758: pa_budget_versions bv,
1759: pa_proj_fp_options po
1760: WHERE ra.resource_assignment_id = l_resource_assignment_id AND

Line 2059: -- budget lines exist, so query pa_resource_assignment and pa_budget_lines

2055: end if; -- x_fcst_revenue_proj_cur = 0
2056: end if;
2057:
2058: else
2059: -- budget lines exist, so query pa_resource_assignment and pa_budget_lines
2060: IF p_line_start_date IS NOT NULL AND p_line_end_date IS NOT NULL THEN
2061:
2062: OPEN get_fcst_line_amts_for_dates;
2063: FETCH get_fcst_line_amts_for_dates INTO

Line 2370: -- pa_budget_lines bl,

2366: x_etc_margin_pct,
2367: x_fcst_margin_pct,
2368: l_margin_derived_from_code
2369: FROM pa_resource_assignments ra,
2370: -- pa_budget_lines bl,
2371: pa_resource_asgn_curr rac,
2372: pa_budget_versions bv,
2373: pa_proj_fp_options po
2374: where ra.resource_assignment_id = l_resource_assignment_id and

Line 2527: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

2523:
2524:
2525: procedure get_initial_budget_line_info
2526: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
2527: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
2528: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
2529: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895

Line 2528: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),

2524:
2525: procedure get_initial_budget_line_info
2526: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
2527: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
2528: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
2529: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895

Line 2529: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),

2525: procedure get_initial_budget_line_info
2526: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
2527: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
2528: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
2529: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895

Line 2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895

2526: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
2527: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
2528: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
2529: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895

2527: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
2528: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
2529: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895

2528: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
2529: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895

Line 2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895

2529: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
2537: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895

Line 2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895

2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
2537: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
2538: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895

2531: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
2537: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
2538: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
2539: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895

2532: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
2537: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
2538: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
2539: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
2540: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895

Line 2537: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895

2533: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
2537: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
2538: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
2539: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
2540: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895
2541: x_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2538: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895

2534: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
2537: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
2538: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
2539: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
2540: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895
2541: x_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2542: x_init_burd_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2539: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895

2535: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
2537: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
2538: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
2539: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
2540: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895
2541: x_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2542: x_init_burd_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2543: x_init_revenue_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2540: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895

2536: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
2537: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
2538: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
2539: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
2540: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895
2541: x_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2542: x_init_burd_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2543: x_init_revenue_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2544: x_etc_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2577: from pa_budget_lines bl

2573: x_init_quantity,
2574: x_txn_init_raw_cost,
2575: x_txn_init_burdened_cost,
2576: x_txn_init_revenue
2577: from pa_budget_lines bl
2578: where bl.resource_assignment_id = p_resource_assignment_id and
2579: bl.txn_currency_code = p_txn_currency_code and
2580: bl.start_date BETWEEN p_line_start_date and p_line_end_date and
2581: start_date = (select min(start_date)

Line 2582: from pa_budget_lines

2578: where bl.resource_assignment_id = p_resource_assignment_id and
2579: bl.txn_currency_code = p_txn_currency_code and
2580: bl.start_date BETWEEN p_line_start_date and p_line_end_date and
2581: start_date = (select min(start_date)
2582: from pa_budget_lines
2583: where resource_assignment_id = p_resource_assignment_id and
2584: txn_currency_code = p_txn_currency_code);
2585: ELSE -- p_line_start_date IS NULL AND/OR p_line_end_date IS NULL
2586: select bl.start_date,

Line 2609: from pa_budget_lines bl

2605: x_init_quantity,
2606: x_txn_init_raw_cost,
2607: x_txn_init_burdened_cost,
2608: x_txn_init_revenue
2609: from pa_budget_lines bl
2610: where bl.resource_assignment_id = p_resource_assignment_id and
2611: bl.txn_currency_code = p_txn_currency_code and
2612: start_date = (select min(start_date)
2613: from pa_budget_lines

Line 2613: from pa_budget_lines

2609: from pa_budget_lines bl
2610: where bl.resource_assignment_id = p_resource_assignment_id and
2611: bl.txn_currency_code = p_txn_currency_code and
2612: start_date = (select min(start_date)
2613: from pa_budget_lines
2614: where resource_assignment_id = p_resource_assignment_id and
2615: txn_currency_code = p_txn_currency_code);
2616: END IF; -- p_line_start_date IS NOT NULL AND p_line_end_date IS NOT NULL
2617: -- CALCULATE THE RATES

Line 2836: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA,PA_PROJ_ELEMENT_VERSIONS PEV

2832: SELECT 'Y'
2833: INTO l_bl_already_exists
2834: FROM DUAL
2835: WHERE EXISTS ( SELECT 1
2836: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA,PA_PROJ_ELEMENT_VERSIONS PEV
2837: WHERE PRA.PROJECT_ID = p_project_id
2838: AND PRA.BUDGET_VERSION_ID = p_budget_version_id
2839: AND PRA.RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id_tbl(i)
2840: AND PEV.PROJ_ELEMENT_ID = PRA.TASK_ID

Line 2873: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA

2869: SELECT 'Y'
2870: INTO l_bl_already_exists
2871: FROM DUAL
2872: WHERE EXISTS ( SELECT 1
2873: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA
2874: --,PA_PROJ_ELEMENT_VERSIONS PEV /* Bug 4884718; SQL ID 14903213 */
2875: WHERE PRA.PROJECT_ID = p_project_id
2876: AND PRA.BUDGET_VERSION_ID = p_budget_version_id
2877: AND PRA.RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id_tbl(i)