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 152: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE ) IS

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

Line 154: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

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

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

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

Line 166: SELECT ar_cash_receipts_s.nextval

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

Line 171: INSERT INTO ar_cash_receipts (

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

Line 387: p_table_name => 'AR_CASH_RECEIPTS',

383: +-----------------------------------*/
384:
385: ar_mrc_engine.maintain_mrc_data(
386: p_event_mode => 'INSERT',
387: p_table_name => 'AR_CASH_RECEIPTS',
388: p_mode => 'SINGLE',
389: p_key_value => l_cr_id);
390:
391: --

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

400: END IF;
401: RAISE;
402: END insert_p;
403: --
404: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE,
405: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
406: BEGIN
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );

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

401: RAISE;
402: END insert_p;
403: --
404: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE,
405: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
406: BEGIN
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
409: END IF;

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

408: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
409: END IF;
410: --
411: IF PG_DEBUG in ('Y', 'C') THEN
412: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');
413: END IF;
414: UPDATE ar_cash_receipts SET
415: amount = DECODE( p_cr_rec.amount,
416: AR_NUMBER_DUMMY, amount,

Line 414: UPDATE ar_cash_receipts SET

410: --
411: IF PG_DEBUG in ('Y', 'C') THEN
412: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');
413: END IF;
414: UPDATE ar_cash_receipts SET
415: amount = DECODE( p_cr_rec.amount,
416: AR_NUMBER_DUMMY, amount,
417: p_cr_rec.amount ),
418: currency_code = DECODE( p_cr_rec.currency_code,

Line 726: p_table_name => 'AR_CASH_RECEIPTS',

722: +-----------------------------------*/
723:
724: ar_mrc_engine.maintain_mrc_data(
725: p_event_mode => 'UPDATE',
726: p_table_name => 'AR_CASH_RECEIPTS',
727: p_mode => 'SINGLE',
728: p_key_value => p_cr_id);
729:
730: --

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

745: --
746: -- Removed the UPDATE statement from this procedure. It now calls the new
747: -- update_p to physically do the update.
748: ---------------------------------------------------------------------------------
749: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS
750: BEGIN
751: IF PG_DEBUG in ('Y', 'C') THEN
752: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
753: END IF;

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

761: --
762: END update_p;
763: --
764: PROCEDURE delete_p(
765: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
766: BEGIN
767: IF PG_DEBUG in ('Y', 'C') THEN
768: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()+' );
769: END IF;

Line 771: DELETE FROM ar_cash_receipts

767: IF PG_DEBUG in ('Y', 'C') THEN
768: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()+' );
769: END IF;
770: --
771: DELETE FROM ar_cash_receipts
772: WHERE cash_receipt_id = p_cr_id;
773:
774: /*-----------------------------------+
775: | Calling Central MRC library for |

Line 781: p_table_name => 'AR_CASH_RECEIPTS',

777: +-----------------------------------*/
778:
779: ar_mrc_engine.maintain_mrc_data(
780: p_event_mode => 'DELETE',
781: p_table_name => 'AR_CASH_RECEIPTS',
782: p_mode => 'SINGLE',
783: p_key_value => p_cr_id);
784:
785: --

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

794: RAISE;
795: END delete_p;
796: --
797: PROCEDURE lock_p(
798: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
799: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
800: BEGIN
801: IF PG_DEBUG in ('Y', 'C') THEN
802: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()+' );

Line 799: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

795: END delete_p;
796: --
797: PROCEDURE lock_p(
798: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
799: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
800: BEGIN
801: IF PG_DEBUG in ('Y', 'C') THEN
802: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()+' );
803: END IF;

Line 807: FROM ar_cash_receipts

803: END IF;
804: --
805: SELECT cash_receipt_id
806: INTO l_cr_id
807: FROM ar_cash_receipts
808: WHERE cash_receipt_id = p_cr_id
809: FOR UPDATE OF STATUS;
810: --
811: IF PG_DEBUG in ('Y', 'C') THEN

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

820: END lock_p;
821: --
822: --
823: PROCEDURE nowaitlock_p(
824: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
825: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
826: BEGIN
827: IF PG_DEBUG in ('Y', 'C') THEN
828: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()+' );

Line 825: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

821: --
822: --
823: PROCEDURE nowaitlock_p(
824: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
825: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
826: BEGIN
827: IF PG_DEBUG in ('Y', 'C') THEN
828: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()+' );
829: END IF;

Line 833: FROM ar_cash_receipts

829: END IF;
830: --
831: SELECT cash_receipt_id
832: INTO l_cr_id
833: FROM ar_cash_receipts
834: WHERE cash_receipt_id = p_cr_id
835: FOR UPDATE OF STATUS NOWAIT;
836: --
837: IF PG_DEBUG in ('Y', 'C') THEN

Line 851: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

847: --
848: /* Bug fix 3226723
849: Locking procedure with additional parameter rec_version_number added */
850: PROCEDURE nowaitlock_version_p(
851: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
852: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE DEFAULT NULL ) IS
853: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
854: BEGIN
855: IF PG_DEBUG in ('Y', 'C') THEN

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

848: /* Bug fix 3226723
849: Locking procedure with additional parameter rec_version_number added */
850: PROCEDURE nowaitlock_version_p(
851: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
852: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE DEFAULT NULL ) IS
853: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
854: BEGIN
855: IF PG_DEBUG in ('Y', 'C') THEN
856: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );

Line 853: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

849: Locking procedure with additional parameter rec_version_number added */
850: PROCEDURE nowaitlock_version_p(
851: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
852: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE DEFAULT NULL ) IS
853: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
854: BEGIN
855: IF PG_DEBUG in ('Y', 'C') THEN
856: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );
857: arp_util.debug('Cash receipt_id = '||to_char(p_cr_id));

Line 864: FROM ar_cash_receipts

860: --
861:
862: SELECT cash_receipt_id
863: INTO l_cr_id
864: FROM ar_cash_receipts
865: WHERE cash_receipt_id = p_cr_id
866: AND (
867: rec_version_number = p_rec_version_number
868: OR

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

881: END IF;
882: RAISE;
883: END nowaitlock_version_p;
884:
885: PROCEDURE update_version_number(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE) IS
886: BEGIN
887: IF PG_DEBUG in ('Y', 'C') THEN
888: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()+' );
889: END IF;

Line 891: update ar_cash_receipts

887: IF PG_DEBUG in ('Y', 'C') THEN
888: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()+' );
889: END IF;
890:
891: update ar_cash_receipts
892: set rec_version_number = nvl(rec_version_number,1)+1
893: where cash_receipt_id = p_cr_id;
894:
895: IF PG_DEBUG in ('Y', 'C') THEN

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

904: END update_version_number;
905:
906: /* End bug fix 3226723 */
907: PROCEDURE fetch_p(
908: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
909: BEGIN
910: IF PG_DEBUG in ('Y', 'C') THEN
911: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()+' );
912: END IF;

Line 916: FROM ar_cash_receipts

912: END IF;
913: --
914: SELECT *
915: INTO p_cr_rec
916: FROM ar_cash_receipts
917: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id;
918: --
919: IF PG_DEBUG in ('Y', 'C') THEN
920: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()-' );

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

930: END fetch_p;
931: --
932: --
933: PROCEDURE lock_fetch_p(
934: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
935: BEGIN
936: IF PG_DEBUG in ('Y', 'C') THEN
937: arp_util.debug( 'arp_cash_receipts_pkg.lock_fetch_p()+' );
938: END IF;

Line 942: FROM ar_cash_receipts

938: END IF;
939: --
940: SELECT *
941: INTO p_cr_rec
942: FROM ar_cash_receipts
943: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
944: FOR UPDATE OF status;
945: --
946: IF PG_DEBUG in ('Y', 'C') THEN

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

957: END lock_fetch_p;
958: --
959: --
960: PROCEDURE nowaitlock_fetch_p(
961: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
962: BEGIN
963: IF PG_DEBUG in ('Y', 'C') THEN
964: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_fetch_p()+' );
965: END IF;

Line 969: FROM ar_cash_receipts

965: END IF;
966: --
967: SELECT *
968: INTO p_cr_rec
969: FROM ar_cash_receipts
970: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
971: FOR UPDATE OF status NOWAIT;
972: --
973: IF PG_DEBUG in ('Y', 'C') THEN

Line 992: FROM ar_cash_receipts cr,

988: p_batch_id IN ar_batches.batch_id%TYPE ) IS
989: --
990: CURSOR lock_C IS
991: SELECT 'lock'
992: FROM ar_cash_receipts cr,
993: ar_cash_receipt_history crh
994: WHERE cr.cash_receipt_id = crh.cash_receipt_id
995: AND crh.batch_id = p_batch_id
996: FOR UPDATE OF cr.status;

Line 1029: FROM ar_cash_receipts cr,

1025: p_batch_id IN ar_batches.batch_id%TYPE ) IS
1026: --
1027: CURSOR lock_C IS
1028: SELECT 'lock'
1029: FROM ar_cash_receipts cr,
1030: ar_cash_receipt_history crh
1031: WHERE cr.cash_receipt_id = crh.cash_receipt_id
1032: AND crh.batch_id = p_batch_id
1033: FOR UPDATE OF cr.status NOWAIT;

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

1057: RAISE;
1058: END nowaitlock_f_batch_id;
1059: --
1060: --
1061: PROCEDURE lock_compare_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS
1062:
1063: l_new_cr_rec ar_cash_receipts%ROWTYPE;
1064: l_exchange_date DATE;
1065:

Line 1063: l_new_cr_rec ar_cash_receipts%ROWTYPE;

1059: --
1060: --
1061: PROCEDURE lock_compare_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS
1062:
1063: l_new_cr_rec ar_cash_receipts%ROWTYPE;
1064: l_exchange_date DATE;
1065:
1066: BEGIN
1067: IF PG_DEBUG in ('Y', 'C') THEN

Line 1080: FROM ar_cash_receipts cr

1076: END IF;
1077:
1078: SELECT exchange_date
1079: INTO l_exchange_date
1080: FROM ar_cash_receipts cr
1081: WHERE cr.cash_receipt_id = p_cr_rec.cash_receipt_id
1082: AND TO_CHAR(cr.exchange_date,'DD-MON-RR') =
1083: TO_CHAR(p_cr_rec.exchange_date,'DD-MON-RR');
1084:

Line 1096: ar_cash_receipts cr

1092: SELECT *
1093: INTO
1094: l_new_cr_rec
1095: FROM
1096: ar_cash_receipts cr
1097: WHERE
1098: cr.cash_receipt_id = p_cr_rec.cash_receipt_id
1099: AND
1100: NVL(cr.amount, AR_NUMBER_DUMMY) =