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_TRANSACTION_HISTORY_PKG dependencies on AR_TRANSACTION_HISTORY

Line 46: PROCEDURE set_to_dummy( p_trh_rec OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS

42: | |
43: +===========================================================================*/
44: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
45:
46: PROCEDURE set_to_dummy( p_trh_rec OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS
47: BEGIN
48:
49: IF PG_DEBUG in ('Y', 'C') THEN
50: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.set_to_dummy()+' );

Line 118: PROCEDURE update_p( p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE,

114: | NOTES |
115: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
116: | |
117: +===========================================================================*/
118: PROCEDURE update_p( p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE,
119: p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
120: BEGIN
121: IF PG_DEBUG in ('Y', 'C') THEN
122: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.update_p()+' );

Line 119: p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS

115: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
116: | |
117: +===========================================================================*/
118: PROCEDURE update_p( p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE,
119: p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
120: BEGIN
121: IF PG_DEBUG in ('Y', 'C') THEN
122: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.update_p()+' );
123: END IF;

Line 125: UPDATE AR_TRANSACTION_HISTORY SET

121: IF PG_DEBUG in ('Y', 'C') THEN
122: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.update_p()+' );
123: END IF;
124:
125: UPDATE AR_TRANSACTION_HISTORY SET
126: customer_trx_id =
127: DECODE( p_trh_rec.customer_trx_id,
128: AR_NUMBER_DUMMY, customer_trx_id,
129: p_trh_rec.customer_trx_id ),

Line 296: PROCEDURE insert_p(p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE,

292: | NOTES |
293: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
294: | |
295: +===========================================================================*/
296: PROCEDURE insert_p(p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE,
297: p_trh_id OUT NOCOPY AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
298:
299: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
300: BEGIN

Line 297: p_trh_id OUT NOCOPY AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS

293: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
294: | |
295: +===========================================================================*/
296: PROCEDURE insert_p(p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE,
297: p_trh_id OUT NOCOPY AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
298:
299: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
300: BEGIN
301: IF PG_DEBUG in ('Y', 'C') THEN

Line 299: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;

295: +===========================================================================*/
296: PROCEDURE insert_p(p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE,
297: p_trh_id OUT NOCOPY AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
298:
299: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
300: BEGIN
301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.insert_p()+' );
303: END IF;

Line 305: SELECT AR_TRANSACTION_HISTORY_s.nextval

301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.insert_p()+' );
303: END IF;
304:
305: SELECT AR_TRANSACTION_HISTORY_s.nextval
306: INTO l_trh_id
307: FROM dual;
308:
309: INSERT INTO AR_TRANSACTION_HISTORY (

Line 309: INSERT INTO AR_TRANSACTION_HISTORY (

305: SELECT AR_TRANSACTION_HISTORY_s.nextval
306: INTO l_trh_id
307: FROM dual;
308:
309: INSERT INTO AR_TRANSACTION_HISTORY (
310: transaction_history_id,
311: customer_trx_id,
312: status,
313: event,

Line 430: PROCEDURE delete_p(p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS

426: | NOTES |
427: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
428: | |
429: +===========================================================================*/
430: PROCEDURE delete_p(p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
431: BEGIN
432: IF PG_DEBUG in ('Y', 'C') THEN
433: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()+' );
434: END IF;

Line 436: DELETE FROM AR_TRANSACTION_HISTORY

432: IF PG_DEBUG in ('Y', 'C') THEN
433: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()+' );
434: END IF;
435:
436: DELETE FROM AR_TRANSACTION_HISTORY
437: WHERE transaction_history_id = p_trh_id;
438:
439: IF PG_DEBUG in ('Y', 'C') THEN
440: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()-' );

Line 475: DELETE FROM AR_TRANSACTION_HISTORY

471: IF PG_DEBUG in ('Y', 'C') THEN
472: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()+' );
473: END IF;
474:
475: DELETE FROM AR_TRANSACTION_HISTORY
476: WHERE customer_trx_id = p_trx_id;
477:
478: IF PG_DEBUG in ('Y', 'C') THEN
479: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()-' );

Line 509: PROCEDURE lock_p(p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS

505: | NOTES |
506: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
507: | |
508: +===========================================================================*/
509: PROCEDURE lock_p(p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
510: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
511: BEGIN
512: IF PG_DEBUG in ('Y', 'C') THEN
513: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_p()+' );

Line 510: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;

506: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
507: | |
508: +===========================================================================*/
509: PROCEDURE lock_p(p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
510: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
511: BEGIN
512: IF PG_DEBUG in ('Y', 'C') THEN
513: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_p()+' );
514: END IF;

Line 518: FROM AR_TRANSACTION_HISTORY

514: END IF;
515:
516: SELECT transaction_history_id
517: INTO l_trh_id
518: FROM AR_TRANSACTION_HISTORY
519: WHERE transaction_history_id = p_trh_id
520: FOR UPDATE OF STATUS;
521:
522: IF PG_DEBUG in ('Y', 'C') THEN

Line 553: PROCEDURE nowaitlock_p( p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS

549: | NOTES |
550: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
551: | |
552: +===========================================================================*/
553: PROCEDURE nowaitlock_p( p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
554: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
555: BEGIN
556: IF PG_DEBUG in ('Y', 'C') THEN
557: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_p()+' );

Line 554: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;

550: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
551: | |
552: +===========================================================================*/
553: PROCEDURE nowaitlock_p( p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
554: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
555: BEGIN
556: IF PG_DEBUG in ('Y', 'C') THEN
557: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_p()+' );
558: END IF;

Line 562: FROM AR_TRANSACTION_HISTORY

558: END IF;
559:
560: SELECT transaction_history_id
561: INTO l_trh_id
562: FROM AR_TRANSACTION_HISTORY
563: WHERE transaction_history_id = p_trh_id
564: FOR UPDATE OF status NOWAIT;
565:
566: IF PG_DEBUG in ('Y', 'C') THEN

Line 596: PROCEDURE fetch_p( p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE,

592: | NOTES |
593: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
594: | |
595: +===========================================================================*/
596: PROCEDURE fetch_p( p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE,
597: p_trh_rec OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS
598: BEGIN
599:
600: IF PG_DEBUG in ('Y', 'C') THEN

Line 597: p_trh_rec OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS

593: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
594: | |
595: +===========================================================================*/
596: PROCEDURE fetch_p( p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE,
597: p_trh_rec OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS
598: BEGIN
599:
600: IF PG_DEBUG in ('Y', 'C') THEN
601: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_p()+' );

Line 606: FROM AR_TRANSACTION_HISTORY

602: END IF;
603:
604: SELECT *
605: INTO p_trh_rec
606: FROM AR_TRANSACTION_HISTORY
607: WHERE transaction_history_id = p_trh_id;
608: IF PG_DEBUG in ('Y', 'C') THEN
609: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_p()-' );
610: END IF;

Line 639: PROCEDURE fetch_f_trx_id( p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS

635: | NOTES |
636: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
637: | |
638: +===========================================================================*/
639: PROCEDURE fetch_f_trx_id( p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS
640: BEGIN
641: IF PG_DEBUG in ('Y', 'C') THEN
642: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_f_trx_id()+' );
643: END IF;

Line 647: FROM AR_TRANSACTION_HISTORY

643: END IF;
644:
645: SELECT *
646: INTO p_trh_rec
647: FROM AR_TRANSACTION_HISTORY
648: WHERE customer_trx_id = p_trh_rec.customer_trx_id AND
649: current_record_flag = 'Y';
650:
651: IF PG_DEBUG in ('Y', 'C') THEN

Line 683: PROCEDURE lock_fetch_p(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS

679: | NOTES |
680: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
681: | |
682: +===========================================================================*/
683: PROCEDURE lock_fetch_p(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS
684: BEGIN
685: IF PG_DEBUG in ('Y', 'C') THEN
686: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_p()+' );
687: END IF;

Line 691: FROM AR_TRANSACTION_HISTORY

687: END IF;
688:
689: SELECT *
690: INTO p_trh_rec
691: FROM AR_TRANSACTION_HISTORY
692: WHERE transaction_history_id = p_trh_rec.transaction_history_id
693: FOR UPDATE OF status;
694:
695: IF PG_DEBUG in ('Y', 'C') THEN

Line 727: PROCEDURE nowaitlock_fetch_p(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS

723: | NOTES |
724: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
725: | |
726: +===========================================================================*/
727: PROCEDURE nowaitlock_fetch_p(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS
728: BEGIN
729: IF PG_DEBUG in ('Y', 'C') THEN
730: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_p()+' );
731: END IF;

Line 735: FROM AR_TRANSACTION_HISTORY

731: END IF;
732:
733: SELECT *
734: INTO p_trh_rec
735: FROM AR_TRANSACTION_HISTORY
736: WHERE transaction_history_id = p_trh_rec.transaction_history_id
737: FOR UPDATE OF status NOWAIT;
738:
739: IF PG_DEBUG in ('Y', 'C') THEN

Line 775: FROM AR_TRANSACTION_HISTORY

771: PROCEDURE lock_f_trx_id(p_trx_id IN ra_customer_trx.customer_trx_id%TYPE ) IS
772:
773: CURSOR lock_C IS
774: SELECT 'lock'
775: FROM AR_TRANSACTION_HISTORY
776: WHERE customer_trx_id = p_trx_id
777: FOR UPDATE OF status;
778:
779: BEGIN

Line 826: FROM AR_TRANSACTION_HISTORY

822: PROCEDURE nowaitlock_f_trx_id(p_trx_id IN ra_customer_trx.customer_trx_id%TYPE ) IS
823:
824: CURSOR lock_C IS
825: SELECT 'lock'
826: FROM AR_TRANSACTION_HISTORY
827: WHERE customer_trx_id = p_trx_id
828: FOR UPDATE OF status NOWAIT;
829:
830: BEGIN

Line 874: PROCEDURE lock_fetch_f_trx_id(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS

870: | NOTES |
871: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
872: | |
873: +===========================================================================*/
874: PROCEDURE lock_fetch_f_trx_id(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS
875: BEGIN
876: IF PG_DEBUG in ('Y', 'C') THEN
877: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_f_trx_id()+' );
878: END IF;

Line 882: FROM AR_TRANSACTION_HISTORY

878: END IF;
879:
880: SELECT *
881: INTO p_trh_rec
882: FROM AR_TRANSACTION_HISTORY
883: WHERE customer_trx_id = p_trh_rec.customer_trx_id
884: AND current_record_flag = 'Y'
885: FOR UPDATE OF status;
886:

Line 918: PROCEDURE nowaitlock_fetch_f_trx_id(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS

914: | NOTES |
915: | MODIFICATION HISTORY - Created by Jani Rautiainen - 18-JAN-2000 |
916: | |
917: +===========================================================================*/
918: PROCEDURE nowaitlock_fetch_f_trx_id(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS
919: BEGIN
920: IF PG_DEBUG in ('Y', 'C') THEN
921: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_f_trx_id()+' );
922: END IF;

Line 926: FROM AR_TRANSACTION_HISTORY

922: END IF;
923:
924: SELECT *
925: INTO p_trh_rec
926: FROM AR_TRANSACTION_HISTORY
927: WHERE customer_trx_id = p_trh_rec.customer_trx_id
928: AND current_record_flag = 'Y'
929: FOR UPDATE OF status NOWAIT;
930: