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 2266: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;

2262: l_return_status varchar2(10);
2263: l_msg_count Number;
2264: l_msg_data varchar2(240);
2265:
2266: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2267: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2268: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2269: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

Line 2267: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

2263: l_msg_count Number;
2264: l_msg_data varchar2(240);
2265:
2266: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2267: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2268: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2269: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 2268: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

2264: l_msg_data varchar2(240);
2265:
2266: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2267: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2268: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2269: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 2269: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

2265:
2266: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2267: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2268: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2269: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

2266: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2267: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2268: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2269: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

2267: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2268: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2269: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

2268: l_proj_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2269: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2269: l_pjfc_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2270: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

2271: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

2272: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

2273: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

2274: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2275: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2276: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

2277: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2278: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2279: l_unround_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

2280: l_unround_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2281: l_unround_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2282: l_round_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

2283: l_round_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2284: l_round_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2285: l_unround_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2293: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

2286: l_unround_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2293: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2294: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2287: l_unround_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2293: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2294: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2295: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2288: l_round_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2293: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2294: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2295: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2296: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2293: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;

2289: l_round_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2293: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2294: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2295: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2296: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2297:

Line 2294: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2290: l_round_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2293: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2294: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2295: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2296: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2297:
2298: l_revenue_generation_method varchar2(10);

Line 2295: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;

2291: l_diff_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2293: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2294: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2295: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2296: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2297:
2298: l_revenue_generation_method varchar2(10);
2299: l_null_revenue_amts_flag varchar2(10);

Line 2296: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;

2292: l_diff_proj_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2293: l_diff_proj_rev_tab pa_plsql_datatypes.NumTabTyp;
2294: l_diff_pjfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2295: l_diff_pjfc_burd_cost_tab pa_plsql_datatypes.NumTabTyp;
2296: l_diff_pjfc_rev_tab pa_plsql_datatypes.NumTabTyp;
2297:
2298: l_revenue_generation_method varchar2(10);
2299: l_null_revenue_amts_flag varchar2(10);
2300:

Line 2579: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;

2575: l_return_status varchar2(10);
2576: l_msg_count Number;
2577: l_msg_data varchar2(240);
2578:
2579: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2580: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2581: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2582: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 2580: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

2576: l_msg_count Number;
2577: l_msg_data varchar2(240);
2578:
2579: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2580: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2581: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2582: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2581: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

2577: l_msg_data varchar2(240);
2578:
2579: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2580: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2581: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2582: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2582: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

2578:
2579: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2580: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2581: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2582: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

2579: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
2580: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2581: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2582: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2580: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
2581: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2582: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2581: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
2582: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

2582: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

2583: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

2584: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

2585: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2586: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

2587: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2595: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

2588: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2595: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2596: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2589: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2595: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2596: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2597: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

2590: l_unrounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2595: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2596: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2597: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2598: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 2595: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

2591: l_unround_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2595: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2596: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2597: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2598: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;
2599:

Line 2596: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2592: l_unrounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2595: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2596: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2597: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2598: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;
2599:
2600: l_revenue_generation_method varchar2(10);

Line 2597: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

2593: l_rounded_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2595: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2596: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2597: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2598: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;
2599:
2600: l_revenue_generation_method varchar2(10);
2601: l_null_revenue_amts_flag varchar2(10);

Line 2598: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;

2594: l_rounded_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2595: l_rounded_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
2596: l_diff_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2597: l_diff_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
2598: l_diff_revenue_tab pa_plsql_datatypes.NumTabTyp;
2599:
2600: l_revenue_generation_method varchar2(10);
2601: l_null_revenue_amts_flag varchar2(10);
2602:

Line 3404: l_raId_tab pa_plsql_datatypes.NumTabTyp;

3400: ,bl.txn_currency_code
3401: having count(*) > 1
3402: );
3403:
3404: l_raId_tab pa_plsql_datatypes.NumTabTyp;
3405: l_return_status varchar2(10) := 'S';
3406: l_msg_count Number;
3407: l_msg_data Varchar2(1000);
3408:

Line 3913: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;

3909: ,round(bl.txn_init_raw_cost,2)),'Y','N') <> 'Y' )
3910: )
3911: );
3912:
3913: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3914: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3915: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3916: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 3914: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;

3910: )
3911: );
3912:
3913: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3914: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3915: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3916: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

Line 3915: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

3911: );
3912:
3913: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3914: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3915: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3916: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 3916: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

3912:
3913: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3914: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3915: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3916: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

3913: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3914: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3915: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3916: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

3914: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
3915: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3916: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

3915: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
3916: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3916: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

3917: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

3918: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3919: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

3920: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

3921: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3922: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

3923: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

3924: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3932: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3925: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3932: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3933: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3926: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3932: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3933: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3934: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

3927: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3932: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3933: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3934: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3935: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3932: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

3928: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3932: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3933: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3934: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3935: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3936:

Line 3933: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

3929: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3932: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3933: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3934: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3935: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3936:
3937:

Line 3934: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

3930: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3932: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3933: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3934: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3935: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3936:
3937:
3938: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;

Line 3935: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

3931: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3932: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3933: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
3934: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3935: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3936:
3937:
3938: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3939: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;

Line 3938: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;

3934: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3935: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3936:
3937:
3938: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3939: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3940: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3941: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 3939: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;

3935: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
3936:
3937:
3938: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3939: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3940: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3941: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;

Line 3940: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3936:
3937:
3938: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3939: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3940: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3941: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 3941: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;

3937:
3938: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3939: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3940: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3941: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;

3938: l_upd_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
3939: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3940: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3941: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;

3939: l_upd_ra_id_tab pa_plsql_datatypes.IdTabTyp;
3940: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3941: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;

3940: l_upd_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3941: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3941: l_upd_start_date_tab pa_plsql_datatypes.DateTabTyp;
3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

3942: l_upd_end_date_tab pa_plsql_datatypes.DateTabTyp;
3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

3943: l_upd_period_name_tab pa_plsql_datatypes.Char50TabTyp;
3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3944: l_upd_quantity_tab pa_plsql_datatypes.NumTabTyp;
3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

3945: l_upd_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

3946: l_upd_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

3947: l_upd_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

3948: l_upd_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;

Line 3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

3949: l_upd_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3957: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;

Line 3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3950: l_upd_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3957: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3958: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;

Line 3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

3951: l_upd_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3957: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3958: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3959: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;

Line 3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;

3952: l_upd_projfunc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3957: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3958: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3959: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3960: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;

Line 3957: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;

3953: l_upd_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3957: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3958: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3959: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3960: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3961:

Line 3958: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;

3954: l_upd_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3957: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3958: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3959: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3960: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3961:
3962: l_stage varchar2(100);

Line 3959: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;

3955: l_upd_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3957: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3958: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3959: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3960: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3961:
3962: l_stage varchar2(100);
3963: l_return_status varchar2(100);

Line 3960: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;

3956: l_upd_cost_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3957: l_upd_revenue_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3958: l_upd_burden_rejection_tab pa_plsql_datatypes.Char50TabTyp;
3959: l_upd_pfc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3960: l_upd_pc_cur_conv_rej_tab pa_plsql_datatypes.Char50TabTyp;
3961:
3962: l_stage varchar2(100);
3963: l_return_status varchar2(100);
3964: l_msg_data varchar2(1000);

Line 4800: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;

4796: ))
4797: */
4798: ;
4799:
4800: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4801: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4802: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4803: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 4801: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;

4797: */
4798: ;
4799:
4800: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4801: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4802: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4803: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

Line 4802: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

4798: ;
4799:
4800: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4801: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4802: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4803: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 4803: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

4799:
4800: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4801: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4802: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4803: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

4800: l_rowid_tab pa_plsql_datatypes.RowidTabTyp;
4801: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4802: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4803: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

4801: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
4802: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4803: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;

4802: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
4803: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

Line 4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;

4803: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;

4804: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

Line 4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4805: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

4806: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

Line 4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4807: l_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

4808: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

Line 4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4809: l_PROJECT_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

4810: l_PROJECT_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

Line 4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4811: l_PROJECT_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

4812: l_PROJECT_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

Line 4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4813: l_PROJECT_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

4814: l_PROJECT_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4822: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

Line 4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4815: l_PROJECT_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4822: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4823: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

Line 4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

4816: l_PROJECT_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4822: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4823: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4824: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

Line 4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4817: l_PROJFUNC_COST_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4822: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4823: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4824: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4825: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;

Line 4822: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;

4818: l_PROJFUNC_COST_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4822: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4823: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4824: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4825: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;
4826:

Line 4823: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;

4819: l_PROJFUNC_COST_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4822: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4823: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4824: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4825: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;
4826:
4827:

Line 4824: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;

4820: l_PROJFUNC_COST_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4822: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4823: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4824: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4825: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;
4826:
4827:
4828: BEGIN

Line 4825: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;

4821: l_PROJFUNC_REV_RATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4822: l_PROJFUNC_REV_EXG_RATE_tab pa_plsql_datatypes.NumTabTyp;
4823: l_PROJFUNC_REV_DATE_TYPE_tab pa_plsql_datatypes.Char50TabTyp;
4824: l_PROJFUNC_REV_RATE_DATE_tab pa_plsql_datatypes.DateTabTyp;
4825: l_markup_calculation_flag_tab pa_plsql_datatypes.Char1TabTyp;
4826:
4827:
4828: BEGIN
4829: /* Initialize the out variables */

Line 5104: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;

5100: NVL(bl.txn_init_burdened_cost ,0) <> 0 OR
5101: NVL(bl.txn_init_revenue ,0) <> 0
5102: );
5103:
5104: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5105: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5106: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5107: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 5105: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;

5101: NVL(bl.txn_init_revenue ,0) <> 0
5102: );
5103:
5104: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5105: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5106: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5107: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

Line 5106: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;

5102: );
5103:
5104: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5105: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5106: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5107: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 5107: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

5103:
5104: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5105: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5106: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5107: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

5104: l_budget_Line_id_tab pa_plsql_datatypes.IdTabTyp;
5105: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5106: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5107: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;

5105: l_resource_assignment_id_tab pa_plsql_datatypes.IdTabTyp;
5106: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5107: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

5106: l_txn_currency_code_tab pa_plsql_datatypes.Char50TabTyp;
5107: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5107: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5108: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

5109: l_period_name_tab pa_plsql_datatypes.Char50TabTyp;
5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5110: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5111: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

5112: l_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5113: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5114: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;

5115: l_project_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

5116: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;

5117: l_projfunc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

5118: l_projfunc_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

Line 5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

5119: l_projfunc_revenue_tab pa_plsql_datatypes.NumTabTyp;
5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;

5120: l_project_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

5121: l_projfunc_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;

5122: l_cost_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

5123: l_revenue_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5124: l_burden_rejection_code_tab pa_plsql_datatypes.Char50TabTyp;
5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5125: l_pfc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5133: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

5126: l_pc_cur_conv_rej_code_tab pa_plsql_datatypes.Char50TabTyp;
5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5133: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5134: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5127: l_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5133: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5134: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5135: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5128: l_txn_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5133: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5134: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5135: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5136: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 5133: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

5129: l_txn_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5133: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5134: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5135: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5136: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5137:

Line 5134: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

5130: l_txn_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5133: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5134: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5135: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5136: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5137:
5138: BEGIN

Line 5135: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

5131: l_pj_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5133: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5134: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5135: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5136: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5137:
5138: BEGIN
5139:

Line 5136: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

5132: l_pj_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5133: l_pj_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5134: l_pjf_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
5135: l_pjf_init_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
5136: l_pjf_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
5137:
5138: BEGIN
5139:
5140: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6279: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;

6275: l_burden_cost_adj_pct NUMBER := p_burden_cost_adj_pct;
6276: l_revenue_adj_pct NUMBER := p_revenue_adj_pct;
6277:
6278: /* declare local plsqltabs for bulk processing */
6279: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6280: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6281: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6282: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;

Line 6280: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;

6276: l_revenue_adj_pct NUMBER := p_revenue_adj_pct;
6277:
6278: /* declare local plsqltabs for bulk processing */
6279: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6280: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6281: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6282: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;

Line 6281: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;

6277:
6278: /* declare local plsqltabs for bulk processing */
6279: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6280: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6281: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6282: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;

Line 6282: l_raId_tab pa_plsql_datatypes.NumTabTyp;

6278: /* declare local plsqltabs for bulk processing */
6279: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6280: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6281: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6282: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;

Line 6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;

6279: l_quantity_new_tab pa_plsql_datatypes.NumTabTyp;
6280: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6281: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6282: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;

Line 6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;

6280: l_quantity_old_tab pa_plsql_datatypes.NumTabTyp;
6281: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6282: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;

Line 6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;

6281: l_quantity_diff_tab pa_plsql_datatypes.NumTabTyp;
6282: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6289: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;

Line 6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;

6282: l_raId_tab pa_plsql_datatypes.NumTabTyp;
6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6289: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6290: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;

Line 6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;

6283: l_blId_tab pa_plsql_datatypes.NumTabTyp;
6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6289: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6290: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6291: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;

Line 6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;

6284: l_txn_cur_tab pa_plsql_datatypes.Char30TabTyp;
6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6289: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6290: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6291: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6292: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;

Line 6289: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;

6285: l_sdate_tab pa_plsql_datatypes.DateTabTyp;
6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6289: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6290: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6291: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6292: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;
6293:

Line 6290: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;

6286: l_ratebase_tab pa_plsql_datatypes.Char10TabTyp;
6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6289: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6290: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6291: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6292: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;
6293:
6294: CURSOR cur_rndQty IS

Line 6291: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;

6287: l_rawCost_new_tab pa_plsql_datatypes.NumTabTyp;
6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6289: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6290: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6291: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6292: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;
6293:
6294: CURSOR cur_rndQty IS
6295: SELECT tmp.resource_assignment_id

Line 6292: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;

6288: l_rawcost_old_tab pa_plsql_datatypes.NumTabTyp;
6289: l_rawcost_diff_tab pa_plsql_datatypes.NumTabTyp;
6290: l_revenue_new_tab pa_plsql_datatypes.NumTabTyp;
6291: l_revenue_old_tab pa_plsql_datatypes.NumTabTyp;
6292: l_revenue_diff_tab pa_plsql_datatypes.NumTabTyp;
6293:
6294: CURSOR cur_rndQty IS
6295: SELECT tmp.resource_assignment_id
6296: ,tmp.txn_currency_code

Line 6758: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;

6754: AND tmp.resource_assignment_id = pbl.resource_assignment_id
6755: )
6756: GROUP BY pbl.resource_assignment_id;
6757:
6758: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6759: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6760: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6761: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 6759: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;

6755: )
6756: GROUP BY pbl.resource_assignment_id;
6757:
6758: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6759: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6760: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6761: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6760: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

6756: GROUP BY pbl.resource_assignment_id;
6757:
6758: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6759: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6760: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6761: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6761: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

6757:
6758: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6759: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6760: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6761: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;

6758: l_resource_assignment_id_tab pa_plsql_datatypes.NumTabTyp;
6759: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6760: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6761: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

Line 6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

6759: l_pfc_quantity_tab pa_plsql_datatypes.NumTabTyp;
6760: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6761: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

6760: l_pfc_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6761: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;

6761: l_pfc_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6769: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;

6762: l_pfc_revenue_tab pa_plsql_datatypes.NumTabTyp;
6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6769: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6770: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

6763: l_project_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6769: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6770: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6771: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

6764: l_project_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6769: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6770: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6771: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6772: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 6769: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

6765: l_project_revenue_tab pa_plsql_datatypes.NumTabTyp;
6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6769: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6770: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6771: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6772: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6773:

Line 6770: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

6766: l_pfc_init_quantity_tab pa_plsql_datatypes.NumTabTyp;
6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6769: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6770: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6771: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6772: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6773:
6774: l_user_id Number;

Line 6771: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

6767: l_pfc_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6769: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6770: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6771: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6772: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6773:
6774: l_user_id Number;
6775: l_login_id Number;

Line 6772: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;

6768: l_pfc_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6769: l_pfc_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6770: l_project_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
6771: l_project_init_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
6772: l_project_init_revenue_tab pa_plsql_datatypes.NumTabTyp;
6773:
6774: l_user_id Number;
6775: l_login_id Number;
6776:

Line 7575: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;

7571: )
7572: group by tmp1.resource_assignment_id
7573: ,tmp1.txn_currency_code;
7574:
7575: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7576: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7577: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7578: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7579: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 7576: l_raid_tab pa_plsql_datatypes.IdTabTyp;

7572: group by tmp1.resource_assignment_id
7573: ,tmp1.txn_currency_code;
7574:
7575: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7576: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7577: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7578: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7579: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7580: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;

Line 7577: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

7573: ,tmp1.txn_currency_code;
7574:
7575: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7576: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7577: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7578: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7579: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7580: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7581: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 7578: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

7574:
7575: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7576: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7577: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7578: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7579: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7580: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7581: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7582: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 7579: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

7575: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
7576: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7577: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7578: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7579: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7580: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7581: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7582: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7583:

Line 7580: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;

7576: l_raid_tab pa_plsql_datatypes.IdTabTyp;
7577: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7578: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7579: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7580: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7581: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7582: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7583:
7584: BEGIN

Line 7581: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

7577: l_txn_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7578: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7579: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7580: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7581: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7582: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7583:
7584: BEGIN
7585: x_return_status := 'S';

Line 7582: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;

7578: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
7579: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
7580: l_period_name_tab pa_plsql_datatypes.Char80TabTyp;
7581: l_proj_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7582: l_projfunc_cur_code_tab pa_plsql_datatypes.Char30TabTyp;
7583:
7584: BEGIN
7585: x_return_status := 'S';
7586: x_msg_data := NULL;

Line 8141: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;

8137: l_plan_edate_shrunk_flag Varchar2(10) := 'N';
8138: l_ra_in_multi_cur_flag Varchar2(10) := 'N';
8139:
8140: /* declared the following tbl for client extn bulk update */
8141: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8142: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8143: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8144: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 8142: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

8138: l_ra_in_multi_cur_flag Varchar2(10) := 'N';
8139:
8140: /* declared the following tbl for client extn bulk update */
8141: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8142: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8143: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8144: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 8143: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;

8139:
8140: /* declared the following tbl for client extn bulk update */
8141: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8142: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8143: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8144: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;

Line 8144: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

8140: /* declared the following tbl for client extn bulk update */
8141: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8142: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8143: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8144: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8148: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;

Line 8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;

8141: l_cl_txn_plan_quantity_tab pa_plsql_datatypes.NumTabTyp;
8142: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8143: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8144: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8148: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8149: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

Line 8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;

8142: l_cl_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
8143: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8144: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8148: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8149: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8150: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

Line 8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;

8143: l_cl_txn_burdened_cost_tab pa_plsql_datatypes.NumTabTyp;
8144: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8148: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8149: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8150: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8151: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

Line 8148: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;

8144: l_cl_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8148: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8149: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8150: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8151: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8152: l_cl_cntr NUMBER := 0;

Line 8149: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

8145: l_cl_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8148: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8149: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8150: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8151: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8152: l_cl_cntr NUMBER := 0;
8153: l_cl_raw_rejection_code VARCHAR2(30);

Line 8150: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

8146: l_cl_burden_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8148: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8149: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8150: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8151: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8152: l_cl_cntr NUMBER := 0;
8153: l_cl_raw_rejection_code VARCHAR2(30);
8154: l_cl_burd_rejection_code VARCHAR2(30);

Line 8151: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;

8147: l_cl_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
8148: l_cl_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8149: l_cl_raw_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8150: l_cl_burd_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8151: l_cl_rev_rejection_code_tab pa_plsql_datatypes.char30TabTyp;
8152: l_cl_cntr NUMBER := 0;
8153: l_cl_raw_rejection_code VARCHAR2(30);
8154: l_cl_burd_rejection_code VARCHAR2(30);
8155: l_cl_rev_rejection_code VARCHAR2(30);

Line 11862: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;

11858: l_rev_to_cost_conv_cur Varchar2(100);
11859:
11860: /* declared for bulk processing of rollup tmp update */
11861: l_rl_cntr NUMBER := 0;
11862: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
11863: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
11864: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
11865: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;

Line 11863: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;

11859:
11860: /* declared for bulk processing of rollup tmp update */
11861: l_rl_cntr NUMBER := 0;
11862: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
11863: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
11864: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
11865: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

Line 11864: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;

11860: /* declared for bulk processing of rollup tmp update */
11861: l_rl_cntr NUMBER := 0;
11862: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
11863: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
11864: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
11865: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;

Line 11865: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

11861: l_rl_cntr NUMBER := 0;
11862: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
11863: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
11864: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
11865: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

Line 11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;

11862: l_rlt_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
11863: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
11864: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
11865: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

11863: l_rlt_quantity_tab pa_plsql_datatypes.NumTabTyp;
11864: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
11865: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;

11864: l_rlt_bill_rate_tab pa_plsql_datatypes.NumTabTyp;
11865: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;

11865: l_rlt_bill_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;

Line 11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

11866: l_rlt_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;

11867: l_rlt_rw_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;

11868: l_rlt_burden_cost_rate_tab pa_plsql_datatypes.NumTabTyp;
11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;

11869: l_rlt_burden_cost_rate_ovr_tab pa_plsql_datatypes.NumTabTyp;
11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11877: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;

11870: l_rlt_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11877: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11878: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;

11871: l_rlt_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11877: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11878: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11879: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;

Line 11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;

11872: l_rlt_raw_revenue_tab pa_plsql_datatypes.NumTabTyp;
11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11877: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11878: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11879: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11880: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;

Line 11877: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;

11873: l_rlt_bill_markup_percent_tab pa_plsql_datatypes.NumTabTyp;
11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11877: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11878: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11879: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11880: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;
11881:

Line 11878: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;

11874: l_rlt_txn_curr_code_tab pa_plsql_datatypes.Char30TabTyp;
11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11877: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11878: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11879: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11880: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;
11881:
11882: /* Bug fix: 4294287 */

Line 11879: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;

11875: l_rlt_raw_cost_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11877: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11878: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11879: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11880: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;
11881:
11882: /* Bug fix: 4294287 */
11883: l_bill_markup_percentage Number;

Line 11880: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;

11876: l_rlt_burden_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11877: l_rlt_revenue_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11878: l_rlt_projfunc_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11879: l_rlt_project_rejection_tab pa_plsql_datatypes.Char30TabTyp;
11880: l_rlt_ind_compiled_set_tab pa_plsql_datatypes.NumTabTyp;
11881:
11882: /* Bug fix: 4294287 */
11883: l_bill_markup_percentage Number;
11884: l_billable_flag Varchar2(10);