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

Line 16: gl_date ar_transaction_history.gl_date%TYPE,

12: reserved_type ar_payment_schedules.reserved_type%TYPE,
13: reserved_value ar_payment_schedules.reserved_value%TYPE,
14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,
16: gl_date ar_transaction_history.gl_date%TYPE,
17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,
18: prv_trx_history_id ar_transaction_history.prv_trx_history_id%TYPE,
19: status ar_transaction_history.status%TYPE,
20: event ar_transaction_history.event%TYPE,

Line 17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,

13: reserved_value ar_payment_schedules.reserved_value%TYPE,
14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,
16: gl_date ar_transaction_history.gl_date%TYPE,
17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,
18: prv_trx_history_id ar_transaction_history.prv_trx_history_id%TYPE,
19: status ar_transaction_history.status%TYPE,
20: event ar_transaction_history.event%TYPE,
21: org_id ar_transaction_history.org_id%TYPE);

Line 18: prv_trx_history_id ar_transaction_history.prv_trx_history_id%TYPE,

14: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,
16: gl_date ar_transaction_history.gl_date%TYPE,
17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,
18: prv_trx_history_id ar_transaction_history.prv_trx_history_id%TYPE,
19: status ar_transaction_history.status%TYPE,
20: event ar_transaction_history.event%TYPE,
21: org_id ar_transaction_history.org_id%TYPE);
22:

Line 19: status ar_transaction_history.status%TYPE,

15: tax_remaining ar_payment_schedules.tax_remaining%TYPE,
16: gl_date ar_transaction_history.gl_date%TYPE,
17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,
18: prv_trx_history_id ar_transaction_history.prv_trx_history_id%TYPE,
19: status ar_transaction_history.status%TYPE,
20: event ar_transaction_history.event%TYPE,
21: org_id ar_transaction_history.org_id%TYPE);
22:
23: /*-----------------------------------------------------------------+

Line 20: event ar_transaction_history.event%TYPE,

16: gl_date ar_transaction_history.gl_date%TYPE,
17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,
18: prv_trx_history_id ar_transaction_history.prv_trx_history_id%TYPE,
19: status ar_transaction_history.status%TYPE,
20: event ar_transaction_history.event%TYPE,
21: org_id ar_transaction_history.org_id%TYPE);
22:
23: /*-----------------------------------------------------------------+
24: | Package global variables (private) to be used in sub procedures |

Line 21: org_id ar_transaction_history.org_id%TYPE);

17: transaction_history_id ar_transaction_history.transaction_history_id%TYPE,
18: prv_trx_history_id ar_transaction_history.prv_trx_history_id%TYPE,
19: status ar_transaction_history.status%TYPE,
20: event ar_transaction_history.event%TYPE,
21: org_id ar_transaction_history.org_id%TYPE);
22:
23: /*-----------------------------------------------------------------+
24: | Package global variables (private) to be used in sub procedures |
25: +-----------------------------------------------------------------*/

Line 60: PROCEDURE prev_posted_trh(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,

56:
57: procedure create_maturity_date_event(p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
58: p_event_date DATE);
59:
60: PROCEDURE prev_posted_trh(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
61: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE);
62:
63: PROCEDURE fetch_remittance_setup_data(p_status IN ar_transaction_history.status%TYPE,
64: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL);

Line 61: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE);

57: procedure create_maturity_date_event(p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
58: p_event_date DATE);
59:
60: PROCEDURE prev_posted_trh(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
61: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE);
62:
63: PROCEDURE fetch_remittance_setup_data(p_status IN ar_transaction_history.status%TYPE,
64: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL);
65:

Line 63: PROCEDURE fetch_remittance_setup_data(p_status IN ar_transaction_history.status%TYPE,

59:
60: PROCEDURE prev_posted_trh(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
61: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE);
62:
63: PROCEDURE fetch_remittance_setup_data(p_status IN ar_transaction_history.status%TYPE,
64: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL);
65:
66: PROCEDURE fetch_endorsement_setup_data(p_receivables_trx_id IN ar_receivables_trx.receivables_trx_id%TYPE);
67:

Line 139: from ar_transaction_history trh, ar_payment_schedules ps

135: trh.prv_trx_history_id,
136: trh.status,
137: trh.event,
138: ps.org_id
139: from ar_transaction_history trh, ar_payment_schedules ps
140: where
141: /*-----------------------------------------------------+
142: | Restrict the transaction type if given as parameter |
143: +-----------------------------------------------------*/

Line 469: prev_trh_rec ar_transaction_history%ROWTYPE;

465: +===========================================================================*/
466: PROCEDURE process_factored IS
467:
468: l_move_deferred_tax VARCHAR2(1) := 'Y';
469: prev_trh_rec ar_transaction_history%ROWTYPE;
470: l_cutoff_date DATE;
471: l_remitted_late BOOLEAN := FALSE;
472: l_event_date DATE;
473:

Line 642: prev_trh_rec ar_transaction_history%ROWTYPE;

638:
639: last_adjustment_rec ar_adjustments%ROWTYPE;
640:
641: l_move_deferred_tax VARCHAR2(1) := 'Y';
642: prev_trh_rec ar_transaction_history%ROWTYPE;
643:
644: BEGIN
645:
646: write_debug_and_log( 'arp_br_housekeeper_pkg.process_endorsed()+' );

Line 872: l_trh_rec ar_transaction_history%ROWTYPE;

868: l_cr_id NUMBER;
869: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
870: l_receipt_date DATE;
871: BR_rec BR_cur%ROWTYPE;
872: l_trh_rec ar_transaction_history%ROWTYPE;
873: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
874: l_default_gl_date DATE;
875: l_org_return_status VARCHAR2(1);
876: l_org_id NUMBER;

Line 873: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;

869: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
870: l_receipt_date DATE;
871: BR_rec BR_cur%ROWTYPE;
872: l_trh_rec ar_transaction_history%ROWTYPE;
873: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
874: l_default_gl_date DATE;
875: l_org_return_status VARCHAR2(1);
876: l_org_id NUMBER;
877:

Line 1099: l_trh_rec ar_transaction_history%ROWTYPE;

1095: l_return_status VARCHAR2(1);
1096: l_msg_count NUMBER;
1097: l_msg_data VARCHAR2(2000);
1098:
1099: l_trh_rec ar_transaction_history%ROWTYPE;
1100: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1101: l_default_gl_date DATE;
1102: l_event_date DATE;
1103:

Line 1100: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;

1096: l_msg_count NUMBER;
1097: l_msg_data VARCHAR2(2000);
1098:
1099: l_trh_rec ar_transaction_history%ROWTYPE;
1100: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1101: l_default_gl_date DATE;
1102: l_event_date DATE;
1103:
1104: l_org_return_status VARCHAR2(1);

Line 1313: l_trh_rec ar_transaction_history%ROWTYPE;

1309: l_msg_data VARCHAR2(2000);
1310: l_apply_date DATE;
1311:
1312: last_std_application_rec last_std_application_cur%ROWTYPE;
1313: l_trh_rec ar_transaction_history%ROWTYPE;
1314: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1315: l_default_gl_date DATE;
1316: l_event_date DATE;
1317:

Line 1314: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;

1310: l_apply_date DATE;
1311:
1312: last_std_application_rec last_std_application_cur%ROWTYPE;
1313: l_trh_rec ar_transaction_history%ROWTYPE;
1314: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1315: l_default_gl_date DATE;
1316: l_event_date DATE;
1317:
1318: l_org_return_status VARCHAR2(1);

Line 1577: l_trh_rec ar_transaction_history%ROWTYPE;

1573: +===========================================================================*/
1574: PROCEDURE create_maturity_date_event(p_move_deferred_tax VARCHAR2 DEFAULT 'Y',
1575: p_event_date DATE) IS
1576:
1577: l_trh_rec ar_transaction_history%ROWTYPE;
1578: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1579: l_event_date DATE;
1580: BEGIN
1581: write_debug_and_log( 'arp_br_housekeeper_pkg.create_maturity_date_event()+' );

Line 1578: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;

1574: PROCEDURE create_maturity_date_event(p_move_deferred_tax VARCHAR2 DEFAULT 'Y',
1575: p_event_date DATE) IS
1576:
1577: l_trh_rec ar_transaction_history%ROWTYPE;
1578: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1579: l_event_date DATE;
1580: BEGIN
1581: write_debug_and_log( 'arp_br_housekeeper_pkg.create_maturity_date_event()+' );
1582:

Line 1681: PROCEDURE prev_posted_trh(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,

1677: | MODIFICATION HISTORY |
1678: | 30-JUN-2000 Jani Rautiainen Created |
1679: | |
1680: +===========================================================================*/
1681: PROCEDURE prev_posted_trh(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
1682: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE) IS
1683:
1684: /*------------------------------------------------------------+
1685: | Cursor to fetch previous posted transaction history record |

Line 1682: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE) IS

1678: | 30-JUN-2000 Jani Rautiainen Created |
1679: | |
1680: +===========================================================================*/
1681: PROCEDURE prev_posted_trh(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
1682: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE) IS
1683:
1684: /*------------------------------------------------------------+
1685: | Cursor to fetch previous posted transaction history record |
1686: +------------------------------------------------------------*/

Line 1689: from ar_transaction_history th

1685: | Cursor to fetch previous posted transaction history record |
1686: +------------------------------------------------------------*/
1687: CURSOR prev_trh_cur IS
1688: select th.*
1689: from ar_transaction_history th
1690: where (postable_flag = 'Y' or event = 'MATURITY_DATE')
1691: connect by prior prv_trx_history_id = transaction_history_id
1692: start with transaction_history_id = p_transaction_history_id
1693: order by transaction_history_id desc;

Line 1745: PROCEDURE fetch_remittance_setup_data(p_status IN ar_transaction_history.status%TYPE,

1741: | MODIFICATION HISTORY |
1742: | 30-JUN-2000 Jani Rautiainen Created |
1743: | |
1744: +===========================================================================*/
1745: PROCEDURE fetch_remittance_setup_data(p_status IN ar_transaction_history.status%TYPE,
1746: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL) IS
1747: /*------------------------------------------------+
1748: | Fetch remittance data from BR remittance batch |
1749: +------------------------------------------------*/