eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CR_HISTORY_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 30: PROCEDURE set_to_dummy( p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE ) IS

26: pg_set_of_books_id number;
27: --
28: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
29:
30: PROCEDURE set_to_dummy( p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE ) IS
31: BEGIN
32: IF PG_DEBUG in ('Y', 'C') THEN
33: arp_standard.debug( 'arp_cr_history_pkg.set_to_dummy()+' );
34: END IF;

Line 92: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE,

88: END set_to_dummy;
89: --
90: -- New update_p procedure
91: --
92: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
93: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
94: BEGIN
95: IF PG_DEBUG in ('Y', 'C') THEN
96: arp_standard.debug( 'arp_cr_history_pkg.update_p()+' );

Line 93: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

89: --
90: -- New update_p procedure
91: --
92: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
93: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
94: BEGIN
95: IF PG_DEBUG in ('Y', 'C') THEN
96: arp_standard.debug( 'arp_cr_history_pkg.update_p()+' );
97: END IF;

Line 99: UPDATE ar_cash_receipt_history SET

95: IF PG_DEBUG in ('Y', 'C') THEN
96: arp_standard.debug( 'arp_cr_history_pkg.update_p()+' );
97: END IF;
98: --
99: UPDATE ar_cash_receipt_history SET
100: amount = DECODE( p_crh_rec.amount,
101: AR_NUMBER_DUMMY, amount,
102: p_crh_rec.amount ),
103: acctd_amount = DECODE( p_crh_rec.acctd_amount,

Line 252: p_table_name => 'AR_CASH_RECEIPT_HISTORY',

248: +----------------------------------------------------*/
249:
250: ar_mrc_engine.maintain_mrc_data(
251: p_event_mode => 'UPDATE',
252: p_table_name => 'AR_CASH_RECEIPT_HISTORY',
253: p_mode => 'SINGLE',
254: p_key_value => p_crh_rec.cash_receipt_history_id
255: );
256:

Line 270: p_crh_rec IN ar_cash_receipt_history%ROWTYPE,

266: RAISE;
267: END update_p;
268: --
269: PROCEDURE insert_p(
270: p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
271: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
272: --
273: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
274: BEGIN

Line 271: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

267: END update_p;
268: --
269: PROCEDURE insert_p(
270: p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
271: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
272: --
273: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
274: BEGIN
275: IF PG_DEBUG in ('Y', 'C') THEN

Line 273: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

269: PROCEDURE insert_p(
270: p_crh_rec IN ar_cash_receipt_history%ROWTYPE,
271: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
272: --
273: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
274: BEGIN
275: IF PG_DEBUG in ('Y', 'C') THEN
276: arp_standard.debug('update_p: ' || 'arp_cr_history_pkg.insert_p()+' );
277: END IF;

Line 279: SELECT ar_cash_receipt_history_s.nextval

275: IF PG_DEBUG in ('Y', 'C') THEN
276: arp_standard.debug('update_p: ' || 'arp_cr_history_pkg.insert_p()+' );
277: END IF;
278: --
279: SELECT ar_cash_receipt_history_s.nextval
280: INTO l_crh_id
281: FROM dual;
282: --
283: INSERT INTO ar_cash_receipt_history (

Line 283: INSERT INTO ar_cash_receipt_history (

279: SELECT ar_cash_receipt_history_s.nextval
280: INTO l_crh_id
281: FROM dual;
282: --
283: INSERT INTO ar_cash_receipt_history (
284: cash_receipt_history_id,
285: amount,
286: acctd_amount,
287: cash_receipt_id,

Line 408: p_table_name => 'AR_CASH_RECEIPT_HISTORY',

404: +-------------------------------------------*/
405:
406: ar_mrc_engine.maintain_mrc_data(
407: p_event_mode => 'INSERT',
408: p_table_name => 'AR_CASH_RECEIPT_HISTORY',
409: p_mode => 'SINGLE',
410: p_key_value => l_crh_id);
411:
412: p_crh_id := l_crh_id;

Line 428: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE ) IS

424: END insert_p;
425: --
426: -- Old update_p procedure retianed for compatibiltiy sake
427: --
428: PROCEDURE update_p( p_crh_rec IN ar_cash_receipt_history%ROWTYPE ) IS
429: BEGIN
430: IF PG_DEBUG in ('Y', 'C') THEN
431: arp_standard.debug( 'arp_cr_history_pkg.update_p()+' );
432: END IF;

Line 434: UPDATE ar_cash_receipt_history SET

430: IF PG_DEBUG in ('Y', 'C') THEN
431: arp_standard.debug( 'arp_cr_history_pkg.update_p()+' );
432: END IF;
433: --
434: UPDATE ar_cash_receipt_history SET
435: amount = p_crh_rec.amount,
436: acctd_amount = p_crh_rec.acctd_amount,
437: factor_flag = p_crh_rec.factor_flag,
438: first_posted_record_flag =

Line 512: p_table_name => 'AR_CASH_RECEIPT_HISTORY',

508: +----------------------------------------------------*/
509:
510: ar_mrc_engine.maintain_mrc_data(
511: p_event_mode => 'UPDATE',
512: p_table_name => 'AR_CASH_RECEIPT_HISTORY',
513: p_mode => 'SINGLE',
514: p_key_value => p_crh_rec.cash_receipt_history_id
515: );
516:

Line 530: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

526: RAISE;
527: END update_p;
528: --
529: PROCEDURE delete_p(
530: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
531: BEGIN
532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_standard.debug( 'arp_cr_history_pkg.delete_p()+' );
534: END IF;

Line 536: DELETE FROM ar_cash_receipt_history

532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_standard.debug( 'arp_cr_history_pkg.delete_p()+' );
534: END IF;
535: --
536: DELETE FROM ar_cash_receipt_history
537: WHERE cash_receipt_history_id = p_crh_id;
538: --
539: /*---------------------------------+
540: | Calling central MRC library |

Line 546: p_table_name => 'AR_CASH_RECEIPT_HISTORY',

542: +---------------------------------*/
543:
544: ar_mrc_engine.maintain_mrc_data(
545: p_event_mode => 'DELETE',
546: p_table_name => 'AR_CASH_RECEIPT_HISTORY',
547: p_mode => 'SINGLE',
548: p_key_value => p_crh_id);
549:
550:

Line 571: DELETE FROM ar_cash_receipt_history

567: IF PG_DEBUG in ('Y', 'C') THEN
568: arp_standard.debug( 'arp_cr_history_pkg.delete_p_cr()+' );
569: END IF;
570: --
571: DELETE FROM ar_cash_receipt_history
572: WHERE cash_receipt_id = p_cr_id
573: RETURNING cash_receipt_history_id
574: BULK COLLECT INTO l_rec_hist_key_value_list;
575:

Line 583: p_table_name => 'AR_CASH_RECEIPT_HISTORY',

579: +---------------------------------*/
580:
581: ar_mrc_engine.maintain_mrc_data(
582: p_event_mode => 'DELETE',
583: p_table_name => 'AR_CASH_RECEIPT_HISTORY',
584: p_mode => 'BATCH',
585: p_key_value_list => l_rec_hist_key_value_list
586: );
587: --

Line 600: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

596: RAISE;
597: END delete_p_cr;
598: --
599: PROCEDURE lock_p(
600: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
601: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
602: BEGIN
603: IF PG_DEBUG in ('Y', 'C') THEN
604: arp_standard.debug( 'arp_cr_history_pkg.lock_p()+' );

Line 601: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

597: END delete_p_cr;
598: --
599: PROCEDURE lock_p(
600: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
601: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
602: BEGIN
603: IF PG_DEBUG in ('Y', 'C') THEN
604: arp_standard.debug( 'arp_cr_history_pkg.lock_p()+' );
605: END IF;

Line 609: FROM ar_cash_receipt_history

605: END IF;
606: --
607: SELECT cash_receipt_history_id
608: INTO l_crh_id
609: FROM ar_cash_receipt_history
610: WHERE cash_receipt_history_id = p_crh_id
611: FOR UPDATE OF STATUS;
612: --
613: IF PG_DEBUG in ('Y', 'C') THEN

Line 625: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

621: RAISE;
622: END lock_p;
623: --
624: PROCEDURE nowaitlock_p(
625: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
626: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
627: BEGIN
628: IF PG_DEBUG in ('Y', 'C') THEN
629: arp_standard.debug( 'arp_cr_history_pkg.nowaitlock_p()+' );

Line 626: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

622: END lock_p;
623: --
624: PROCEDURE nowaitlock_p(
625: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
626: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
627: BEGIN
628: IF PG_DEBUG in ('Y', 'C') THEN
629: arp_standard.debug( 'arp_cr_history_pkg.nowaitlock_p()+' );
630: END IF;

Line 634: FROM ar_cash_receipt_history

630: END IF;
631: --
632: SELECT cash_receipt_history_id
633: INTO l_crh_id
634: FROM ar_cash_receipt_history
635: WHERE cash_receipt_history_id = p_crh_id
636: FOR UPDATE OF status NOWAIT;
637: --
638: IF PG_DEBUG in ('Y', 'C') THEN

Line 650: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,

646: RAISE;
647: END nowaitlock_p;
648: --
649: PROCEDURE fetch_p(
650: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
651: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE ) IS
652: BEGIN
653: --
654: IF PG_DEBUG in ('Y', 'C') THEN

Line 651: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE ) IS

647: END nowaitlock_p;
648: --
649: PROCEDURE fetch_p(
650: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
651: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE ) IS
652: BEGIN
653: --
654: IF PG_DEBUG in ('Y', 'C') THEN
655: arp_standard.debug( 'arp_cr_history_pkg.fetch_p()+' );

Line 660: FROM ar_cash_receipt_history

656: END IF;
657: --
658: SELECT *
659: INTO p_crh_rec
660: FROM ar_cash_receipt_history
661: WHERE cash_receipt_history_id = p_crh_id;
662: IF PG_DEBUG in ('Y', 'C') THEN
663: arp_standard.debug( 'arp_cr_history_pkg.fetch_p()-' );
664: END IF;

Line 676: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE ) IS

672: END fetch_p;
673: --
674: PROCEDURE fetch_f_crid(
675: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
676: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE ) IS
677: BEGIN
678: IF PG_DEBUG in ('Y', 'C') THEN
679: arp_standard.debug( 'arp_cr_history_pkg.fetch_f_crid()+' );
680: END IF;

Line 684: FROM ar_cash_receipt_history

680: END IF;
681: --
682: SELECT *
683: INTO p_crh_rec
684: FROM ar_cash_receipt_history
685: WHERE cash_receipt_id = p_cr_id AND
686: current_record_flag = 'Y'
687: FOR UPDATE OF status;
688:

Line 705: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE ) IS

701: END fetch_f_crid;
702: --
703: --
704: PROCEDURE fetch_f_cr_id(
705: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE ) IS
706: BEGIN
707: IF PG_DEBUG in ('Y', 'C') THEN
708: arp_standard.debug( 'arp_cr_history_pkg.fetch_f_cr_id()+' );
709: END IF;

Line 713: FROM ar_cash_receipt_history

709: END IF;
710: --
711: SELECT *
712: INTO p_crh_rec
713: FROM ar_cash_receipt_history
714: WHERE cash_receipt_id = p_crh_rec.cash_receipt_id AND
715: current_record_flag = 'Y';
716: --
717: IF PG_DEBUG in ('Y', 'C') THEN

Line 732: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE) IS

728: END fetch_f_cr_id;
729: --
730: --
731: PROCEDURE lock_fetch_p(
732: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE) IS
733: BEGIN
734: IF PG_DEBUG in ('Y', 'C') THEN
735: arp_standard.debug( 'arp_cr_history_pkg.lock_fetch_p()+' );
736: END IF;

Line 740: FROM ar_cash_receipt_history

736: END IF;
737: --
738: SELECT *
739: INTO p_crh_rec
740: FROM ar_cash_receipt_history
741: WHERE cash_receipt_history_id = p_crh_rec.cash_receipt_history_id
742: FOR UPDATE OF status;
743: --
744: IF PG_DEBUG in ('Y', 'C') THEN

Line 759: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE) IS

755: END lock_fetch_p;
756: --
757: --
758: PROCEDURE nowaitlock_fetch_p(
759: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE) IS
760: BEGIN
761: IF PG_DEBUG in ('Y', 'C') THEN
762: arp_standard.debug( 'arp_cr_history_pkg.nowaitlock_fetch_p()+' );
763: END IF;

Line 767: FROM ar_cash_receipt_history

763: END IF;
764: --
765: SELECT *
766: INTO p_crh_rec
767: FROM ar_cash_receipt_history
768: WHERE cash_receipt_history_id = p_crh_rec.cash_receipt_history_id
769: FOR UPDATE OF status NOWAIT;
770: --
771: IF PG_DEBUG in ('Y', 'C') THEN

Line 790: FROM ar_cash_receipt_history

786: p_batch_id IN ar_batches.batch_id%TYPE ) IS
787: --
788: CURSOR lock_C IS
789: SELECT 'lock'
790: FROM ar_cash_receipt_history
791: WHERE batch_id = p_batch_id
792: FOR UPDATE OF status;
793: --
794: BEGIN

Line 825: FROM ar_cash_receipt_history

821: p_batch_id IN ar_batches.batch_id%TYPE ) IS
822: --
823: CURSOR lock_C IS
824: SELECT 'lock'
825: FROM ar_cash_receipt_history
826: WHERE batch_id = p_batch_id
827: FOR UPDATE OF status NOWAIT;
828: --
829: BEGIN

Line 860: FROM ar_cash_receipt_history

856: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
857: --
858: CURSOR lock_C IS
859: SELECT 'lock'
860: FROM ar_cash_receipt_history
861: WHERE cash_receipt_id = p_cr_id
862: FOR UPDATE OF status;
863: --
864: BEGIN

Line 895: FROM ar_cash_receipt_history

891: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
892: --
893: CURSOR lock_C IS
894: SELECT 'lock'
895: FROM ar_cash_receipt_history
896: WHERE cash_receipt_id = p_cr_id
897: FOR UPDATE OF status NOWAIT;
898: --
899: BEGIN

Line 925: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE) IS

921: RAISE;
922: END nowaitlock_f_cr_id;
923: --
924: PROCEDURE lock_fetch_f_cr_id(
925: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE) IS
926: BEGIN
927: IF PG_DEBUG in ('Y', 'C') THEN
928: arp_standard.debug( 'arp_cr_history_pkg.lock_fetch_f_cr_id()+' );
929: END IF;

Line 933: FROM ar_cash_receipt_history

929: END IF;
930: --
931: SELECT *
932: INTO p_crh_rec
933: FROM ar_cash_receipt_history
934: WHERE cash_receipt_id = p_crh_rec.cash_receipt_id
935: AND current_record_flag = 'Y'
936: FOR UPDATE OF status;
937: --

Line 953: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE) IS

949: END lock_fetch_f_cr_id;
950: --
951: --
952: PROCEDURE nowaitlock_fetch_f_cr_id(
953: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE) IS
954: BEGIN
955: IF PG_DEBUG in ('Y', 'C') THEN
956: arp_standard.debug( 'arp_cr_history_pkg.nowaitlock_fetch_f_cr_id()+' );
957: END IF;

Line 961: FROM ar_cash_receipt_history

957: END IF;
958: --
959: SELECT *
960: INTO p_crh_rec
961: FROM ar_cash_receipt_history
962: WHERE cash_receipt_id = p_crh_rec.cash_receipt_id
963: AND current_record_flag = 'Y'
964: FOR UPDATE OF status NOWAIT;
965: --

Line 981: p_crh_rec IN ar_cash_receipt_history%ROWTYPE) IS

977: END nowaitlock_fetch_f_cr_id;
978: --
979: /* Bug fix 2742388 */
980: PROCEDURE lock_hist_compare_p(
981: p_crh_rec IN ar_cash_receipt_history%ROWTYPE) IS
982: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
983: BEGIN
984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');

Line 982: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;

978: --
979: /* Bug fix 2742388 */
980: PROCEDURE lock_hist_compare_p(
981: p_crh_rec IN ar_cash_receipt_history%ROWTYPE) IS
982: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
983: BEGIN
984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));

Line 997: ar_cash_receipt_history crh

993: SELECT *
994: INTO
995: l_new_crh_rec
996: FROM
997: ar_cash_receipt_history crh
998: WHERE
999: crh.cash_receipt_history_id = p_crh_rec.cash_receipt_history_id
1000: AND crh.cash_receipt_id = p_crh_rec.cash_receipt_id
1001: AND