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 72: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

68: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
69: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
70: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
71: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
72: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
73: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
74: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
75: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
76: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895

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

69: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
70: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
71: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
72: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
73: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
74: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
75: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
76: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
77: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895

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

70: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
71: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
72: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
73: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
74: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
75: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
76: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
77: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
78: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

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

77: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
78: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
79: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
80: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
81: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
82: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
83: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
84: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
85: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

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

80: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
81: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
82: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
83: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
84: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
85: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
86: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
87: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
88: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

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

83: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
84: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
85: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
86: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
87: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
88: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
89: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
90: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model upgrade
91: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

Line 90: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model upgrade

86: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
87: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
88: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
89: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
90: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model upgrade
91: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
92: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
93: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
94: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

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

87: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
88: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
89: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
90: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model upgrade
91: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
92: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
93: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
94: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
95: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

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

88: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
89: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
90: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model upgrade
91: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
92: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
93: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
94: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
95: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
96: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

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

89: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
90: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model upgrade
91: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
92: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
93: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
94: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
95: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
96: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
97: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

90: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model upgrade
91: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
92: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
93: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
94: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
95: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
96: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
97: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
98: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

91: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
92: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
93: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
94: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
95: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
96: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
97: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
98: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
99: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

92: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
93: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
94: x_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
95: x_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
96: x_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
97: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
98: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
99: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
100: x_margin_pct OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

97: x_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
98: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
99: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
100: x_margin_pct OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
101: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
102: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
103: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
104: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
105: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

98: x_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
99: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
100: x_margin_pct OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
101: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
102: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
103: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
104: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
105: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
106: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

99: x_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
100: x_margin_pct OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
101: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
102: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
103: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
104: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
105: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
106: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
107:

Line 113: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

109: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
110: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
111: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
112: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
113: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
114: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
115: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
116: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
117: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895

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

110: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
111: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
112: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
113: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
114: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
115: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
116: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
117: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
118: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895

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

111: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
112: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
113: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
114: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
115: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
116: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
117: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
118: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
119: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

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

120: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
121: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
122: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
123: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
124: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
125: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
126: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
127: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
128: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

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

123: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
124: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
125: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
126: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
127: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
128: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
129: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
130: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
131: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

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

126: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
127: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
128: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
129: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
130: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
131: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
132: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
133: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
134: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

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

129: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
130: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
131: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
132: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
133: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
134: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
135: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
136: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
137: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

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

132: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
133: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
134: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
135: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
136: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
137: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
138: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
139: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
140: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

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

135: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
136: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
137: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
138: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
139: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
140: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
141: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
142: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
143: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

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

138: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
139: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
140: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
141: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
142: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
143: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
144: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
145: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
146: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

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

141: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
142: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
143: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
144: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
145: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
146: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
147: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
148: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
149: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

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

144: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
145: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
146: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
147: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
148: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
149: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
150: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
151: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
152: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

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

147: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
148: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
149: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
150: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
151: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
152: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
153: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
154: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
155: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

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

148: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
149: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
150: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
151: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
152: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
153: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
154: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
155: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
156: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

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

149: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
150: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
151: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
152: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
153: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
154: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
155: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
156: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
157: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

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

150: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
151: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
152: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
153: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
154: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
155: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
156: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
157: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
158: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

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

151: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
152: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
153: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
154: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
155: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
156: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
157: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
158: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
159: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

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

152: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
153: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
154: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
155: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
156: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
157: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
158: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
159: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
160: x_act_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

153: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
154: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
155: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
156: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
157: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
158: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
159: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
160: x_act_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
161: x_act_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

154: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
155: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
156: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
157: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
158: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
159: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
160: x_act_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
161: x_act_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
162: x_act_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

155: x_etc_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
156: x_etc_avg_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
157: x_act_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
158: x_etc_init_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
159: x_etc_avg_burd_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
160: x_act_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
161: x_act_margin_proj_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
162: x_act_margin_proj_func_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
163: x_etc_margin_txn_cur OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 178: P_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

174: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
175:
176: procedure get_initial_budget_line_info
177: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
178: P_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
179: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
180: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
181: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
182: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895

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

175:
176: procedure get_initial_budget_line_info
177: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
178: P_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
179: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
180: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
181: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
182: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
183: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895

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

176: procedure get_initial_budget_line_info
177: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
178: P_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
179: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
180: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
181: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
182: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
183: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
184: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895

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

177: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
178: P_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
179: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
180: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
181: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
182: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
183: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
184: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
185: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895

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

178: P_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
179: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
180: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
181: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
182: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
183: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
184: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
185: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
186: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895

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

179: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
180: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
181: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
182: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
183: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
184: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
185: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
186: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
187: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895

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

180: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
181: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
182: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
183: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
184: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
185: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
186: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
187: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
188: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895

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

181: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
182: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
183: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
184: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
185: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
186: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
187: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
188: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
189: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895

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

182: x_end_date OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
183: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
184: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
185: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
186: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
187: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
188: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
189: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
190: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895

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

183: x_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
184: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
185: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
186: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
187: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
188: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
189: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
190: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
191: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895

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

184: x_quantity OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
185: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
186: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
187: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
188: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
189: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
190: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
191: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895
192: x_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

185: x_txn_raw_cost OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
186: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
187: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
188: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
189: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
190: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
191: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895
192: x_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
193: x_init_burd_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

186: x_txn_burdened_cost OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
187: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
188: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
189: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
190: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
191: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895
192: x_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
193: x_init_burd_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
194: x_init_revenue_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

187: x_txn_revenue OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
188: x_init_quantity OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
189: x_txn_init_raw_cost OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
190: x_txn_init_burdened_cost OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
191: x_txn_init_revenue OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895
192: x_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
193: x_init_burd_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
194: x_init_revenue_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
195: x_etc_init_raw_cost_rate OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895