20: --
21: pg_cursor1 integer := '';
22: --
23: /*-------------------------------------+
24: | WHO column values from ARP_GLOBAL |
25: +-------------------------------------*/
26: --
27: pg_request_id number;
28: pg_program_application_id number;
192: p_icr_rec.amount,
193: p_icr_rec.amount_applied,
194: p_icr_rec.trans_to_receipt_rate,
195: p_icr_rec.factor_discount_amount,
196: arp_global.created_by,
197: arp_global.creation_date,
198: p_icr_rec.currency_code,
199: arp_global.last_updated_by,
200: arp_global.last_update_date,
193: p_icr_rec.amount_applied,
194: p_icr_rec.trans_to_receipt_rate,
195: p_icr_rec.factor_discount_amount,
196: arp_global.created_by,
197: arp_global.creation_date,
198: p_icr_rec.currency_code,
199: arp_global.last_updated_by,
200: arp_global.last_update_date,
201: p_icr_rec.receipt_method_id,
195: p_icr_rec.factor_discount_amount,
196: arp_global.created_by,
197: arp_global.creation_date,
198: p_icr_rec.currency_code,
199: arp_global.last_updated_by,
200: arp_global.last_update_date,
201: p_icr_rec.receipt_method_id,
202: p_icr_rec.remit_bank_acct_use_id,
203: p_icr_rec.batch_id,
196: arp_global.created_by,
197: arp_global.creation_date,
198: p_icr_rec.currency_code,
199: arp_global.last_updated_by,
200: arp_global.last_update_date,
201: p_icr_rec.receipt_method_id,
202: p_icr_rec.remit_bank_acct_use_id,
203: p_icr_rec.batch_id,
204: p_icr_rec.comments,
208: p_icr_rec.exchange_rate_type,
209: p_icr_rec.gl_date,
210: p_icr_rec.gl_posted_date,
211: p_icr_rec.anticipated_clearing_date,
212: arp_global.last_update_login,
213: p_icr_rec.payment_schedule_id,
214: p_icr_rec.pay_from_customer,
215: arp_global.program_application_id,
216: arp_global.program_id,
211: p_icr_rec.anticipated_clearing_date,
212: arp_global.last_update_login,
213: p_icr_rec.payment_schedule_id,
214: p_icr_rec.pay_from_customer,
215: arp_global.program_application_id,
216: arp_global.program_id,
217: arp_global.program_update_date,
218: p_icr_rec.receipt_date,
219: p_icr_rec.receipt_number,
212: arp_global.last_update_login,
213: p_icr_rec.payment_schedule_id,
214: p_icr_rec.pay_from_customer,
215: arp_global.program_application_id,
216: arp_global.program_id,
217: arp_global.program_update_date,
218: p_icr_rec.receipt_date,
219: p_icr_rec.receipt_number,
220: p_icr_rec.request_id,
213: p_icr_rec.payment_schedule_id,
214: p_icr_rec.pay_from_customer,
215: arp_global.program_application_id,
216: arp_global.program_id,
217: arp_global.program_update_date,
218: p_icr_rec.receipt_date,
219: p_icr_rec.receipt_number,
220: p_icr_rec.request_id,
221: p_icr_rec.site_use_id,
1152: +---------------------------------------------*/
1153: --
1154: BEGIN
1155: --
1156: pg_request_id := arp_global.request_id;
1157: pg_program_application_id := arp_global.program_application_id;
1158: pg_program_id := arp_global.program_id;
1159: pg_program_update_date := arp_global.program_update_date;
1160: pg_last_updated_by := arp_global.last_updated_by;
1153: --
1154: BEGIN
1155: --
1156: pg_request_id := arp_global.request_id;
1157: pg_program_application_id := arp_global.program_application_id;
1158: pg_program_id := arp_global.program_id;
1159: pg_program_update_date := arp_global.program_update_date;
1160: pg_last_updated_by := arp_global.last_updated_by;
1161: pg_last_update_date := arp_global.last_update_date;
1154: BEGIN
1155: --
1156: pg_request_id := arp_global.request_id;
1157: pg_program_application_id := arp_global.program_application_id;
1158: pg_program_id := arp_global.program_id;
1159: pg_program_update_date := arp_global.program_update_date;
1160: pg_last_updated_by := arp_global.last_updated_by;
1161: pg_last_update_date := arp_global.last_update_date;
1162: pg_last_update_login := arp_global.last_update_login;
1155: --
1156: pg_request_id := arp_global.request_id;
1157: pg_program_application_id := arp_global.program_application_id;
1158: pg_program_id := arp_global.program_id;
1159: pg_program_update_date := arp_global.program_update_date;
1160: pg_last_updated_by := arp_global.last_updated_by;
1161: pg_last_update_date := arp_global.last_update_date;
1162: pg_last_update_login := arp_global.last_update_login;
1163: pg_set_of_books_id := arp_global.set_of_books_id;
1156: pg_request_id := arp_global.request_id;
1157: pg_program_application_id := arp_global.program_application_id;
1158: pg_program_id := arp_global.program_id;
1159: pg_program_update_date := arp_global.program_update_date;
1160: pg_last_updated_by := arp_global.last_updated_by;
1161: pg_last_update_date := arp_global.last_update_date;
1162: pg_last_update_login := arp_global.last_update_login;
1163: pg_set_of_books_id := arp_global.set_of_books_id;
1164: --
1157: pg_program_application_id := arp_global.program_application_id;
1158: pg_program_id := arp_global.program_id;
1159: pg_program_update_date := arp_global.program_update_date;
1160: pg_last_updated_by := arp_global.last_updated_by;
1161: pg_last_update_date := arp_global.last_update_date;
1162: pg_last_update_login := arp_global.last_update_login;
1163: pg_set_of_books_id := arp_global.set_of_books_id;
1164: --
1165: --
1158: pg_program_id := arp_global.program_id;
1159: pg_program_update_date := arp_global.program_update_date;
1160: pg_last_updated_by := arp_global.last_updated_by;
1161: pg_last_update_date := arp_global.last_update_date;
1162: pg_last_update_login := arp_global.last_update_login;
1163: pg_set_of_books_id := arp_global.set_of_books_id;
1164: --
1165: --
1166: END ARP_CR_ICR_PKG;
1159: pg_program_update_date := arp_global.program_update_date;
1160: pg_last_updated_by := arp_global.last_updated_by;
1161: pg_last_update_date := arp_global.last_update_date;
1162: pg_last_update_login := arp_global.last_update_login;
1163: pg_set_of_books_id := arp_global.set_of_books_id;
1164: --
1165: --
1166: END ARP_CR_ICR_PKG;
1167: --