APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_PLSQL_DATATYPES

Line 150: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 151: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 153: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 154: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 155: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 156: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 157: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 158: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;

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

Line 159: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 160: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 161: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 163: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 164: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 165: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 166: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 167: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 168: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 169: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 170: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 172: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 173: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 174: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 512: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 513: l_draft_inv_num_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 515: l_ubr_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 516: l_ubr_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 517: l_uer_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 518: l_uer_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 519: l_gl_period_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 520: l_gl_period_name_arr PA_PLSQL_DATATYPES.Char80TabTyp;

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

Line 521: l_ubr_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 522: l_uer_amount_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 523: l_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 525: l_sum_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 526: l_sum_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 527: l_sum_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 528: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 529: l_sum_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 530: l_sum_proc_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 531: l_sum_ubr_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 532: l_sum_uer_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 534: l_zer_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 535: l_zer_gl_st_dt_arr PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 536: l_zer_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 868: l_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 869: l_draft_rev_num_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 871: l_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 872: l_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 874: l_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 875: l_gl_period_start_date_arr PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 876: l_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 877: l_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 879: l_upd_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 880: l_upd_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 881: l_upd_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 882: l_upd_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 883: l_upd_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 885: l_ins_summary_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 886: l_ins_sum_project_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 887: l_ins_acct_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 888: l_ins_cost_seg_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 889: l_ins_gl_period_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 890: l_ins_sum_amt_arr PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 891: l_ins_gl_per_stdt_arr PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 892: l_ins_ins_upd_flag_arr PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 895: l_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 896: l_upd_prev_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 897: l_ins_process_ubr_uer_arr PA_PLSQL_DATATYPES.Char30TabTyp;

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