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_CASH_RECEIPTS_PKG dependencies on AR_CASH_RECEIPTS

Line 29: PROCEDURE set_to_dummy( p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ) IS

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

Line 150: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE ) IS

146: RAISE;
147: END set_to_dummy;
148: --
149: PROCEDURE insert_p(
150: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE ) IS
151:
152: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
153: l_cr_key_value_list gl_ca_utility_pkg.r_key_value_arr;
154: l_rec_version_number ar_cash_receipts.rec_version_number%TYPE := 1 ; /* Bug fix 3226723 */

Line 152: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

148: --
149: PROCEDURE insert_p(
150: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE ) IS
151:
152: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
153: l_cr_key_value_list gl_ca_utility_pkg.r_key_value_arr;
154: l_rec_version_number ar_cash_receipts.rec_version_number%TYPE := 1 ; /* Bug fix 3226723 */
155: --begin LE
156: l_legal_entity_id number;

Line 154: l_rec_version_number ar_cash_receipts.rec_version_number%TYPE := 1 ; /* Bug fix 3226723 */

150: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE ) IS
151:
152: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
153: l_cr_key_value_list gl_ca_utility_pkg.r_key_value_arr;
154: l_rec_version_number ar_cash_receipts.rec_version_number%TYPE := 1 ; /* Bug fix 3226723 */
155: --begin LE
156: l_legal_entity_id number;
157: --end LE
158:

Line 164: SELECT ar_cash_receipts_s.nextval

160: IF PG_DEBUG in ('Y', 'C') THEN
161: arp_util.debug( 'arp_cash_receipts_pkg.insert_p()+' );
162: END IF;
163: --
164: SELECT ar_cash_receipts_s.nextval
165: INTO l_cr_id
166: FROM dual;
167: --
168:

Line 169: INSERT INTO ar_cash_receipts (

165: INTO l_cr_id
166: FROM dual;
167: --
168:
169: INSERT INTO ar_cash_receipts (
170: cash_receipt_id,
171: amount,
172: currency_code,
173: receipt_method_id,

Line 381: p_table_name => 'AR_CASH_RECEIPTS',

377: +-----------------------------------*/
378:
379: ar_mrc_engine.maintain_mrc_data(
380: p_event_mode => 'INSERT',
381: p_table_name => 'AR_CASH_RECEIPTS',
382: p_mode => 'SINGLE',
383: p_key_value => l_cr_id);
384:
385: --

Line 398: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE,

394: END IF;
395: RAISE;
396: END insert_p;
397: --
398: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE,
399: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
400: BEGIN
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );

Line 399: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS

395: RAISE;
396: END insert_p;
397: --
398: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE,
399: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
400: BEGIN
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
403: END IF;

Line 406: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');

402: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
403: END IF;
404: --
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');
407: END IF;
408: UPDATE ar_cash_receipts SET
409: amount = DECODE( p_cr_rec.amount,
410: AR_NUMBER_DUMMY, amount,

Line 408: UPDATE ar_cash_receipts SET

404: --
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');
407: END IF;
408: UPDATE ar_cash_receipts SET
409: amount = DECODE( p_cr_rec.amount,
410: AR_NUMBER_DUMMY, amount,
411: p_cr_rec.amount ),
412: currency_code = DECODE( p_cr_rec.currency_code,

Line 714: p_table_name => 'AR_CASH_RECEIPTS',

710: +-----------------------------------*/
711:
712: ar_mrc_engine.maintain_mrc_data(
713: p_event_mode => 'UPDATE',
714: p_table_name => 'AR_CASH_RECEIPTS',
715: p_mode => 'SINGLE',
716: p_key_value => p_cr_id);
717:
718: --

Line 737: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS

733: --
734: -- Removed the UPDATE statement from this procedure. It now calls the new
735: -- update_p to physically do the update.
736: ---------------------------------------------------------------------------------
737: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS
738: BEGIN
739: IF PG_DEBUG in ('Y', 'C') THEN
740: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
741: END IF;

Line 753: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS

749: --
750: END update_p;
751: --
752: PROCEDURE delete_p(
753: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
754: BEGIN
755: IF PG_DEBUG in ('Y', 'C') THEN
756: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()+' );
757: END IF;

Line 759: DELETE FROM ar_cash_receipts

755: IF PG_DEBUG in ('Y', 'C') THEN
756: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()+' );
757: END IF;
758: --
759: DELETE FROM ar_cash_receipts
760: WHERE cash_receipt_id = p_cr_id;
761:
762: /*-----------------------------------+
763: | Calling Central MRC library for |

Line 769: p_table_name => 'AR_CASH_RECEIPTS',

765: +-----------------------------------*/
766:
767: ar_mrc_engine.maintain_mrc_data(
768: p_event_mode => 'DELETE',
769: p_table_name => 'AR_CASH_RECEIPTS',
770: p_mode => 'SINGLE',
771: p_key_value => p_cr_id);
772:
773: --

Line 786: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS

782: RAISE;
783: END delete_p;
784: --
785: PROCEDURE lock_p(
786: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
787: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
788: BEGIN
789: IF PG_DEBUG in ('Y', 'C') THEN
790: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()+' );

Line 787: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

783: END delete_p;
784: --
785: PROCEDURE lock_p(
786: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
787: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
788: BEGIN
789: IF PG_DEBUG in ('Y', 'C') THEN
790: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()+' );
791: END IF;

Line 795: FROM ar_cash_receipts

791: END IF;
792: --
793: SELECT cash_receipt_id
794: INTO l_cr_id
795: FROM ar_cash_receipts
796: WHERE cash_receipt_id = p_cr_id
797: FOR UPDATE OF STATUS;
798: --
799: IF PG_DEBUG in ('Y', 'C') THEN

Line 812: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS

808: END lock_p;
809: --
810: --
811: PROCEDURE nowaitlock_p(
812: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
813: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
814: BEGIN
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()+' );

Line 813: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

809: --
810: --
811: PROCEDURE nowaitlock_p(
812: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
813: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
814: BEGIN
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()+' );
817: END IF;

Line 821: FROM ar_cash_receipts

817: END IF;
818: --
819: SELECT cash_receipt_id
820: INTO l_cr_id
821: FROM ar_cash_receipts
822: WHERE cash_receipt_id = p_cr_id
823: FOR UPDATE OF STATUS NOWAIT;
824: --
825: IF PG_DEBUG in ('Y', 'C') THEN

Line 839: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

835: --
836: /* Bug fix 3226723
837: Locking procedure with additional parameter rec_version_number added */
838: PROCEDURE nowaitlock_version_p(
839: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
840: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE DEFAULT NULL ) IS
841: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
842: BEGIN
843: IF PG_DEBUG in ('Y', 'C') THEN

Line 840: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE DEFAULT NULL ) IS

836: /* Bug fix 3226723
837: Locking procedure with additional parameter rec_version_number added */
838: PROCEDURE nowaitlock_version_p(
839: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
840: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE DEFAULT NULL ) IS
841: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
842: BEGIN
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );

Line 841: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

837: Locking procedure with additional parameter rec_version_number added */
838: PROCEDURE nowaitlock_version_p(
839: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
840: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE DEFAULT NULL ) IS
841: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
842: BEGIN
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );
845: arp_util.debug('Cash receipt_id = '||to_char(p_cr_id));

Line 852: FROM ar_cash_receipts

848: --
849:
850: SELECT cash_receipt_id
851: INTO l_cr_id
852: FROM ar_cash_receipts
853: WHERE cash_receipt_id = p_cr_id
854: AND (
855: rec_version_number = p_rec_version_number
856: OR

Line 873: PROCEDURE update_version_number(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE) IS

869: END IF;
870: RAISE;
871: END nowaitlock_version_p;
872:
873: PROCEDURE update_version_number(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE) IS
874: BEGIN
875: IF PG_DEBUG in ('Y', 'C') THEN
876: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()+' );
877: END IF;

Line 879: update ar_cash_receipts

875: IF PG_DEBUG in ('Y', 'C') THEN
876: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()+' );
877: END IF;
878:
879: update ar_cash_receipts
880: set rec_version_number = nvl(rec_version_number,1)+1
881: where cash_receipt_id = p_cr_id;
882:
883: IF PG_DEBUG in ('Y', 'C') THEN

Line 896: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS

892: END update_version_number;
893:
894: /* End bug fix 3226723 */
895: PROCEDURE fetch_p(
896: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
897: BEGIN
898: IF PG_DEBUG in ('Y', 'C') THEN
899: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()+' );
900: END IF;

Line 904: FROM ar_cash_receipts

900: END IF;
901: --
902: SELECT *
903: INTO p_cr_rec
904: FROM ar_cash_receipts
905: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id;
906: --
907: IF PG_DEBUG in ('Y', 'C') THEN
908: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()-' );

Line 922: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS

918: END fetch_p;
919: --
920: --
921: PROCEDURE lock_fetch_p(
922: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
923: BEGIN
924: IF PG_DEBUG in ('Y', 'C') THEN
925: arp_util.debug( 'arp_cash_receipts_pkg.lock_fetch_p()+' );
926: END IF;

Line 930: FROM ar_cash_receipts

926: END IF;
927: --
928: SELECT *
929: INTO p_cr_rec
930: FROM ar_cash_receipts
931: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
932: FOR UPDATE OF status;
933: --
934: IF PG_DEBUG in ('Y', 'C') THEN

Line 949: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS

945: END lock_fetch_p;
946: --
947: --
948: PROCEDURE nowaitlock_fetch_p(
949: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
950: BEGIN
951: IF PG_DEBUG in ('Y', 'C') THEN
952: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_fetch_p()+' );
953: END IF;

Line 957: FROM ar_cash_receipts

953: END IF;
954: --
955: SELECT *
956: INTO p_cr_rec
957: FROM ar_cash_receipts
958: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
959: FOR UPDATE OF status NOWAIT;
960: --
961: IF PG_DEBUG in ('Y', 'C') THEN

Line 980: FROM ar_cash_receipts cr,

976: p_batch_id IN ar_batches.batch_id%TYPE ) IS
977: --
978: CURSOR lock_C IS
979: SELECT 'lock'
980: FROM ar_cash_receipts cr,
981: ar_cash_receipt_history crh
982: WHERE cr.cash_receipt_id = crh.cash_receipt_id
983: AND crh.batch_id = p_batch_id
984: FOR UPDATE OF cr.status;

Line 1017: FROM ar_cash_receipts cr,

1013: p_batch_id IN ar_batches.batch_id%TYPE ) IS
1014: --
1015: CURSOR lock_C IS
1016: SELECT 'lock'
1017: FROM ar_cash_receipts cr,
1018: ar_cash_receipt_history crh
1019: WHERE cr.cash_receipt_id = crh.cash_receipt_id
1020: AND crh.batch_id = p_batch_id
1021: FOR UPDATE OF cr.status NOWAIT;

Line 1049: PROCEDURE lock_compare_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS

1045: RAISE;
1046: END nowaitlock_f_batch_id;
1047: --
1048: --
1049: PROCEDURE lock_compare_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS
1050:
1051: l_new_cr_rec ar_cash_receipts%ROWTYPE;
1052: l_exchange_date DATE;
1053:

Line 1051: l_new_cr_rec ar_cash_receipts%ROWTYPE;

1047: --
1048: --
1049: PROCEDURE lock_compare_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS
1050:
1051: l_new_cr_rec ar_cash_receipts%ROWTYPE;
1052: l_exchange_date DATE;
1053:
1054: BEGIN
1055: IF PG_DEBUG in ('Y', 'C') THEN

Line 1068: FROM ar_cash_receipts cr

1064: END IF;
1065:
1066: SELECT exchange_date
1067: INTO l_exchange_date
1068: FROM ar_cash_receipts cr
1069: WHERE cr.cash_receipt_id = p_cr_rec.cash_receipt_id
1070: AND TO_CHAR(cr.exchange_date,'DD-MON-RR') =
1071: TO_CHAR(p_cr_rec.exchange_date,'DD-MON-RR');
1072:

Line 1084: ar_cash_receipts cr

1080: SELECT *
1081: INTO
1082: l_new_cr_rec
1083: FROM
1084: ar_cash_receipts cr
1085: WHERE
1086: cr.cash_receipt_id = p_cr_rec.cash_receipt_id
1087: AND
1088: NVL(cr.amount, AR_NUMBER_DUMMY) =