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.AR_BILLS_MAINTAIN_STATUS_PUB dependencies on AR_TRANSACTION_HISTORY

Line 237: PROCEDURE Find_Prev_posted_trh (p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE)

233: | 04-JUL-2000 Tien TRAN Created |
234: | |
235: +==============================================================================*/
236:
237: PROCEDURE Find_Prev_posted_trh (p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE)
238:
239: IS
240:
241: /*------------------------------------------------------------+

Line 247: FROM ar_transaction_history

243: +------------------------------------------------------------*/
244:
245: CURSOR Prev_trh_cur IS
246: SELECT *
247: FROM ar_transaction_history
248: WHERE (postable_flag = 'Y' OR nvl(event,'1') = 'MATURITY_DATE')
249: CONNECT BY PRIOR prv_trx_history_id = transaction_history_id
250: START WITH transaction_history_id = p_trh_rec.transaction_history_id
251: ORDER BY transaction_history_id desc;

Line 316: PROCEDURE Find_Last_relevant_trh (p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE)

312: | 04-JUL-2000 Tien TRAN Created |
313: | |
314: +==============================================================================*/
315:
316: PROCEDURE Find_Last_relevant_trh (p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE)
317:
318: IS
319:
320: /*--------------------------------------------------------------+

Line 326: FROM ar_transaction_history

322: +--------------------------------------------------------------*/
323:
324: CURSOR Prev_trh_cur IS
325: SELECT *
326: FROM ar_transaction_history
327: WHERE nvl(event,'A') NOT IN (C_MATURITY_DATE_UPDATED, C_FORMATTED)
328: CONNECT BY PRIOR prv_trx_history_id = transaction_history_id
329: START WITH transaction_history_id = p_trh_rec.transaction_history_id
330: ORDER BY transaction_history_id desc;

Line 387: FUNCTION Is_BR_Remit_Selected (p_trh_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN BOOLEAN

383: | Validates that the BR is selected for remittance |
384: | |
385: +==============================================================================*/
386:
387: FUNCTION Is_BR_Remit_Selected (p_trh_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN BOOLEAN
388: IS
389:
390: l_trh_rec ar_transaction_history%ROWTYPE;
391:

Line 390: l_trh_rec ar_transaction_history%ROWTYPE;

386:
387: FUNCTION Is_BR_Remit_Selected (p_trh_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN BOOLEAN
388: IS
389:
390: l_trh_rec ar_transaction_history%ROWTYPE;
391:
392: BEGIN
393:
394: IF PG_DEBUG in ('Y', 'C') THEN

Line 440: FUNCTION Is_BR_Risk_Eliminated (p_trh_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN BOOLEAN

436: | Validates that the BR has been risk eliminated |
437: | |
438: +==============================================================================*/
439:
440: FUNCTION Is_BR_Risk_Eliminated (p_trh_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN BOOLEAN
441: IS
442:
443: l_trh_rec ar_transaction_history%ROWTYPE;
444: l_prev_trh_rec ar_transaction_history%ROWTYPE;

Line 443: l_trh_rec ar_transaction_history%ROWTYPE;

439:
440: FUNCTION Is_BR_Risk_Eliminated (p_trh_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN BOOLEAN
441: IS
442:
443: l_trh_rec ar_transaction_history%ROWTYPE;
444: l_prev_trh_rec ar_transaction_history%ROWTYPE;
445:
446:
447: BEGIN

Line 444: l_prev_trh_rec ar_transaction_history%ROWTYPE;

440: FUNCTION Is_BR_Risk_Eliminated (p_trh_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN BOOLEAN
441: IS
442:
443: l_trh_rec ar_transaction_history%ROWTYPE;
444: l_prev_trh_rec ar_transaction_history%ROWTYPE;
445:
446:
447: BEGIN
448:

Line 505: l_trh_rec ar_transaction_history%ROWTYPE;

501:
502: FUNCTION Is_BR_Matured (p_maturity_date IN DATE) RETURN BOOLEAN
503: IS
504:
505: l_trh_rec ar_transaction_history%ROWTYPE;
506:
507: BEGIN
508:
509: IF PG_DEBUG in ('Y', 'C') THEN

Line 613: FUNCTION Is_BR_Paid_In_One_Time (p_trh_rec IN ar_transaction_history%ROWTYPE ,

609: | Validates that the BR was paid by one receipt or one endorsement adj |
610: | |
611: +==============================================================================*/
612:
613: FUNCTION Is_BR_Paid_In_One_Time (p_trh_rec IN ar_transaction_history%ROWTYPE ,
614: p_ps_rec IN ar_payment_schedules%ROWTYPE ) RETURN BOOLEAN
615: IS
616:
617: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

Line 620: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE;

616:
617: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
618: l_ra_id AR_RECEIVABLE_APPLICATIONS.receivable_application_id%TYPE;
619: l_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
620: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE;
621:
622: BEGIN
623:
624: IF PG_DEBUG in ('Y', 'C') THEN

Line 805: FROM AR_TRANSACTION_HISTORY

801: +-----------------------------------------------*/
802:
803: SELECT count(*)
804: INTO l_count
805: FROM AR_TRANSACTION_HISTORY
806: WHERE customer_trx_id = p_customer_trx_id
807: AND posting_control_id <> -3;
808:
809: IF (l_count > 0)

Line 984: l_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE;

980: p_delete_flag OUT NOCOPY VARCHAR2 )
981:
982: IS
983:
984: l_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE;
985: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
986: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
987: l_ps_id NUMBER;
988:

Line 1278: l_trh_rec ar_transaction_history%ROWTYPE;

1274: p_new_status OUT NOCOPY VARCHAR2 ,
1275: p_new_event OUT NOCOPY VARCHAR2 )
1276: IS
1277:
1278: l_trh_rec ar_transaction_history%ROWTYPE;
1279: l_prev_trh_rec ar_transaction_history%ROWTYPE;
1280:
1281: BEGIN
1282:

Line 1279: l_prev_trh_rec ar_transaction_history%ROWTYPE;

1275: p_new_event OUT NOCOPY VARCHAR2 )
1276: IS
1277:
1278: l_trh_rec ar_transaction_history%ROWTYPE;
1279: l_prev_trh_rec ar_transaction_history%ROWTYPE;
1280:
1281: BEGIN
1282:
1283: IF PG_DEBUG in ('Y', 'C') THEN

Line 1296: FROM ar_transaction_history

1292: +-----------------------------------------------*/
1293:
1294: SELECT transaction_history_id
1295: INTO l_trh_rec.transaction_history_id
1296: FROM ar_transaction_history
1297: WHERE customer_trx_id = p_trx_rec.customer_trx_id
1298: AND current_record_flag = 'Y';
1299:
1300: Find_Last_relevant_trh (l_trh_rec) ;