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;
208: )
209: VALUES (
210: l_cr_line_id,
211: p_icr_lines_rec.cash_receipt_id,
212: arp_global.last_updated_by,
213: arp_global.last_update_date,
214: arp_global.last_update_login,
215: arp_global.created_by,
216: arp_global.creation_date,
209: VALUES (
210: l_cr_line_id,
211: p_icr_lines_rec.cash_receipt_id,
212: arp_global.last_updated_by,
213: arp_global.last_update_date,
214: arp_global.last_update_login,
215: arp_global.created_by,
216: arp_global.creation_date,
217: p_icr_lines_rec.payment_amount,
210: l_cr_line_id,
211: p_icr_lines_rec.cash_receipt_id,
212: arp_global.last_updated_by,
213: arp_global.last_update_date,
214: arp_global.last_update_login,
215: arp_global.created_by,
216: arp_global.creation_date,
217: p_icr_lines_rec.payment_amount,
218: p_icr_lines_rec.amount_applied_from,
211: p_icr_lines_rec.cash_receipt_id,
212: arp_global.last_updated_by,
213: arp_global.last_update_date,
214: arp_global.last_update_login,
215: arp_global.created_by,
216: arp_global.creation_date,
217: p_icr_lines_rec.payment_amount,
218: p_icr_lines_rec.amount_applied_from,
219: p_icr_lines_rec.trans_to_receipt_rate,
212: arp_global.last_updated_by,
213: arp_global.last_update_date,
214: arp_global.last_update_login,
215: arp_global.created_by,
216: arp_global.creation_date,
217: p_icr_lines_rec.payment_amount,
218: p_icr_lines_rec.amount_applied_from,
219: p_icr_lines_rec.trans_to_receipt_rate,
220: p_icr_lines_rec.payment_schedule_id,
260: p_icr_lines_rec.global_attribute17,
261: p_icr_lines_rec.global_attribute18,
262: p_icr_lines_rec.global_attribute19,
263: p_icr_lines_rec.global_attribute20,
264: arp_global.request_id,
265: arp_global.program_application_id,
266: arp_global.program_update_date,
267: p_icr_lines_rec.ussgl_transaction_code,
268: p_icr_lines_rec.ussgl_transaction_code_context,
261: p_icr_lines_rec.global_attribute18,
262: p_icr_lines_rec.global_attribute19,
263: p_icr_lines_rec.global_attribute20,
264: arp_global.request_id,
265: arp_global.program_application_id,
266: arp_global.program_update_date,
267: p_icr_lines_rec.ussgl_transaction_code,
268: p_icr_lines_rec.ussgl_transaction_code_context,
269: p_icr_lines_rec.application_ref_type,
262: p_icr_lines_rec.global_attribute19,
263: p_icr_lines_rec.global_attribute20,
264: arp_global.request_id,
265: arp_global.program_application_id,
266: arp_global.program_update_date,
267: p_icr_lines_rec.ussgl_transaction_code,
268: p_icr_lines_rec.ussgl_transaction_code_context,
269: p_icr_lines_rec.application_ref_type,
270: p_icr_lines_rec.customer_reference,
1298: +---------------------------------------------*/
1299: --
1300: BEGIN
1301: --
1302: pg_request_id := arp_global.request_id;
1303: pg_program_application_id := arp_global.program_application_id;
1304: pg_program_id := arp_global.program_id;
1305: pg_program_update_date := arp_global.program_update_date;
1306: pg_last_updated_by := arp_global.last_updated_by;
1299: --
1300: BEGIN
1301: --
1302: pg_request_id := arp_global.request_id;
1303: pg_program_application_id := arp_global.program_application_id;
1304: pg_program_id := arp_global.program_id;
1305: pg_program_update_date := arp_global.program_update_date;
1306: pg_last_updated_by := arp_global.last_updated_by;
1307: pg_last_update_date := arp_global.last_update_date;
1300: BEGIN
1301: --
1302: pg_request_id := arp_global.request_id;
1303: pg_program_application_id := arp_global.program_application_id;
1304: pg_program_id := arp_global.program_id;
1305: pg_program_update_date := arp_global.program_update_date;
1306: pg_last_updated_by := arp_global.last_updated_by;
1307: pg_last_update_date := arp_global.last_update_date;
1308: pg_last_update_login := arp_global.last_update_login;
1301: --
1302: pg_request_id := arp_global.request_id;
1303: pg_program_application_id := arp_global.program_application_id;
1304: pg_program_id := arp_global.program_id;
1305: pg_program_update_date := arp_global.program_update_date;
1306: pg_last_updated_by := arp_global.last_updated_by;
1307: pg_last_update_date := arp_global.last_update_date;
1308: pg_last_update_login := arp_global.last_update_login;
1309: pg_set_of_books_id := arp_global.set_of_books_id;
1302: pg_request_id := arp_global.request_id;
1303: pg_program_application_id := arp_global.program_application_id;
1304: pg_program_id := arp_global.program_id;
1305: pg_program_update_date := arp_global.program_update_date;
1306: pg_last_updated_by := arp_global.last_updated_by;
1307: pg_last_update_date := arp_global.last_update_date;
1308: pg_last_update_login := arp_global.last_update_login;
1309: pg_set_of_books_id := arp_global.set_of_books_id;
1310: --
1303: pg_program_application_id := arp_global.program_application_id;
1304: pg_program_id := arp_global.program_id;
1305: pg_program_update_date := arp_global.program_update_date;
1306: pg_last_updated_by := arp_global.last_updated_by;
1307: pg_last_update_date := arp_global.last_update_date;
1308: pg_last_update_login := arp_global.last_update_login;
1309: pg_set_of_books_id := arp_global.set_of_books_id;
1310: --
1311: --
1304: pg_program_id := arp_global.program_id;
1305: pg_program_update_date := arp_global.program_update_date;
1306: pg_last_updated_by := arp_global.last_updated_by;
1307: pg_last_update_date := arp_global.last_update_date;
1308: pg_last_update_login := arp_global.last_update_login;
1309: pg_set_of_books_id := arp_global.set_of_books_id;
1310: --
1311: --
1312: END ARP_CR_ICR_LINES_PKG;
1305: pg_program_update_date := arp_global.program_update_date;
1306: pg_last_updated_by := arp_global.last_updated_by;
1307: pg_last_update_date := arp_global.last_update_date;
1308: pg_last_update_login := arp_global.last_update_login;
1309: pg_set_of_books_id := arp_global.set_of_books_id;
1310: --
1311: --
1312: END ARP_CR_ICR_LINES_PKG;
1313: --