11: AR_FLAG_DUMMY CONSTANT VARCHAR2(1) := '~';
12: AR_NUMBER_DUMMY CONSTANT NUMBER(15) := -999999999999999;
13: AR_DATE_DUMMY CONSTANT DATE := to_date(1, 'J');
14: /*-------------------------------------+
15: | WHO column values from ARP_GLOBAL |
16: +-------------------------------------*/
17: --
18: pg_request_id number;
19: pg_program_application_id number;
274: VALUES ( l_cr_id,
275: p_cr_rec.amount,
276: p_cr_rec.currency_code,
277: p_cr_rec.receipt_method_id,
278: arp_global.set_of_books_id,
279: p_cr_rec.comments,
280: p_cr_rec.confirmed_flag,
281: p_cr_rec.customer_bank_account_id,
282: p_cr_rec.customer_bank_branch_id,
320: pg_program_id,
321: DECODE( pg_program_id,
322: NULL, NULL,
323: SYSDATE),
324: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
325: SYSDATE,
326: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
327: SYSDATE,
328: arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login,*/
322: NULL, NULL,
323: SYSDATE),
324: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
325: SYSDATE,
326: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
327: SYSDATE,
328: arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login,*/
329: p_cr_rec.factor_discount_amount,
330: p_cr_rec.ussgl_transaction_code,
324: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
325: SYSDATE,
326: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
327: SYSDATE,
328: arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login,*/
329: p_cr_rec.factor_discount_amount,
330: p_cr_rec.ussgl_transaction_code,
331: p_cr_rec.ussgl_transaction_code_context,
332: p_cr_rec.reversal_reason_code,
423: p_cr_rec.receipt_method_id ),
424: set_of_books_id = DECODE( p_cr_rec.set_of_books_id,
425: AR_NUMBER_DUMMY, set_of_books_id,
426: -- pg_set_of_books_id ),
427: arp_global.set_of_books_id ),-- FP Bug 5964025
428: comments = DECODE( p_cr_rec.comments,
429: AR_TEXT_DUMMY, comments,
430: p_cr_rec.comments ),
431: confirmed_flag = DECODE( p_cr_rec.confirmed_flag,
550: program_id = pg_program_id,
551: program_update_date = DECODE( pg_program_id,
552: NULL, NULL,
553: SYSDATE),
554: last_updated_by = arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by, */
555: last_update_date = SYSDATE,
556: last_update_login = arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login, */
557: factor_discount_amount = DECODE( p_cr_rec.factor_discount_amount,
558: AR_NUMBER_DUMMY, factor_discount_amount,
552: NULL, NULL,
553: SYSDATE),
554: last_updated_by = arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by, */
555: last_update_date = SYSDATE,
556: last_update_login = arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login, */
557: factor_discount_amount = DECODE( p_cr_rec.factor_discount_amount,
558: AR_NUMBER_DUMMY, factor_discount_amount,
559: p_cr_rec.factor_discount_amount ),
560: ussgl_transaction_code = DECODE( p_cr_rec.ussgl_transaction_code,
1813: +---------------------------------------------*/
1814: --
1815: BEGIN
1816: --
1817: pg_request_id := arp_global.request_id;
1818: pg_program_application_id := arp_global.program_application_id;
1819: pg_program_id := arp_global.program_id;
1820: pg_program_update_date := arp_global.program_update_date;
1821: pg_last_updated_by := arp_global.last_updated_by;
1814: --
1815: BEGIN
1816: --
1817: pg_request_id := arp_global.request_id;
1818: pg_program_application_id := arp_global.program_application_id;
1819: pg_program_id := arp_global.program_id;
1820: pg_program_update_date := arp_global.program_update_date;
1821: pg_last_updated_by := arp_global.last_updated_by;
1822: pg_last_update_date := arp_global.last_update_date;
1815: BEGIN
1816: --
1817: pg_request_id := arp_global.request_id;
1818: pg_program_application_id := arp_global.program_application_id;
1819: pg_program_id := arp_global.program_id;
1820: pg_program_update_date := arp_global.program_update_date;
1821: pg_last_updated_by := arp_global.last_updated_by;
1822: pg_last_update_date := arp_global.last_update_date;
1823: pg_last_update_login := arp_global.last_update_login;
1816: --
1817: pg_request_id := arp_global.request_id;
1818: pg_program_application_id := arp_global.program_application_id;
1819: pg_program_id := arp_global.program_id;
1820: pg_program_update_date := arp_global.program_update_date;
1821: pg_last_updated_by := arp_global.last_updated_by;
1822: pg_last_update_date := arp_global.last_update_date;
1823: pg_last_update_login := arp_global.last_update_login;
1824: -- pg_set_of_books_id := arp_global.set_of_books_id;
1817: pg_request_id := arp_global.request_id;
1818: pg_program_application_id := arp_global.program_application_id;
1819: pg_program_id := arp_global.program_id;
1820: pg_program_update_date := arp_global.program_update_date;
1821: pg_last_updated_by := arp_global.last_updated_by;
1822: pg_last_update_date := arp_global.last_update_date;
1823: pg_last_update_login := arp_global.last_update_login;
1824: -- pg_set_of_books_id := arp_global.set_of_books_id;
1825: --
1818: pg_program_application_id := arp_global.program_application_id;
1819: pg_program_id := arp_global.program_id;
1820: pg_program_update_date := arp_global.program_update_date;
1821: pg_last_updated_by := arp_global.last_updated_by;
1822: pg_last_update_date := arp_global.last_update_date;
1823: pg_last_update_login := arp_global.last_update_login;
1824: -- pg_set_of_books_id := arp_global.set_of_books_id;
1825: --
1826: --
1819: pg_program_id := arp_global.program_id;
1820: pg_program_update_date := arp_global.program_update_date;
1821: pg_last_updated_by := arp_global.last_updated_by;
1822: pg_last_update_date := arp_global.last_update_date;
1823: pg_last_update_login := arp_global.last_update_login;
1824: -- pg_set_of_books_id := arp_global.set_of_books_id;
1825: --
1826: --
1827: END ARP_CASH_RECEIPTS_PKG;
1820: pg_program_update_date := arp_global.program_update_date;
1821: pg_last_updated_by := arp_global.last_updated_by;
1822: pg_last_update_date := arp_global.last_update_date;
1823: pg_last_update_login := arp_global.last_update_login;
1824: -- pg_set_of_books_id := arp_global.set_of_books_id;
1825: --
1826: --
1827: END ARP_CASH_RECEIPTS_PKG;