APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_PLSQL_DATATYPES

Line 152: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

148: end;
149:
150: procedure process_draft_revenues is
151:
152: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
153: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
154:
155: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
156: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 153: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;

149:
150: procedure process_draft_revenues is
151:
152: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
153: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
154:
155: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
156: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
157: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 155: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

151:
152: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
153: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
154:
155: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
156: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
157: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
158: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

Line 156: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

152: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
153: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
154:
155: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
156: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
157: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
158: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
160: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;

Line 157: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

153: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
154:
155: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
156: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
157: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
158: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
160: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
161: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 158: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

154:
155: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
156: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
157: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
158: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
160: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
161: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
162: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

155: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
156: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
157: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
158: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
160: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
161: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
162: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
163: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

Line 160: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;

156: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
157: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
158: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
160: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
161: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
162: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
163: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
164:

Line 161: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

157: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
158: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
160: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
161: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
162: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
163: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
164:
165: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 162: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

158: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
160: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
161: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
162: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
163: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
164:
165: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
166: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 163: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

159: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
160: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
161: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
162: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
163: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
164:
165: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
166: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
167: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 165: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

161: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
162: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
163: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
164:
165: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
166: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
167: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
168: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
169: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

Line 166: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

162: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
163: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
164:
165: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
166: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
167: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
168: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
169: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
170: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

Line 167: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

163: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
164:
165: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
166: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
167: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
168: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
169: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
170: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
171: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 168: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

164:
165: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
166: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
167: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
168: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
169: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
170: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
171: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
172: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 169: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

165: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
166: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
167: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
168: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
169: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
170: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
171: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
172: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
173:

Line 170: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

166: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
167: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
168: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
169: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
170: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
171: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
172: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
173:
174: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 171: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;

167: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
168: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
169: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
170: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
171: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
172: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
173:
174: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
175: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

Line 172: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;

168: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
169: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
170: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
171: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
172: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
173:
174: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
175: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
176: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

Line 174: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

170: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
171: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
172: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
173:
174: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
175: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
176: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
177:
178: l_row_count number := 0 ;

Line 175: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

171: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
172: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
173:
174: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
175: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
176: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
177:
178: l_row_count number := 0 ;
179: l_total_count number := 0 ;

Line 176: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

172: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
173:
174: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
175: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
176: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
177:
178: l_row_count number := 0 ;
179: l_total_count number := 0 ;
180: l_prev_total_count number := 0 ;

Line 514: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

510: end process_draft_revenues;
511:
512: procedure process_draft_invoices is
513:
514: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
515: l_draft_inv_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
516:
517: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
518: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 515: l_draft_inv_num_arr PA_PLSQL_DATATYPES.NumTabTyp;

511:
512: procedure process_draft_invoices is
513:
514: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
515: l_draft_inv_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
516:
517: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
518: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
519: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 517: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

513:
514: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
515: l_draft_inv_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
516:
517: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
518: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
519: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
520: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

Line 518: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

514: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
515: l_draft_inv_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
516:
517: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
518: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
519: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
520: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
522: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;

Line 519: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

515: l_draft_inv_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
516:
517: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
518: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
519: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
520: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
522: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
523: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 520: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

516:
517: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
518: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
519: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
520: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
522: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
523: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
524: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

517: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
518: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
519: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
520: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
522: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
523: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
524: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
525: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

Line 522: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;

518: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
519: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
520: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
522: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
523: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
524: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
525: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
526:

Line 523: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

519: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
520: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
522: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
523: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
524: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
525: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
526:
527: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 524: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

520: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
522: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
523: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
524: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
525: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
526:
527: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
528: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 525: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

521: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
522: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;
523: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
524: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
525: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
526:
527: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
528: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
529: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 527: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

523: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
524: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
525: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
526:
527: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
528: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
529: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
530: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
531: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

Line 528: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

524: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;
525: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
526:
527: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
528: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
529: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
530: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
531: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
532: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

Line 529: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

525: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
526:
527: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
528: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
529: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
530: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
531: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
532: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
533: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 530: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

526:
527: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
528: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
529: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
530: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
531: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
532: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
533: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
534: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 531: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

527: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
528: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
529: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
530: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
531: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
532: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
533: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
534: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
535:

Line 532: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

528: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
529: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
530: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
531: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
532: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
533: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
534: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
535:
536: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 533: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;

529: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
530: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
531: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
532: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
533: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
534: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
535:
536: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
537: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

Line 534: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;

530: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
531: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
532: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
533: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
534: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
535:
536: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
537: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
538: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

Line 536: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

532: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
533: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
534: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
535:
536: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
537: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
538: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
539:
540: l_row_count number := 0 ;

Line 537: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

533: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;
534: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
535:
536: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
537: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
538: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
539:
540: l_row_count number := 0 ;
541: l_total_count number := 0 ;

Line 538: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

534: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;
535:
536: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
537: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;
538: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
539:
540: l_row_count number := 0 ;
541: l_total_count number := 0 ;
542: l_prev_total_count number := 0 ;

Line 870: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

866:
867: procedure process_ubr_uer_summary ( p_source in varchar2 , p_process_ubr_uer in varchar2 ) is
868:
869:
870: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
871: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
872:
873: l_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
874: l_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 871: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;

867: procedure process_ubr_uer_summary ( p_source in varchar2 , p_process_ubr_uer in varchar2 ) is
868:
869:
870: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
871: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
872:
873: l_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
874: l_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
875:

Line 873: l_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

869:
870: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
871: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
872:
873: l_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
874: l_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
875:
876: l_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
877: l_gl_period_start_date_arr PA_PLSQL_DATATYPES.DateTabTyp;

Line 874: l_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

870: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
871: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;
872:
873: l_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
874: l_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
875:
876: l_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
877: l_gl_period_start_date_arr PA_PLSQL_DATATYPES.DateTabTyp;
878: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 876: l_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;

872:
873: l_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
874: l_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
875:
876: l_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
877: l_gl_period_start_date_arr PA_PLSQL_DATATYPES.DateTabTyp;
878: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
879: l_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
880:

Line 877: l_gl_period_start_date_arr PA_PLSQL_DATATYPES.DateTabTyp;

873: l_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
874: l_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
875:
876: l_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
877: l_gl_period_start_date_arr PA_PLSQL_DATATYPES.DateTabTyp;
878: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
879: l_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
880:
881: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 878: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

874: l_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
875:
876: l_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
877: l_gl_period_start_date_arr PA_PLSQL_DATATYPES.DateTabTyp;
878: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
879: l_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
880:
881: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
882: l_upd_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 879: l_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;

875:
876: l_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
877: l_gl_period_start_date_arr PA_PLSQL_DATATYPES.DateTabTyp;
878: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
879: l_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
880:
881: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
882: l_upd_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
883: l_upd_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 881: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

877: l_gl_period_start_date_arr PA_PLSQL_DATATYPES.DateTabTyp;
878: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
879: l_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
880:
881: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
882: l_upd_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
883: l_upd_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
884: l_upd_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;

Line 882: l_upd_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

878: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
879: l_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
880:
881: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
882: l_upd_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
883: l_upd_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
884: l_upd_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
886:

Line 883: l_upd_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

879: l_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
880:
881: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
882: l_upd_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
883: l_upd_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
884: l_upd_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
886:
887: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 884: l_upd_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

880:
881: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
882: l_upd_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
883: l_upd_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
884: l_upd_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
886:
887: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
888: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 885: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;

881: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
882: l_upd_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
883: l_upd_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
884: l_upd_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
886:
887: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
888: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
889: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 887: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

883: l_upd_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
884: l_upd_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
886:
887: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
888: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
889: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
891: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 888: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

884: l_upd_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
886:
887: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
888: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
889: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
891: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
892: l_ins_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;

Line 889: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

885: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
886:
887: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
888: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
889: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
891: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
892: l_ins_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;

Line 890: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

886:
887: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
888: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
889: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
891: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
892: l_ins_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
894: l_ins_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

Line 891: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;

887: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
888: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
889: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
891: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
892: l_ins_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
894: l_ins_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
895:

Line 892: l_ins_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;

888: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;
889: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
891: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
892: l_ins_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
894: l_ins_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
895:
896: l_t_count number;

Line 893: l_ins_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;

889: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
891: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
892: l_ins_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
894: l_ins_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
895:
896: l_t_count number;
897: l_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 894: l_ins_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

890: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;
891: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;
892: l_ins_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
894: l_ins_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
895:
896: l_t_count number;
897: l_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
898: l_upd_prev_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;

Line 897: l_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;

893: l_ins_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;
894: l_ins_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
895:
896: l_t_count number;
897: l_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
898: l_upd_prev_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_ins_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
900:
901: ins_j number;

Line 898: l_upd_prev_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;

894: l_ins_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;
895:
896: l_t_count number;
897: l_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
898: l_upd_prev_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_ins_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
900:
901: ins_j number;
902:

Line 899: l_ins_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;

895:
896: l_t_count number;
897: l_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
898: l_upd_prev_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_ins_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;
900:
901: ins_j number;
902:
903: CURSOR sum_cv IS