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_FP_CALC_PLAN_PKG dependencies on PA_PLSQL_DATATYPES

Line 107: g_mrc_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;

103: TYPE mrc_fpTab IS TABLE OF mrc_fpRec INDEX BY BINARY_INTEGER;
104: G_FP_MRC_TAB mrc_fpTab;
105: */
106: /* declare global plsql tabls for mrc enhancements */
107: g_mrc_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
108: g_mrc_res_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
109: g_mrc_txn_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
110: g_mrc_start_date_tab pa_plsql_datatypes.DateTabTyp;
111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 108: g_mrc_res_assignment_id_tab pa_plsql_datatypes.NumTabTyp;

104: G_FP_MRC_TAB mrc_fpTab;
105: */
106: /* declare global plsql tabls for mrc enhancements */
107: g_mrc_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
108: g_mrc_res_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
109: g_mrc_txn_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
110: g_mrc_start_date_tab pa_plsql_datatypes.DateTabTyp;
111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;
112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;

Line 109: g_mrc_txn_curr_code_tab pa_plsql_datatypes.Char80TabTyp;

105: */
106: /* declare global plsql tabls for mrc enhancements */
107: g_mrc_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
108: g_mrc_res_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
109: g_mrc_txn_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
110: g_mrc_start_date_tab pa_plsql_datatypes.DateTabTyp;
111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;
112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;
113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 110: g_mrc_start_date_tab pa_plsql_datatypes.DateTabTyp;

106: /* declare global plsql tabls for mrc enhancements */
107: g_mrc_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
108: g_mrc_res_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
109: g_mrc_txn_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
110: g_mrc_start_date_tab pa_plsql_datatypes.DateTabTyp;
111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;
112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;
113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;
114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;

107: g_mrc_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
108: g_mrc_res_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
109: g_mrc_txn_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
110: g_mrc_start_date_tab pa_plsql_datatypes.DateTabTyp;
111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;
112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;
113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;
114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;

108: g_mrc_res_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
109: g_mrc_txn_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
110: g_mrc_start_date_tab pa_plsql_datatypes.DateTabTyp;
111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;
112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;
113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;
114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;

109: g_mrc_txn_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
110: g_mrc_start_date_tab pa_plsql_datatypes.DateTabTyp;
111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;
112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;
113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;
114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;

Line 114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

110: g_mrc_start_date_tab pa_plsql_datatypes.DateTabTyp;
111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;
112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;
113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;
114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

111: g_mrc_end_date_tab pa_plsql_datatypes.DateTabTyp;
112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;
113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;
114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

112: g_mrc_period_name_tab pa_plsql_datatypes.Char80TabTyp;
113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;
114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;

113: g_mrc_quantity_tab pa_plsql_datatypes.NumTabTyp;
114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;

Line 118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

114: g_mrc_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

115: g_mrc_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

116: g_mrc_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;

117: g_mrc_project_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;

Line 122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

118: g_mrc_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;
126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;

Line 123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

119: g_mrc_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;
126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;
127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;

Line 124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

120: g_mrc_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;
126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;
127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;

Line 125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;

121: g_mrc_projfunc_curr_code_tab pa_plsql_datatypes.Char80TabTyp;
122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;
126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;
127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;

Line 126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;

122: g_mrc_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;
126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;
127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;

Line 127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;

123: g_mrc_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;
126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;
127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;

Line 128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;

124: g_mrc_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;
126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;
127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;

Line 129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;

125: g_mrc_delete_flag_tab pa_plsql_datatypes.Char1TabTyp;
126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;
127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;

Line 130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;

126: g_mrc_Billable_flag_tab pa_plsql_datatypes.Char1TabTyp;
127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;

Line 131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;

127: g_mrc_project_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;

Line 132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;

128: g_mrc_project_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;

Line 133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;

129: g_mrc_project_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;

Line 134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;

130: g_mrc_project_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;

Line 135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;

131: g_mrc_project_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
139: g_mrc_projfunc_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;

Line 136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;

132: g_mrc_project_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
139: g_mrc_projfunc_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
140: g_mrc_projfunc_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;

Line 137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;

133: g_mrc_project_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
139: g_mrc_projfunc_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
140: g_mrc_projfunc_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
141: g_mrc_projfunc_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;

Line 138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;

134: g_mrc_project_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
139: g_mrc_projfunc_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
140: g_mrc_projfunc_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
141: g_mrc_projfunc_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
142: g_mrc_projfunc_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;

Line 139: g_mrc_projfunc_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;

135: g_mrc_projfunc_cst_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
139: g_mrc_projfunc_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
140: g_mrc_projfunc_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
141: g_mrc_projfunc_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
142: g_mrc_projfunc_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
143:

Line 140: g_mrc_projfunc_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;

136: g_mrc_projfunc_cst_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
139: g_mrc_projfunc_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
140: g_mrc_projfunc_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
141: g_mrc_projfunc_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
142: g_mrc_projfunc_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
143:
144: /* The following plsql tabls are declared for bulk processing of spread calls */

Line 141: g_mrc_projfunc_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;

137: g_mrc_projfunc_cst_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
139: g_mrc_projfunc_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
140: g_mrc_projfunc_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
141: g_mrc_projfunc_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
142: g_mrc_projfunc_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
143:
144: /* The following plsql tabls are declared for bulk processing of spread calls */
145: g_sprd_raId_tab pa_plsql_datatypes.NumTabTyp;

Line 142: g_mrc_projfunc_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;

138: g_mrc_projfunc_cst_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
139: g_mrc_projfunc_rev_rt_type_tab pa_plsql_datatypes.Char80TabTyp;
140: g_mrc_projfunc_rev_exg_rt_tab pa_plsql_datatypes.NumTabTyp;
141: g_mrc_projfunc_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
142: g_mrc_projfunc_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
143:
144: /* The following plsql tabls are declared for bulk processing of spread calls */
145: g_sprd_raId_tab pa_plsql_datatypes.NumTabTyp;
146: g_sprd_txn_cur_tab pa_plsql_datatypes.Char50TabTyp;

Line 145: g_sprd_raId_tab pa_plsql_datatypes.NumTabTyp;

141: g_mrc_projfunc_rev_dt_type_tab pa_plsql_datatypes.Char80TabTyp;
142: g_mrc_projfunc_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
143:
144: /* The following plsql tabls are declared for bulk processing of spread calls */
145: g_sprd_raId_tab pa_plsql_datatypes.NumTabTyp;
146: g_sprd_txn_cur_tab pa_plsql_datatypes.Char50TabTyp;
147: g_sprd_sdate_tab pa_plsql_datatypes.DateTabTyp;
148: g_sprd_edate_tab pa_plsql_datatypes.DateTabTyp;
149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;

Line 146: g_sprd_txn_cur_tab pa_plsql_datatypes.Char50TabTyp;

142: g_mrc_projfunc_rev_rt_dt_tab pa_plsql_datatypes.DateTabTyp;
143:
144: /* The following plsql tabls are declared for bulk processing of spread calls */
145: g_sprd_raId_tab pa_plsql_datatypes.NumTabTyp;
146: g_sprd_txn_cur_tab pa_plsql_datatypes.Char50TabTyp;
147: g_sprd_sdate_tab pa_plsql_datatypes.DateTabTyp;
148: g_sprd_edate_tab pa_plsql_datatypes.DateTabTyp;
149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;
150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;

Line 147: g_sprd_sdate_tab pa_plsql_datatypes.DateTabTyp;

143:
144: /* The following plsql tabls are declared for bulk processing of spread calls */
145: g_sprd_raId_tab pa_plsql_datatypes.NumTabTyp;
146: g_sprd_txn_cur_tab pa_plsql_datatypes.Char50TabTyp;
147: g_sprd_sdate_tab pa_plsql_datatypes.DateTabTyp;
148: g_sprd_edate_tab pa_plsql_datatypes.DateTabTyp;
149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;
150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;
151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 148: g_sprd_edate_tab pa_plsql_datatypes.DateTabTyp;

144: /* The following plsql tabls are declared for bulk processing of spread calls */
145: g_sprd_raId_tab pa_plsql_datatypes.NumTabTyp;
146: g_sprd_txn_cur_tab pa_plsql_datatypes.Char50TabTyp;
147: g_sprd_sdate_tab pa_plsql_datatypes.DateTabTyp;
148: g_sprd_edate_tab pa_plsql_datatypes.DateTabTyp;
149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;
150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;
151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;
152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;

Line 149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;

145: g_sprd_raId_tab pa_plsql_datatypes.NumTabTyp;
146: g_sprd_txn_cur_tab pa_plsql_datatypes.Char50TabTyp;
147: g_sprd_sdate_tab pa_plsql_datatypes.DateTabTyp;
148: g_sprd_edate_tab pa_plsql_datatypes.DateTabTyp;
149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;
150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;
151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;
152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;
153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;

Line 150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;

146: g_sprd_txn_cur_tab pa_plsql_datatypes.Char50TabTyp;
147: g_sprd_sdate_tab pa_plsql_datatypes.DateTabTyp;
148: g_sprd_edate_tab pa_plsql_datatypes.DateTabTyp;
149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;
150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;
151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;
152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;
153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;
154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;

Line 151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;

147: g_sprd_sdate_tab pa_plsql_datatypes.DateTabTyp;
148: g_sprd_edate_tab pa_plsql_datatypes.DateTabTyp;
149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;
150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;
151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;
152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;
153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;
154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;
155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;

Line 152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;

148: g_sprd_edate_tab pa_plsql_datatypes.DateTabTyp;
149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;
150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;
151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;
152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;
153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;
154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;
155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;
156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;

Line 153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;

149: g_sprd_plan_sdate_tab pa_plsql_datatypes.DateTabTyp;
150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;
151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;
152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;
153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;
154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;
155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;
156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;
157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;

Line 154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;

150: g_sprd_plan_edate_tab pa_plsql_datatypes.DateTabTyp;
151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;
152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;
153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;
154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;
155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;
156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;
157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;
158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;

Line 155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;

151: g_sprd_txn_rev_tab pa_plsql_datatypes.NumTabTyp;
152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;
153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;
154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;
155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;
156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;
157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;
158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;
159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;

Line 156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;

152: g_sprd_txn_rev_addl_tab pa_plsql_datatypes.NumTabTyp;
153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;
154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;
155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;
156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;
157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;
158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;
159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;
160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;

153: g_sprd_txn_raw_tab pa_plsql_datatypes.NumTabTyp;
154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;
155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;
156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;
157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;
158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;
159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;
160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;
161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;

Line 158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;

154: g_sprd_txn_raw_addl_tab pa_plsql_datatypes.NumTabTyp;
155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;
156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;
157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;
158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;
159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;
160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;
161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;
162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;

Line 159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;

155: g_sprd_txn_burd_tab pa_plsql_datatypes.NumTabTyp;
156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;
157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;
158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;
159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;
160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;
161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;
162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;
163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;

Line 160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;

156: g_sprd_txn_burd_addl_tab pa_plsql_datatypes.NumTabTyp;
157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;
158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;
159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;
160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;
161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;
162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;
163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;
164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;

Line 161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;

157: g_sprd_qty_tab pa_plsql_datatypes.NumTabTyp;
158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;
159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;
160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;
161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;
162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;
163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;
164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;
165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;

Line 162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;

158: g_sprd_qty_addl_tab pa_plsql_datatypes.NumTabTyp;
159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;
160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;
161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;
162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;
163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;
164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;
165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;
166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;

Line 163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;

159: g_sprd_txn_cur_ovr_tab pa_plsql_datatypes.Char50TabTyp;
160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;
161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;
162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;
163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;
164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;
165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;
166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;

Line 164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;

160: g_sprd_txn_init_rev_tab pa_plsql_datatypes.NumTabTyp;
161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;
162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;
163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;
164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;
165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;
166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;
168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;

Line 165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;

161: g_sprd_txn_init_raw_tab pa_plsql_datatypes.NumTabTyp;
162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;
163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;
164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;
165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;
166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;
168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;

Line 166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;

162: g_sprd_txn_init_burd_tab pa_plsql_datatypes.NumTabTyp;
163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;
164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;
165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;
166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;
168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;
170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;

Line 167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;

163: g_sprd_txn_init_qty_tab pa_plsql_datatypes.NumTabTyp;
164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;
165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;
166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;
168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;
170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;

Line 168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;

164: g_sprd_spread_reqd_flag_tab pa_plsql_datatypes.Char1TabTyp;
165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;
166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;
168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;
170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;
172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;

Line 169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;

165: g_sprd_costRt_tab pa_plsql_datatypes.NumTabTyp;
166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;
168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;
170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;
172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;
173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;

Line 170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;

166: g_sprd_costRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;
168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;
170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;
172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;
173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;
174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;

Line 171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;

167: g_sprd_burdRt_Tab pa_plsql_datatypes.NumTabTyp;
168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;
170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;
172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;
173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;
174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;
175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;

Line 172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;

168: g_sprd_burdRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;
170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;
172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;
173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;
174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;
175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;
176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;

Line 173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;

169: g_sprd_billRt_tab pa_plsql_datatypes.NumTabTyp;
170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;
172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;
173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;
174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;
175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;
176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;
177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;

Line 174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;

170: g_sprd_billRt_Ovr_tab pa_plsql_datatypes.NumTabTyp;
171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;
172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;
173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;
174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;
175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;
176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;
177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;
178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;

171: g_sprd_ratebase_flag_tab pa_plsql_datatypes.Char1TabTyp;
172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;
173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;
174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;
175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;
176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;
177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;
178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;

172: g_sprd_projCur_tab pa_plsql_datatypes.Char50TabTyp;
173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;
174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;
175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;
176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;
177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;
178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;

173: g_sprd_projfuncCur_tab pa_plsql_datatypes.Char50TabTyp;
174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;
175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;
176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;
177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;
178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
181: g_sprd_QtymissFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

174: g_sprd_task_id_tab pa_plsql_datatypes.NumTabTyp;
175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;
176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;
177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;
178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
181: g_sprd_QtymissFlag_tab pa_plsql_datatypes.Char1TabTyp;
182: g_sprd_RawmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

175: g_sprd_rlm_id_tab pa_plsql_datatypes.NumTabTyp;
176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;
177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;
178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
181: g_sprd_QtymissFlag_tab pa_plsql_datatypes.Char1TabTyp;
182: g_sprd_RawmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
183: g_sprd_BurdmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

176: g_sprd_sp_fixed_date_tab pa_plsql_datatypes.DateTabTyp;
177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;
178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
181: g_sprd_QtymissFlag_tab pa_plsql_datatypes.Char1TabTyp;
182: g_sprd_RawmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
183: g_sprd_BurdmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
184: g_sprd_RevmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 181: g_sprd_QtymissFlag_tab pa_plsql_datatypes.Char1TabTyp;

177: g_sprd_spcurve_id_tab pa_plsql_datatypes.NumTabTyp;
178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
181: g_sprd_QtymissFlag_tab pa_plsql_datatypes.Char1TabTyp;
182: g_sprd_RawmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
183: g_sprd_BurdmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
184: g_sprd_RevmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
185: /* Bug fix:5726773 */

Line 182: g_sprd_RawmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

178: g_sprd_cstRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
181: g_sprd_QtymissFlag_tab pa_plsql_datatypes.Char1TabTyp;
182: g_sprd_RawmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
183: g_sprd_BurdmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
184: g_sprd_RevmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
185: /* Bug fix:5726773 */
186: g_sprd_neg_Qty_Changflag_tab pa_plsql_datatypes.Char1TabTyp;

Line 183: g_sprd_BurdmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

179: g_sprd_bdRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
181: g_sprd_QtymissFlag_tab pa_plsql_datatypes.Char1TabTyp;
182: g_sprd_RawmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
183: g_sprd_BurdmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
184: g_sprd_RevmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
185: /* Bug fix:5726773 */
186: g_sprd_neg_Qty_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
187: g_sprd_neg_Raw_Changflag_tab pa_plsql_datatypes.Char1TabTyp;

Line 184: g_sprd_RevmissFlag_tab pa_plsql_datatypes.Char1TabTyp;

180: g_sprd_bilRtmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
181: g_sprd_QtymissFlag_tab pa_plsql_datatypes.Char1TabTyp;
182: g_sprd_RawmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
183: g_sprd_BurdmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
184: g_sprd_RevmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
185: /* Bug fix:5726773 */
186: g_sprd_neg_Qty_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
187: g_sprd_neg_Raw_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
188: g_sprd_neg_Burd_Changflag_tab pa_plsql_datatypes.Char1TabTyp;

Line 186: g_sprd_neg_Qty_Changflag_tab pa_plsql_datatypes.Char1TabTyp;

182: g_sprd_RawmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
183: g_sprd_BurdmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
184: g_sprd_RevmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
185: /* Bug fix:5726773 */
186: g_sprd_neg_Qty_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
187: g_sprd_neg_Raw_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
188: g_sprd_neg_Burd_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
189: g_sprd_neg_rev_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
190:

Line 187: g_sprd_neg_Raw_Changflag_tab pa_plsql_datatypes.Char1TabTyp;

183: g_sprd_BurdmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
184: g_sprd_RevmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
185: /* Bug fix:5726773 */
186: g_sprd_neg_Qty_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
187: g_sprd_neg_Raw_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
188: g_sprd_neg_Burd_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
189: g_sprd_neg_rev_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
190:
191:

Line 188: g_sprd_neg_Burd_Changflag_tab pa_plsql_datatypes.Char1TabTyp;

184: g_sprd_RevmissFlag_tab pa_plsql_datatypes.Char1TabTyp;
185: /* Bug fix:5726773 */
186: g_sprd_neg_Qty_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
187: g_sprd_neg_Raw_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
188: g_sprd_neg_Burd_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
189: g_sprd_neg_rev_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
190:
191:
192: /* The following plsql tables defined for bulk processing of rollup tmp for refresh action */

Line 189: g_sprd_neg_rev_Changflag_tab pa_plsql_datatypes.Char1TabTyp;

185: /* Bug fix:5726773 */
186: g_sprd_neg_Qty_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
187: g_sprd_neg_Raw_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
188: g_sprd_neg_Burd_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
189: g_sprd_neg_rev_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
190:
191:
192: /* The following plsql tables defined for bulk processing of rollup tmp for refresh action */
193: g_plan_raId_tab pa_plsql_datatypes.NumTabTyp;

Line 193: g_plan_raId_tab pa_plsql_datatypes.NumTabTyp;

189: g_sprd_neg_rev_Changflag_tab pa_plsql_datatypes.Char1TabTyp;
190:
191:
192: /* The following plsql tables defined for bulk processing of rollup tmp for refresh action */
193: g_plan_raId_tab pa_plsql_datatypes.NumTabTyp;
194: g_plan_txnCur_Tab pa_plsql_datatypes.Char50TabTyp;
195: g_line_sdate_tab pa_plsql_datatypes.DateTabTyp;
196: g_line_edate_tab pa_plsql_datatypes.DateTabTyp;
197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;

Line 194: g_plan_txnCur_Tab pa_plsql_datatypes.Char50TabTyp;

190:
191:
192: /* The following plsql tables defined for bulk processing of rollup tmp for refresh action */
193: g_plan_raId_tab pa_plsql_datatypes.NumTabTyp;
194: g_plan_txnCur_Tab pa_plsql_datatypes.Char50TabTyp;
195: g_line_sdate_tab pa_plsql_datatypes.DateTabTyp;
196: g_line_edate_tab pa_plsql_datatypes.DateTabTyp;
197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;
198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;

Line 195: g_line_sdate_tab pa_plsql_datatypes.DateTabTyp;

191:
192: /* The following plsql tables defined for bulk processing of rollup tmp for refresh action */
193: g_plan_raId_tab pa_plsql_datatypes.NumTabTyp;
194: g_plan_txnCur_Tab pa_plsql_datatypes.Char50TabTyp;
195: g_line_sdate_tab pa_plsql_datatypes.DateTabTyp;
196: g_line_edate_tab pa_plsql_datatypes.DateTabTyp;
197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;
198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;
199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;

Line 196: g_line_edate_tab pa_plsql_datatypes.DateTabTyp;

192: /* The following plsql tables defined for bulk processing of rollup tmp for refresh action */
193: g_plan_raId_tab pa_plsql_datatypes.NumTabTyp;
194: g_plan_txnCur_Tab pa_plsql_datatypes.Char50TabTyp;
195: g_line_sdate_tab pa_plsql_datatypes.DateTabTyp;
196: g_line_edate_tab pa_plsql_datatypes.DateTabTyp;
197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;
198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;
199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;
200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;

Line 197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;

193: g_plan_raId_tab pa_plsql_datatypes.NumTabTyp;
194: g_plan_txnCur_Tab pa_plsql_datatypes.Char50TabTyp;
195: g_line_sdate_tab pa_plsql_datatypes.DateTabTyp;
196: g_line_edate_tab pa_plsql_datatypes.DateTabTyp;
197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;
198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;
199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;
200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;
201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;

Line 198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;

194: g_plan_txnCur_Tab pa_plsql_datatypes.Char50TabTyp;
195: g_line_sdate_tab pa_plsql_datatypes.DateTabTyp;
196: g_line_edate_tab pa_plsql_datatypes.DateTabTyp;
197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;
198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;
199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;
200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;
201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;
202: g_skip_record_tab pa_plsql_datatypes.Char1TabTyp;

Line 199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;

195: g_line_sdate_tab pa_plsql_datatypes.DateTabTyp;
196: g_line_edate_tab pa_plsql_datatypes.DateTabTyp;
197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;
198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;
199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;
200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;
201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;
202: g_skip_record_tab pa_plsql_datatypes.Char1TabTyp;
203: g_process_skip_CstRevrec_tab pa_plsql_datatypes.Char1TabTyp;

Line 200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;

196: g_line_edate_tab pa_plsql_datatypes.DateTabTyp;
197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;
198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;
199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;
200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;
201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;
202: g_skip_record_tab pa_plsql_datatypes.Char1TabTyp;
203: g_process_skip_CstRevrec_tab pa_plsql_datatypes.Char1TabTyp;
204: g_mfc_cost_refrsh_Raid_tab pa_plsql_datatypes.NumTabTyp;

Line 201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;

197: g_Wp_curCode_tab pa_plsql_datatypes.Char50TabTyp;
198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;
199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;
200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;
201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;
202: g_skip_record_tab pa_plsql_datatypes.Char1TabTyp;
203: g_process_skip_CstRevrec_tab pa_plsql_datatypes.Char1TabTyp;
204: g_mfc_cost_refrsh_Raid_tab pa_plsql_datatypes.NumTabTyp;
205: g_mfc_cost_refrsh_txnCur_tab pa_plsql_datatypes.Char50TabTyp;

Line 202: g_skip_record_tab pa_plsql_datatypes.Char1TabTyp;

198: g_refresh_rates_tab pa_plsql_datatypes.Char1TabTyp;
199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;
200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;
201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;
202: g_skip_record_tab pa_plsql_datatypes.Char1TabTyp;
203: g_process_skip_CstRevrec_tab pa_plsql_datatypes.Char1TabTyp;
204: g_mfc_cost_refrsh_Raid_tab pa_plsql_datatypes.NumTabTyp;
205: g_mfc_cost_refrsh_txnCur_tab pa_plsql_datatypes.Char50TabTyp;
206:

Line 203: g_process_skip_CstRevrec_tab pa_plsql_datatypes.Char1TabTyp;

199: g_refresh_conv_rates_tab pa_plsql_datatypes.Char1TabTyp;
200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;
201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;
202: g_skip_record_tab pa_plsql_datatypes.Char1TabTyp;
203: g_process_skip_CstRevrec_tab pa_plsql_datatypes.Char1TabTyp;
204: g_mfc_cost_refrsh_Raid_tab pa_plsql_datatypes.NumTabTyp;
205: g_mfc_cost_refrsh_txnCur_tab pa_plsql_datatypes.Char50TabTyp;
206:
207: /* Bug fix:4295967 During Apply progress, If no change in the ETC quantity then re derive the ETC costs*/

Line 204: g_mfc_cost_refrsh_Raid_tab pa_plsql_datatypes.NumTabTyp;

200: g_mass_adjust_flag_tab pa_plsql_datatypes.Char1TabTyp;
201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;
202: g_skip_record_tab pa_plsql_datatypes.Char1TabTyp;
203: g_process_skip_CstRevrec_tab pa_plsql_datatypes.Char1TabTyp;
204: g_mfc_cost_refrsh_Raid_tab pa_plsql_datatypes.NumTabTyp;
205: g_mfc_cost_refrsh_txnCur_tab pa_plsql_datatypes.Char50TabTyp;
206:
207: /* Bug fix:4295967 During Apply progress, If no change in the ETC quantity then re derive the ETC costs*/
208: g_applyProg_refreshRts_tab pa_plsql_datatypes.Char1TabTyp;

Line 205: g_mfc_cost_refrsh_txnCur_tab pa_plsql_datatypes.Char50TabTyp;

201: g_mfc_cost_refresh_tab pa_plsql_datatypes.Char1TabTyp;
202: g_skip_record_tab pa_plsql_datatypes.Char1TabTyp;
203: g_process_skip_CstRevrec_tab pa_plsql_datatypes.Char1TabTyp;
204: g_mfc_cost_refrsh_Raid_tab pa_plsql_datatypes.NumTabTyp;
205: g_mfc_cost_refrsh_txnCur_tab pa_plsql_datatypes.Char50TabTyp;
206:
207: /* Bug fix:4295967 During Apply progress, If no change in the ETC quantity then re derive the ETC costs*/
208: g_applyProg_refreshRts_tab pa_plsql_datatypes.Char1TabTyp;
209: g_applyProg_RaId_tab pa_plsql_datatypes.NumTabTyp;

Line 208: g_applyProg_refreshRts_tab pa_plsql_datatypes.Char1TabTyp;

204: g_mfc_cost_refrsh_Raid_tab pa_plsql_datatypes.NumTabTyp;
205: g_mfc_cost_refrsh_txnCur_tab pa_plsql_datatypes.Char50TabTyp;
206:
207: /* Bug fix:4295967 During Apply progress, If no change in the ETC quantity then re derive the ETC costs*/
208: g_applyProg_refreshRts_tab pa_plsql_datatypes.Char1TabTyp;
209: g_applyProg_RaId_tab pa_plsql_datatypes.NumTabTyp;
210: g_applyProg_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
211:
212:

Line 209: g_applyProg_RaId_tab pa_plsql_datatypes.NumTabTyp;

205: g_mfc_cost_refrsh_txnCur_tab pa_plsql_datatypes.Char50TabTyp;
206:
207: /* Bug fix:4295967 During Apply progress, If no change in the ETC quantity then re derive the ETC costs*/
208: g_applyProg_refreshRts_tab pa_plsql_datatypes.Char1TabTyp;
209: g_applyProg_RaId_tab pa_plsql_datatypes.NumTabTyp;
210: g_applyProg_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
211:
212:
213: /* The following plsql tables defined for bulk processing of rate ONLY changed resource */

Line 210: g_applyProg_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;

206:
207: /* Bug fix:4295967 During Apply progress, If no change in the ETC quantity then re derive the ETC costs*/
208: g_applyProg_refreshRts_tab pa_plsql_datatypes.Char1TabTyp;
209: g_applyProg_RaId_tab pa_plsql_datatypes.NumTabTyp;
210: g_applyProg_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
211:
212:
213: /* The following plsql tables defined for bulk processing of rate ONLY changed resource */
214: g_rtChanged_Ra_Flag_tab pa_plsql_datatypes.Char1TabTyp;

Line 214: g_rtChanged_Ra_Flag_tab pa_plsql_datatypes.Char1TabTyp;

210: g_applyProg_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
211:
212:
213: /* The following plsql tables defined for bulk processing of rate ONLY changed resource */
214: g_rtChanged_Ra_Flag_tab pa_plsql_datatypes.Char1TabTyp;
215: g_rtChanged_RaId_tab pa_plsql_datatypes.NumTabTyp;
216: g_rtChanged_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
217: g_rtChanged_sDate_tab pa_plsql_datatypes.DateTabTyp;
218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;

Line 215: g_rtChanged_RaId_tab pa_plsql_datatypes.NumTabTyp;

211:
212:
213: /* The following plsql tables defined for bulk processing of rate ONLY changed resource */
214: g_rtChanged_Ra_Flag_tab pa_plsql_datatypes.Char1TabTyp;
215: g_rtChanged_RaId_tab pa_plsql_datatypes.NumTabTyp;
216: g_rtChanged_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
217: g_rtChanged_sDate_tab pa_plsql_datatypes.DateTabTyp;
218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;
219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;

Line 216: g_rtChanged_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;

212:
213: /* The following plsql tables defined for bulk processing of rate ONLY changed resource */
214: g_rtChanged_Ra_Flag_tab pa_plsql_datatypes.Char1TabTyp;
215: g_rtChanged_RaId_tab pa_plsql_datatypes.NumTabTyp;
216: g_rtChanged_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
217: g_rtChanged_sDate_tab pa_plsql_datatypes.DateTabTyp;
218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;
219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;
220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;

Line 217: g_rtChanged_sDate_tab pa_plsql_datatypes.DateTabTyp;

213: /* The following plsql tables defined for bulk processing of rate ONLY changed resource */
214: g_rtChanged_Ra_Flag_tab pa_plsql_datatypes.Char1TabTyp;
215: g_rtChanged_RaId_tab pa_plsql_datatypes.NumTabTyp;
216: g_rtChanged_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
217: g_rtChanged_sDate_tab pa_plsql_datatypes.DateTabTyp;
218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;
219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;
220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;
221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;

Line 218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;

214: g_rtChanged_Ra_Flag_tab pa_plsql_datatypes.Char1TabTyp;
215: g_rtChanged_RaId_tab pa_plsql_datatypes.NumTabTyp;
216: g_rtChanged_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
217: g_rtChanged_sDate_tab pa_plsql_datatypes.DateTabTyp;
218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;
219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;
220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;
221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;
222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;

Line 219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;

215: g_rtChanged_RaId_tab pa_plsql_datatypes.NumTabTyp;
216: g_rtChanged_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
217: g_rtChanged_sDate_tab pa_plsql_datatypes.DateTabTyp;
218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;
219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;
220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;
221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;
222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;

216: g_rtChanged_TxnCur_tab pa_plsql_datatypes.Char50TabTyp;
217: g_rtChanged_sDate_tab pa_plsql_datatypes.DateTabTyp;
218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;
219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;
220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;
221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;
222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;

217: g_rtChanged_sDate_tab pa_plsql_datatypes.DateTabTyp;
218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;
219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;
220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;
221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;
222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
225: g_rtChanged_QtyMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;

Line 222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;

218: g_rtChanged_eDate_tab pa_plsql_datatypes.DateTabTyp;
219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;
220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;
221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;
222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
225: g_rtChanged_QtyMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
226: g_rtChanged_RwMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

219: g_rtChanged_CostRt_Tab pa_plsql_datatypes.NumTabTyp;
220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;
221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;
222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
225: g_rtChanged_QtyMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
226: g_rtChanged_RwMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
227: g_rtChanged_BrMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

220: g_rtChanged_BurdRt_tab pa_plsql_datatypes.NumTabTyp;
221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;
222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
225: g_rtChanged_QtyMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
226: g_rtChanged_RwMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
227: g_rtChanged_BrMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
228: g_rtChanged_RvMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

Line 225: g_rtChanged_QtyMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;

221: g_rtChanged_billRt_tab pa_plsql_datatypes.NumTabTyp;
222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
225: g_rtChanged_QtyMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
226: g_rtChanged_RwMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
227: g_rtChanged_BrMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
228: g_rtChanged_RvMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
229:

Line 226: g_rtChanged_RwMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

222: g_rtChanged_cstMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
225: g_rtChanged_QtyMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
226: g_rtChanged_RwMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
227: g_rtChanged_BrMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
228: g_rtChanged_RvMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
229:
230: g_apply_progress_flag_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 227: g_rtChanged_BrMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

223: g_rtChanged_bdMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
225: g_rtChanged_QtyMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
226: g_rtChanged_RwMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
227: g_rtChanged_BrMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
228: g_rtChanged_RvMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
229:
230: g_apply_progress_flag_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
231:

Line 228: g_rtChanged_RvMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;

224: g_rtChanged_blMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
225: g_rtChanged_QtyMisNumFlg_tab pa_plsql_datatypes.Char1TabTyp;
226: g_rtChanged_RwMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
227: g_rtChanged_BrMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
228: g_rtChanged_RvMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
229:
230: g_apply_progress_flag_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
231:
232: g_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;

Line 232: g_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;

228: g_rtChanged_RvMisNumFlag_tab pa_plsql_datatypes.Char1TabTyp;
229:
230: g_apply_progress_flag_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
231:
232: g_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
233: g_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
234: g_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;
235: g_etcrevrej_start_date_tab pa_plsql_datatypes.DateTabTyp;
236: g_etcrevrej_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 233: g_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;

229:
230: g_apply_progress_flag_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
231:
232: g_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
233: g_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
234: g_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;
235: g_etcrevrej_start_date_tab pa_plsql_datatypes.DateTabTyp;
236: g_etcrevrej_end_date_tab pa_plsql_datatypes.DateTabTyp;
237:

Line 234: g_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;

230: g_apply_progress_flag_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
231:
232: g_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
233: g_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
234: g_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;
235: g_etcrevrej_start_date_tab pa_plsql_datatypes.DateTabTyp;
236: g_etcrevrej_end_date_tab pa_plsql_datatypes.DateTabTyp;
237:
238: -- Added for Bug# 6781055

Line 235: g_etcrevrej_start_date_tab pa_plsql_datatypes.DateTabTyp;

231:
232: g_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
233: g_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
234: g_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;
235: g_etcrevrej_start_date_tab pa_plsql_datatypes.DateTabTyp;
236: g_etcrevrej_end_date_tab pa_plsql_datatypes.DateTabTyp;
237:
238: -- Added for Bug# 6781055
239: gl_cl_roll_up_tmp_rowid_tab pa_plsql_datatypes.RowidTabTyp;

Line 236: g_etcrevrej_end_date_tab pa_plsql_datatypes.DateTabTyp;

232: g_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
233: g_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
234: g_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;
235: g_etcrevrej_start_date_tab pa_plsql_datatypes.DateTabTyp;
236: g_etcrevrej_end_date_tab pa_plsql_datatypes.DateTabTyp;
237:
238: -- Added for Bug# 6781055
239: gl_cl_roll_up_tmp_rowid_tab pa_plsql_datatypes.RowidTabTyp;
240:

Line 239: gl_cl_roll_up_tmp_rowid_tab pa_plsql_datatypes.RowidTabTyp;

235: g_etcrevrej_start_date_tab pa_plsql_datatypes.DateTabTyp;
236: g_etcrevrej_end_date_tab pa_plsql_datatypes.DateTabTyp;
237:
238: -- Added for Bug# 6781055
239: gl_cl_roll_up_tmp_rowid_tab pa_plsql_datatypes.RowidTabTyp;
240:
241: /*Declare global cursors so that the same cursor can be opend at many places
242: * and maintenance of the code is simple and easy
243: */

Line 553: l_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;

549: ,bl.txn_currency_code
550: ,decode(p_source_context,'BUDGET_LINE',tmp.start_date,NULL)
551: ,decode(p_source_context,'BUDGET_LINE',tmp.end_date,NULL) ;
552:
553: l_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
554: l_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
555: l_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;
556: l_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
557:

Line 554: l_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;

550: ,decode(p_source_context,'BUDGET_LINE',tmp.start_date,NULL)
551: ,decode(p_source_context,'BUDGET_LINE',tmp.end_date,NULL) ;
552:
553: l_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
554: l_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
555: l_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;
556: l_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
557:
558: BEGIN

Line 555: l_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;

551: ,decode(p_source_context,'BUDGET_LINE',tmp.end_date,NULL) ;
552:
553: l_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
554: l_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
555: l_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;
556: l_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
557:
558: BEGIN
559: x_return_status := 'S';

Line 556: l_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;

552:
553: l_etcrevrej_raId_tab pa_plsql_datatypes.NumTabTyp;
554: l_etcrevrej_txnCur_tab pa_plsql_datatypes.Char30TabTyp;
555: l_etcrevrej_revenue_tab pa_plsql_datatypes.NumTabTyp;
556: l_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
557:
558: BEGIN
559: x_return_status := 'S';
560: x_msg_count := 0;

Line 2296: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;

2292: l_return_status varchar2(10);
2293: l_msg_count Number;
2294: l_msg_data varchar2(240);
2295:
2296: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2297: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2298: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2299: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

Line 2297: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

2293: l_msg_count Number;
2294: l_msg_data varchar2(240);
2295:
2296: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2297: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2298: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2299: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 2298: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

2294: l_msg_data varchar2(240);
2295:
2296: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2297: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2298: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2299: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 2299: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

2295:
2296: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2297: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2298: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2299: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

2296: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2297: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2298: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2299: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

2297: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2298: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2299: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

2298: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2299: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2299: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2300: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

2301: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

2302: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

2303: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

2304: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2305: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2306: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

2307: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2308: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2309: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

2310: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2311: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2312: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

2313: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2314: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2315: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2323: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

2316: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2323: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2324: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2317: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2323: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2324: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2325: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2318: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2323: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2324: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2325: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2326: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2323: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

2319: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2323: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2324: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2325: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2326: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2327:

Line 2324: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2320: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2323: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2324: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2325: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2326: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2327:
2328: l_revenue_generation_method varchar2(10);

Line 2325: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2321: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2323: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2324: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2325: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2326: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2327:
2328: l_revenue_generation_method varchar2(10);
2329: l_null_revenue_amts_flag varchar2(10);

Line 2326: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

2322: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2323: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2324: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2325: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2326: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2327:
2328: l_revenue_generation_method varchar2(10);
2329: l_null_revenue_amts_flag varchar2(10);
2330:

Line 2609: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;

2605: l_return_status varchar2(10);
2606: l_msg_count Number;
2607: l_msg_data varchar2(240);
2608:
2609: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2610: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2611: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2612: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 2610: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

2606: l_msg_count Number;
2607: l_msg_data varchar2(240);
2608:
2609: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2610: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2611: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2612: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2611: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

2607: l_msg_data varchar2(240);
2608:
2609: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2610: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2611: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2612: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2612: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

2608:
2609: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2610: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2611: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2612: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

2609: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2610: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2611: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2612: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2610: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2611: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2612: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2611: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2612: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

2612: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

2613: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

2614: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

2615: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2616: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

2617: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2625: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

2618: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2625: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2626: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2619: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2625: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2626: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2627: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

2620: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2625: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2626: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2627: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2628: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2625: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

2621: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2625: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2626: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2627: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2628: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;
2629:

Line 2626: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2622: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2625: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2626: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2627: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2628: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;
2629:
2630: l_revenue_generation_method varchar2(10);

Line 2627: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

2623: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2625: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2626: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2627: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2628: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;
2629:
2630: l_revenue_generation_method varchar2(10);
2631: l_null_revenue_amts_flag varchar2(10);

Line 2628: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;

2624: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2625: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2626: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2627: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2628: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;
2629:
2630: l_revenue_generation_method varchar2(10);
2631: l_null_revenue_amts_flag varchar2(10);
2632:

Line 3436: l_raId_tab pa_plsql_datatypes.NumTabTyp;

3432: ,bl.txn_currency_code
3433: having count(*) > 1
3434: );
3435:
3436: l_raId_tab pa_plsql_datatypes.NumTabTyp;
3437: l_return_status varchar2(10) := 'S';
3438: l_msg_count Number;
3439: l_msg_data Varchar2(1000);
3440:

Line 3945: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;

3941: ,round(bl.txn_init_raw_cost,2)),'Y','N') <> 'Y' )
3942: )
3943: );
3944:
3945: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3946: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3947: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3948: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 3946: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;

3942: )
3943: );
3944:
3945: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3946: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3947: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3948: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

Line 3947: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

3943: );
3944:
3945: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3946: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3947: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3948: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 3948: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

3944:
3945: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3946: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3947: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3948: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

3945: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3946: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3947: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3948: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

3946: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3947: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3948: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

3947: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3948: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3948: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

3949: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

3950: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3951: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

3952: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

3953: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3954: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

3955: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

3956: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3964: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3957: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3964: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3965: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3958: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3964: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3965: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3966: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

3959: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3964: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3965: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3966: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3967: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3964: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

3960: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3964: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3965: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3966: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3967: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3968:

Line 3965: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

3961: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3964: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3965: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3966: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3967: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3968:
3969:

Line 3966: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

3962: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3964: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3965: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3966: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3967: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3968:
3969:
3970: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;

Line 3967: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

3963: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3964: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3965: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3966: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3967: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3968:
3969:
3970: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3971: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;

Line 3970: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;

3966: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3967: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3968:
3969:
3970: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3971: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3972: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3973: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 3971: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;

3967: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3968:
3969:
3970: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3971: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3972: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3973: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;

Line 3972: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3968:
3969:
3970: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3971: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3972: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3973: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 3973: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;

3969:
3970: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3971: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3972: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3973: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;

3970: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3971: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3972: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3973: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;

3971: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3972: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3973: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;

3972: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3973: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3973: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

3974: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

3975: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3976: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

3977: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

3978: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3979: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

3980: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;

Line 3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

3981: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3989: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;

Line 3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3982: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3989: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3990: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;

Line 3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3983: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3989: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3990: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3991: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;

Line 3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;

3984: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3989: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3990: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3991: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3992: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;

Line 3989: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;

3985: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3989: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3990: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3991: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3992: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3993:

Line 3990: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;

3986: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3989: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3990: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3991: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3992: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3993:
3994: l_stage varchar2(100);

Line 3991: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;

3987: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3989: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3990: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3991: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3992: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3993:
3994: l_stage varchar2(100);
3995: l_return_status varchar2(100);

Line 3992: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;

3988: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3989: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3990: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3991: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3992: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3993:
3994: l_stage varchar2(100);
3995: l_return_status varchar2(100);
3996: l_msg_data varchar2(1000);

Line 4835: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;

4831: ))
4832: */
4833: ;
4834:
4835: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4836: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4837: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4838: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 4836: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;

4832: */
4833: ;
4834:
4835: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4836: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4837: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4838: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

Line 4837: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

4833: ;
4834:
4835: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4836: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4837: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4838: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 4838: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

4834:
4835: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4836: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4837: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4838: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

4835: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4836: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4837: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4838: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

4836: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4837: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4838: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;

4837: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4838: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

Line 4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;

4838: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;

4839: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

Line 4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4840: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

4841: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

Line 4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4842: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

4843: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

Line 4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4844: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

4845: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

Line 4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4846: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

4847: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

Line 4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4848: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

4849: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4857: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

Line 4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4850: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4857: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4858: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

4851: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4857: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4858: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4859: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

Line 4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4852: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4857: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4858: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4859: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4860: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;

Line 4857: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

4853: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4857: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4858: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4859: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4860: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;
4861:

Line 4858: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4854: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4857: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4858: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4859: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4860: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;
4861:
4862:

Line 4859: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

4855: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4857: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4858: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4859: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4860: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;
4861:
4862:
4863: BEGIN

Line 4860: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;

4856: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4857: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4858: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4859: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4860: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;
4861:
4862:
4863: BEGIN
4864: /* Initialize the out variables */

Line 5139: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;

5135: NVL(bl.txn_init_burdened_cost ,0) <> 0 OR
5136: NVL(bl.txn_init_revenue ,0) <> 0
5137: );
5138:
5139: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5140: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5141: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5142: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 5140: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;

5136: NVL(bl.txn_init_revenue ,0) <> 0
5137: );
5138:
5139: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5140: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5141: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5142: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

Line 5141: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

5137: );
5138:
5139: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5140: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5141: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5142: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 5142: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

5138:
5139: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5140: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5141: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5142: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

5139: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5140: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5141: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5142: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

5140: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5141: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5142: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

5141: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5142: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5142: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5143: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

5144: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5145: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5146: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

5147: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5148: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5149: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

5150: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

5151: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

5152: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

5153: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

5154: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

5155: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

5156: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

5157: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

5158: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5159: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5160: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5168: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

5161: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5168: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5169: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5162: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5168: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5169: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5170: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5163: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5168: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5169: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5170: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5171: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5168: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

5164: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5168: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5169: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5170: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5171: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5172:

Line 5169: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5165: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5168: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5169: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5170: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5171: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5172:
5173: BEGIN

Line 5170: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5166: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5168: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5169: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5170: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5171: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5172:
5173: BEGIN
5174:

Line 5171: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

5167: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5168: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5169: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5170: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5171: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5172:
5173: BEGIN
5174:
5175: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6314: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;

6310: l_burden_cost_adj_pct NUMBER := p_burden_cost_adj_pct;
6311: l_revenue_adj_pct NUMBER := p_revenue_adj_pct;
6312:
6313: /* declare local plsqltabs for bulk processing */
6314: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6315: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6316: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6317: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;

Line 6315: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;

6311: l_revenue_adj_pct NUMBER := p_revenue_adj_pct;
6312:
6313: /* declare local plsqltabs for bulk processing */
6314: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6315: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6316: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6317: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;

Line 6316: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;

6312:
6313: /* declare local plsqltabs for bulk processing */
6314: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6315: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6316: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6317: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;

Line 6317: l_raId_tab pa_plsql_datatypes.NumTabTyp;

6313: /* declare local plsqltabs for bulk processing */
6314: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6315: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6316: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6317: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;

Line 6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;

6314: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6315: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6316: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6317: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;

Line 6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;

6315: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6316: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6317: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;

Line 6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;

6316: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6317: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6324: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;

Line 6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;

6317: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6324: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6325: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;

Line 6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;

6318: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6324: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6325: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6326: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;

Line 6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;

6319: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6324: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6325: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6326: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6327: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;

Line 6324: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;

6320: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6324: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6325: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6326: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6327: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;
6328:

Line 6325: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;

6321: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6324: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6325: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6326: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6327: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;
6328:
6329: CURSOR cur_rndQty IS

Line 6326: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;

6322: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6324: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6325: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6326: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6327: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;
6328:
6329: CURSOR cur_rndQty IS
6330: SELECT tmp.resource_assignment_id

Line 6327: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;

6323: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6324: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6325: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6326: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6327: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;
6328:
6329: CURSOR cur_rndQty IS
6330: SELECT tmp.resource_assignment_id
6331: ,tmp.txn_currency_code

Line 6823: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;

6819: WHERE pbl.budget_version_id = p_budget_version_id
6820: GROUP BY pbl.resource_assignment_id;
6821: -- gboomina AAI Requirement - End
6822:
6823: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6824: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6825: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6826: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 6824: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;

6820: GROUP BY pbl.resource_assignment_id;
6821: -- gboomina AAI Requirement - End
6822:
6823: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6824: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6825: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6826: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6825: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

6821: -- gboomina AAI Requirement - End
6822:
6823: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6824: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6825: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6826: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6826: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

6822:
6823: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6824: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6825: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6826: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;

6823: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6824: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6825: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6826: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

6824: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6825: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6826: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

6825: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6826: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

6826: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6834: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

6827: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6834: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6835: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

6828: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6834: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6835: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6836: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

6829: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6834: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6835: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6836: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6837: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 6834: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

6830: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6834: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6835: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6836: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6837: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6838:

Line 6835: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

6831: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6834: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6835: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6836: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6837: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6838:
6839: l_user_id Number;

Line 6836: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

6832: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6834: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6835: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6836: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6837: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6838:
6839: l_user_id Number;
6840: l_login_id Number;

Line 6837: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

6833: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6834: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6835: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6836: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6837: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6838:
6839: l_user_id Number;
6840: l_login_id Number;
6841:

Line 7665: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;

7661: )
7662: group by tmp1.resource_assignment_id
7663: ,tmp1.txn_currency_code;
7664:
7665: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7666: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7667: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7668: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7669: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 7666: l_raid_tab pa_plsql_datatypes.IdTabTyp;

7662: group by tmp1.resource_assignment_id
7663: ,tmp1.txn_currency_code;
7664:
7665: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7666: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7667: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7668: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7669: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7670: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;

Line 7667: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

7663: ,tmp1.txn_currency_code;
7664:
7665: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7666: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7667: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7668: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7669: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7670: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7671: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 7668: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

7664:
7665: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7666: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7667: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7668: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7669: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7670: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7671: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7672: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 7669: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

7665: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7666: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7667: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7668: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7669: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7670: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7671: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7672: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7673:

Line 7670: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;

7666: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7667: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7668: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7669: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7670: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7671: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7672: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7673:
7674: BEGIN

Line 7671: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

7667: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7668: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7669: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7670: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7671: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7672: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7673:
7674: BEGIN
7675: x_return_status := 'S';

Line 7672: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

7668: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7669: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7670: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7671: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7672: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7673:
7674: BEGIN
7675: x_return_status := 'S';
7676: x_msg_data := NULL;

Line 8246: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;

8242: l_plan_edate_shrunk_flag Varchar2(10) := 'N';
8243: l_ra_in_multi_cur_flag Varchar2(10) := 'N';
8244:
8245: /* declared the following tbl for client extn bulk update */
8246: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8247: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8248: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8249: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 8247: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

8243: l_ra_in_multi_cur_flag Varchar2(10) := 'N';
8244:
8245: /* declared the following tbl for client extn bulk update */
8246: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8247: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8248: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8249: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 8248: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

8244:
8245: /* declared the following tbl for client extn bulk update */
8246: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8247: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8248: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8249: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 8249: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

8245: /* declared the following tbl for client extn bulk update */
8246: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8247: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8248: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8249: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8253: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;

Line 8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;

8246: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8247: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8248: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8249: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8253: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8254: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

Line 8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;

8247: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8248: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8249: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8253: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8254: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8255: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

Line 8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;

8248: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8249: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8253: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8254: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8255: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8256: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

Line 8253: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;

8249: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8253: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8254: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8255: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8256: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8257: l_cl_cntr NUMBER := 0;

Line 8254: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

8250: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8253: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8254: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8255: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8256: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8257: l_cl_cntr NUMBER := 0;
8258: l_cl_raw_rejection_code VARCHAR2(30);

Line 8255: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

8251: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8253: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8254: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8255: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8256: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8257: l_cl_cntr NUMBER := 0;
8258: l_cl_raw_rejection_code VARCHAR2(30);
8259: l_cl_burd_rejection_code VARCHAR2(30);

Line 8256: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

8252: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8253: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8254: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8255: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8256: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8257: l_cl_cntr NUMBER := 0;
8258: l_cl_raw_rejection_code VARCHAR2(30);
8259: l_cl_burd_rejection_code VARCHAR2(30);
8260: l_cl_rev_rejection_code VARCHAR2(30);

Line 12042: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;

12038: l_rev_to_cost_conv_cur Varchar2(100);
12039:
12040: /* declared for bulk processing of rollup tmp update */
12041: l_rl_cntr NUMBER := 0;
12042: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
12043: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
12044: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
12045: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;

Line 12043: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;

12039:
12040: /* declared for bulk processing of rollup tmp update */
12041: l_rl_cntr NUMBER := 0;
12042: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
12043: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
12044: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
12045: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

Line 12044: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;

12040: /* declared for bulk processing of rollup tmp update */
12041: l_rl_cntr NUMBER := 0;
12042: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
12043: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
12044: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
12045: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;

Line 12045: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

12041: l_rl_cntr NUMBER := 0;
12042: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
12043: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
12044: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
12045: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

Line 12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;

12042: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
12043: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
12044: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
12045: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

12043: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
12044: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
12045: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;

12044: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
12045: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

12045: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;

Line 12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

12046: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

12047: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;

12048: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;

12049: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12057: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;

12050: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12057: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12058: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;

12051: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12057: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12058: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12059: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;

12052: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12057: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12058: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12059: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12060: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;

Line 12057: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;

12053: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12057: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12058: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12059: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12060: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;
12061:

Line 12058: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;

12054: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12057: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12058: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12059: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12060: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;
12061:
12062: /* Bug fix: 4294287 */

Line 12059: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;

12055: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12057: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12058: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12059: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12060: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;
12061:
12062: /* Bug fix: 4294287 */
12063: l_bill_markup_percentage Number;

Line 12060: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;

12056: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12057: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12058: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12059: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
12060: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;
12061:
12062: /* Bug fix: 4294287 */
12063: l_bill_markup_percentage Number;
12064: l_billable_flag Varchar2(10);