DBA Data[Home] [Help]

APPS.ARP_CASH_RECEIPTS_PKG dependencies on ARP_GLOBAL

Line 15: | WHO column values from ARP_GLOBAL |

11: AR_FLAG_DUMMY CONSTANT VARCHAR2(10) := '~';
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;

Line 274: arp_global.set_of_books_id,

270: VALUES ( l_cr_id,
271: p_cr_rec.amount,
272: p_cr_rec.currency_code,
273: p_cr_rec.receipt_method_id,
274: arp_global.set_of_books_id,
275: p_cr_rec.comments,
276: p_cr_rec.confirmed_flag,
277: p_cr_rec.customer_bank_account_id,
278: p_cr_rec.customer_bank_branch_id,

Line 320: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/

316: pg_program_id,
317: DECODE( pg_program_id,
318: NULL, NULL,
319: SYSDATE),
320: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
321: SYSDATE,
322: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
323: SYSDATE,
324: arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login,*/

Line 322: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/

318: NULL, NULL,
319: SYSDATE),
320: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
321: SYSDATE,
322: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
323: SYSDATE,
324: arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login,*/
325: p_cr_rec.factor_discount_amount,
326: p_cr_rec.ussgl_transaction_code,

Line 324: arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login,*/

320: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
321: SYSDATE,
322: arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by,*/
323: SYSDATE,
324: arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login,*/
325: p_cr_rec.factor_discount_amount,
326: p_cr_rec.ussgl_transaction_code,
327: p_cr_rec.ussgl_transaction_code_context,
328: p_cr_rec.reversal_reason_code,

Line 421: arp_global.set_of_books_id ),-- FP Bug 5964025

417: p_cr_rec.receipt_method_id ),
418: set_of_books_id = DECODE( p_cr_rec.set_of_books_id,
419: AR_NUMBER_DUMMY, set_of_books_id,
420: -- pg_set_of_books_id ),
421: arp_global.set_of_books_id ),-- FP Bug 5964025
422: comments = DECODE( p_cr_rec.comments,
423: AR_TEXT_DUMMY, comments,
424: p_cr_rec.comments ),
425: confirmed_flag = DECODE( p_cr_rec.confirmed_flag,

Line 548: last_updated_by = arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by, */

544: program_id = pg_program_id,
545: program_update_date = DECODE( pg_program_id,
546: NULL, NULL,
547: SYSDATE),
548: last_updated_by = arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by, */
549: last_update_date = SYSDATE,
550: last_update_login = arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login, */
551: factor_discount_amount = DECODE( p_cr_rec.factor_discount_amount,
552: AR_NUMBER_DUMMY, factor_discount_amount,

Line 550: last_update_login = arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login, */

546: NULL, NULL,
547: SYSDATE),
548: last_updated_by = arp_global.last_updated_by, /* FP Bug 5715840 pg_last_updated_by, */
549: last_update_date = SYSDATE,
550: last_update_login = arp_global.last_update_login, /* FP Bug 5715840 pg_last_update_login, */
551: factor_discount_amount = DECODE( p_cr_rec.factor_discount_amount,
552: AR_NUMBER_DUMMY, factor_discount_amount,
553: p_cr_rec.factor_discount_amount ),
554: ussgl_transaction_code = DECODE( p_cr_rec.ussgl_transaction_code,

Line 1788: pg_request_id := arp_global.request_id;

1784: +---------------------------------------------*/
1785: --
1786: BEGIN
1787: --
1788: pg_request_id := arp_global.request_id;
1789: pg_program_application_id := arp_global.program_application_id;
1790: pg_program_id := arp_global.program_id;
1791: pg_program_update_date := arp_global.program_update_date;
1792: pg_last_updated_by := arp_global.last_updated_by;

Line 1789: pg_program_application_id := arp_global.program_application_id;

1785: --
1786: BEGIN
1787: --
1788: pg_request_id := arp_global.request_id;
1789: pg_program_application_id := arp_global.program_application_id;
1790: pg_program_id := arp_global.program_id;
1791: pg_program_update_date := arp_global.program_update_date;
1792: pg_last_updated_by := arp_global.last_updated_by;
1793: pg_last_update_date := arp_global.last_update_date;

Line 1790: pg_program_id := arp_global.program_id;

1786: BEGIN
1787: --
1788: pg_request_id := arp_global.request_id;
1789: pg_program_application_id := arp_global.program_application_id;
1790: pg_program_id := arp_global.program_id;
1791: pg_program_update_date := arp_global.program_update_date;
1792: pg_last_updated_by := arp_global.last_updated_by;
1793: pg_last_update_date := arp_global.last_update_date;
1794: pg_last_update_login := arp_global.last_update_login;

Line 1791: pg_program_update_date := arp_global.program_update_date;

1787: --
1788: pg_request_id := arp_global.request_id;
1789: pg_program_application_id := arp_global.program_application_id;
1790: pg_program_id := arp_global.program_id;
1791: pg_program_update_date := arp_global.program_update_date;
1792: pg_last_updated_by := arp_global.last_updated_by;
1793: pg_last_update_date := arp_global.last_update_date;
1794: pg_last_update_login := arp_global.last_update_login;
1795: -- pg_set_of_books_id := arp_global.set_of_books_id;

Line 1792: pg_last_updated_by := arp_global.last_updated_by;

1788: pg_request_id := arp_global.request_id;
1789: pg_program_application_id := arp_global.program_application_id;
1790: pg_program_id := arp_global.program_id;
1791: pg_program_update_date := arp_global.program_update_date;
1792: pg_last_updated_by := arp_global.last_updated_by;
1793: pg_last_update_date := arp_global.last_update_date;
1794: pg_last_update_login := arp_global.last_update_login;
1795: -- pg_set_of_books_id := arp_global.set_of_books_id;
1796: --

Line 1793: pg_last_update_date := arp_global.last_update_date;

1789: pg_program_application_id := arp_global.program_application_id;
1790: pg_program_id := arp_global.program_id;
1791: pg_program_update_date := arp_global.program_update_date;
1792: pg_last_updated_by := arp_global.last_updated_by;
1793: pg_last_update_date := arp_global.last_update_date;
1794: pg_last_update_login := arp_global.last_update_login;
1795: -- pg_set_of_books_id := arp_global.set_of_books_id;
1796: --
1797: --

Line 1794: pg_last_update_login := arp_global.last_update_login;

1790: pg_program_id := arp_global.program_id;
1791: pg_program_update_date := arp_global.program_update_date;
1792: pg_last_updated_by := arp_global.last_updated_by;
1793: pg_last_update_date := arp_global.last_update_date;
1794: pg_last_update_login := arp_global.last_update_login;
1795: -- pg_set_of_books_id := arp_global.set_of_books_id;
1796: --
1797: --
1798: END ARP_CASH_RECEIPTS_PKG;

Line 1795: -- pg_set_of_books_id := arp_global.set_of_books_id;

1791: pg_program_update_date := arp_global.program_update_date;
1792: pg_last_updated_by := arp_global.last_updated_by;
1793: pg_last_update_date := arp_global.last_update_date;
1794: pg_last_update_login := arp_global.last_update_login;
1795: -- pg_set_of_books_id := arp_global.set_of_books_id;
1796: --
1797: --
1798: END ARP_CASH_RECEIPTS_PKG;