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

Line 20: p_trh_rec IN ar_transaction_history%ROWTYPE,

16:
17: FUNCTION find_prev_accounted_id(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) RETURN NUMBER;
18:
19: PROCEDURE insert_BR_ps(
20: p_trh_rec IN ar_transaction_history%ROWTYPE,
21: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE);
22:
23: PROCEDURE calculate_BR_amounts(
24: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

Line 39: | Inserts a record into ar_transaction_history for bills receivable |

35: | PROCEDURE |
36: | insert_transaction_history |
37: | |
38: | DESCRIPTION |
39: | Inserts a record into ar_transaction_history for bills receivable |
40: | transaction. If this is not the first history record the previous |
41: | record flags are updated. If this is the completion record |
42: | payment schedule is created for the BR. MRC information is created |
43: | if MRC functionality is enabled |

Line 61: PROCEDURE insert_transaction_history(p_trh_rec IN OUT NOCOPY ar_transaction_history%rowtype,

57: | 28-MAR-2000 Jani Rautiainen Created |
58: | |
59: +===========================================================================*/
60:
61: PROCEDURE insert_transaction_history(p_trh_rec IN OUT NOCOPY ar_transaction_history%rowtype,
62: p_transaction_history_id OUT NOCOPY ar_transaction_history.transaction_history_id%type,
63: p_move_deferred_tax IN VARCHAR2 DEFAULT 'N') IS
64:
65: l_ae_doc_rec ae_doc_rec_type;

Line 62: p_transaction_history_id OUT NOCOPY ar_transaction_history.transaction_history_id%type,

58: | |
59: +===========================================================================*/
60:
61: PROCEDURE insert_transaction_history(p_trh_rec IN OUT NOCOPY ar_transaction_history%rowtype,
62: p_transaction_history_id OUT NOCOPY ar_transaction_history.transaction_history_id%type,
63: p_move_deferred_tax IN VARCHAR2 DEFAULT 'N') IS
64:
65: l_ae_doc_rec ae_doc_rec_type;
66: l_old_trh_rec ar_transaction_history%ROWTYPE;

Line 66: l_old_trh_rec ar_transaction_history%ROWTYPE;

62: p_transaction_history_id OUT NOCOPY ar_transaction_history.transaction_history_id%type,
63: p_move_deferred_tax IN VARCHAR2 DEFAULT 'N') IS
64:
65: l_ae_doc_rec ae_doc_rec_type;
66: l_old_trh_rec ar_transaction_history%ROWTYPE;
67: l_old_acctd_trh_rec ar_transaction_history%ROWTYPE;
68: l_prev_acctd_id ar_transaction_history.transaction_history_id%TYPE;
69: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
70: --Bug# 2750340

Line 67: l_old_acctd_trh_rec ar_transaction_history%ROWTYPE;

63: p_move_deferred_tax IN VARCHAR2 DEFAULT 'N') IS
64:
65: l_ae_doc_rec ae_doc_rec_type;
66: l_old_trh_rec ar_transaction_history%ROWTYPE;
67: l_old_acctd_trh_rec ar_transaction_history%ROWTYPE;
68: l_prev_acctd_id ar_transaction_history.transaction_history_id%TYPE;
69: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
70: --Bug# 2750340
71: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;

Line 68: l_prev_acctd_id ar_transaction_history.transaction_history_id%TYPE;

64:
65: l_ae_doc_rec ae_doc_rec_type;
66: l_old_trh_rec ar_transaction_history%ROWTYPE;
67: l_old_acctd_trh_rec ar_transaction_history%ROWTYPE;
68: l_prev_acctd_id ar_transaction_history.transaction_history_id%TYPE;
69: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
70: --Bug# 2750340
71: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
72:

Line 84: from ar_transaction_history_all trh

80:
81: cursor update_event (p_trx_id ra_customer_trx.customer_trx_id%TYPE)
82: is
83: select distinct trh.event_id
84: from ar_transaction_history_all trh
85: where trh.customer_trx_id = p_trx_id and
86: trh.event_id is not null and /* This condition is to make sure that null events are not selected for update. Null events get inserted in TRH when fields like maturity date are updated */
87: not exists
88: ( select 'Y'

Line 89: from ar_transaction_history_all trh_sub

85: where trh.customer_trx_id = p_trx_id and
86: trh.event_id is not null and /* This condition is to make sure that null events are not selected for update. Null events get inserted in TRH when fields like maturity date are updated */
87: not exists
88: ( select 'Y'
89: from ar_transaction_history_all trh_sub
90: where trh_sub.customer_trx_id = p_trx_id and
91: trh_sub.postable_flag ='Y' and
92: trh_sub.event_id = trh.event_id
93: );

Line 344: from ar_transaction_history_all trh

340: IF (p_trh_rec.status = 'PENDING_REMITTANCE' AND l_old_trh_rec.status = 'INCOMPLETE') THEN
341:
342: select count(distinct trh.event_id)
343: into l_event_count
344: from ar_transaction_history_all trh
345: where trh.customer_trx_id = p_trh_rec.customer_trx_id and
346: not exists
347: ( select 'Y'
348: from ar_transaction_history_all trh_sub

Line 348: from ar_transaction_history_all trh_sub

344: from ar_transaction_history_all trh
345: where trh.customer_trx_id = p_trh_rec.customer_trx_id and
346: not exists
347: ( select 'Y'
348: from ar_transaction_history_all trh_sub
349: where trh_sub.customer_trx_id = p_trh_rec.customer_trx_id and
350: trh_sub.postable_flag ='Y' and
351: trh_sub.event_id = trh.event_id
352: );

Line 414: | Updates a record into ar_transaction_history for bills receivable |

410: | PROCEDURE |
411: | update_transaction_history |
412: | |
413: | DESCRIPTION |
414: | Updates a record into ar_transaction_history for bills receivable |
415: | transaction. MRC information is updated if MRC functionality is enabled|
416: | |
417: | SCOPE - PUBLIC |
418: | |

Line 435: PROCEDURE update_transaction_history(p_trh_rec IN OUT NOCOPY ar_transaction_history%rowtype,

431: | 28-MAR-2000 Jani Rautiainen Created |
432: | |
433: +===========================================================================*/
434:
435: PROCEDURE update_transaction_history(p_trh_rec IN OUT NOCOPY ar_transaction_history%rowtype,
436: p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) IS
437:
438: CURSOR trh_customer_trx_cur IS
439: SELECT customer_trx_id

Line 436: p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) IS

432: | |
433: +===========================================================================*/
434:
435: PROCEDURE update_transaction_history(p_trh_rec IN OUT NOCOPY ar_transaction_history%rowtype,
436: p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) IS
437:
438: CURSOR trh_customer_trx_cur IS
439: SELECT customer_trx_id
440: FROM ar_transaction_history

Line 440: FROM ar_transaction_history

436: p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) IS
437:
438: CURSOR trh_customer_trx_cur IS
439: SELECT customer_trx_id
440: FROM ar_transaction_history
441: WHERE transaction_history_id = p_transaction_history_id;
442:
443: trh_customer_trx_rec trh_customer_trx_cur%ROWTYPE;
444: l_customer_trx_id ar_transaction_history.customer_trx_id%TYPE;

Line 444: l_customer_trx_id ar_transaction_history.customer_trx_id%TYPE;

440: FROM ar_transaction_history
441: WHERE transaction_history_id = p_transaction_history_id;
442:
443: trh_customer_trx_rec trh_customer_trx_cur%ROWTYPE;
444: l_customer_trx_id ar_transaction_history.customer_trx_id%TYPE;
445: BEGIN
446:
447: IF PG_DEBUG in ('Y', 'C') THEN
448: arp_util.debug( 'arp_proc_transaction_history.update_transaction_history()+');

Line 508: | Deletes row from ar_transaction_history for Bills Receivable |

504: | PROCEDURE |
505: | delete_transaction_history |
506: | |
507: | DESCRIPTION |
508: | Deletes row from ar_transaction_history for Bills Receivable |
509: | Transaction. MRC information is deleted if MRC functionality is enabled|
510: | |
511: | SCOPE - PUBLIC |
512: | |

Line 528: PROCEDURE delete_transaction_history(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) IS

524: | MODIFICATION HISTORY |
525: | 28-MAR-2000 Jani Rautiainen Created |
526: | |
527: +===========================================================================*/
528: PROCEDURE delete_transaction_history(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) IS
529:
530: BEGIN
531:
532: IF PG_DEBUG in ('Y', 'C') THEN

Line 606: PROCEDURE delete_transaction_hist_dist(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) IS

602: | not be modified to handle MRC ar |
603: | distributions deletes. Added call to |
604: | ar_mrc_engine for processing. |
605: +===========================================================================*/
606: PROCEDURE delete_transaction_hist_dist(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) IS
607:
608: /*----------------------------------------+
609: | Cursor for distribution records |
610: | related to the transaction history |

Line 687: from ar_transaction_history

683: | accounted transaction history |
684: +----------------------------------*/
685: CURSOR prev_acctd_trh_cur IS
686: select transaction_history_id
687: from ar_transaction_history
688: where current_accounted_flag = 'Y'
689: and customer_trx_id = p_customer_trx_id;
690:
691: prev_acctd_trh_rec prev_acctd_trh_cur%ROWTYPE;

Line 748: p_trh_rec IN ar_transaction_history%ROWTYPE,

744: | 25-MAY-2005 V Crisostomo SSA-R12 : add org_id |
745: | |
746: +===========================================================================*/
747: PROCEDURE insert_BR_ps(
748: p_trh_rec IN ar_transaction_history%ROWTYPE,
749: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE) IS
750:
751: l_trx_rec ra_customer_trx%ROWTYPE;
752: l_ps_rec ar_payment_schedules%ROWTYPE;

Line 961: FROM ar_transaction_history

957: FUNCTION previous_history_exists(p_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) RETURN BOOLEAN IS
958:
959: CURSOR previous_history_exists_cur IS
960: SELECT 'exists'
961: FROM ar_transaction_history
962: WHERE customer_trx_id = p_customer_trx_id
963: AND current_record_flag = 'Y';
964:
965: previous_history_exists_rec previous_history_exists_cur%ROWTYPE;

Line 1028: l_trh_rec ar_transaction_history%ROWTYPE;

1024: p_app_rec IN ar_receivable_applications%ROWTYPE,
1025: p_called_from IN VARCHAR2) IS
1026:
1027: l_new_ps_rec ar_payment_schedules%ROWTYPE;
1028: l_trh_rec ar_transaction_history%ROWTYPE;
1029: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1030:
1031: BEGIN
1032: IF PG_DEBUG in ('Y', 'C') THEN

Line 1029: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;

1025: p_called_from IN VARCHAR2) IS
1026:
1027: l_new_ps_rec ar_payment_schedules%ROWTYPE;
1028: l_trh_rec ar_transaction_history%ROWTYPE;
1029: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1030:
1031: BEGIN
1032: IF PG_DEBUG in ('Y', 'C') THEN
1033: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.create_trh_for_receipt_act()+');