DBA Data[Home] [Help]

APPS.AR_BILLS_MAINTAIN_LIB_PVT dependencies on AR_TRANSACTION_HISTORY

Line 115: FROM AR_TRANSACTION_HISTORY

111:
112:
113: SELECT count(*)
114: INTO l_count
115: FROM AR_TRANSACTION_HISTORY
116: WHERE customer_trx_id = p_trx_rec.customer_trx_id
117: AND event = C_COMPLETED;
118:
119:

Line 534: PROCEDURE Default_Action_Dates ( p_trx_date IN OUT NOCOPY AR_TRANSACTION_HISTORY.trx_date%TYPE,

530: | |
531: +==============================================================================*/
532:
533:
534: PROCEDURE Default_Action_Dates ( p_trx_date IN OUT NOCOPY AR_TRANSACTION_HISTORY.trx_date%TYPE,
535: p_gl_date IN OUT NOCOPY AR_TRANSACTION_HISTORY.gl_date%TYPE )
536:
537: IS
538:

Line 535: p_gl_date IN OUT NOCOPY AR_TRANSACTION_HISTORY.gl_date%TYPE )

531: +==============================================================================*/
532:
533:
534: PROCEDURE Default_Action_Dates ( p_trx_date IN OUT NOCOPY AR_TRANSACTION_HISTORY.trx_date%TYPE,
535: p_gl_date IN OUT NOCOPY AR_TRANSACTION_HISTORY.gl_date%TYPE )
536:
537: IS
538:
539: l_return_status VARCHAR2(1);

Line 600: PROCEDURE Complete_Or_Accept (p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE)

596: +==============================================================================*/
597:
598:
599:
600: PROCEDURE Complete_Or_Accept (p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE)
601: IS
602:
603: l_adj_acctd_amount NUMBER;
604:

Line 613: l_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE ;

609: WHERE customer_trx_id = p_trh_rec.customer_trx_id;
610:
611: assignment_rec assignment_cur%ROWTYPE ;
612:
613: l_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE ;
614: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE ;
615: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE ;
616: l_new_adjust_id NUMBER ;
617: l_move_deferred_tax VARCHAR2(1) := 'N' ;

Line 792: PROCEDURE Create_Adjustment ( p_trh_rec IN ar_transaction_history%ROWTYPE ,

788: | |
789: +==============================================================================*/
790:
791:
792: PROCEDURE Create_Adjustment ( p_trh_rec IN ar_transaction_history%ROWTYPE ,
793: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
794: p_ps_rec IN ar_payment_schedules%ROWTYPE ,
795: p_amount IN NUMBER ,
796: p_receivables_trx_id IN ar_receivables_trx.receivables_trx_id%TYPE ,

Line 1191: p_trh_rec IN ar_transaction_history%ROWTYPE ,

1187: +==============================================================================*/
1188:
1189:
1190: PROCEDURE Reverse_Adjustment ( p_adj_id IN ar_adjustments.adjustment_id%TYPE ,
1191: p_trh_rec IN ar_transaction_history%ROWTYPE ,
1192: p_called_from IN VARCHAR2 )
1193: IS
1194:
1195:

Line 1304: PROCEDURE Reverse_Assignments_Adjustment ( p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE ,

1300: | |
1301: +==============================================================================*/
1302:
1303:
1304: PROCEDURE Reverse_Assignments_Adjustment ( p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE ,
1305: p_acceptance_flag IN VARCHAR2 )
1306: IS
1307:
1308: CURSOR assignment_cur IS

Line 1321: l_trh_rec ar_transaction_history%ROWTYPE ;

1317: l_msg_count NUMBER ;
1318: l_return_status VARCHAR2(1) ;
1319: l_ps_rec ar_payment_schedules%ROWTYPE ;
1320: l_trx_rec ra_customer_trx%ROWTYPE ;
1321: l_trh_rec ar_transaction_history%ROWTYPE ;
1322:
1323: BEGIN
1324:
1325: IF PG_DEBUG in ('Y', 'C') THEN

Line 1555: PROCEDURE Reverse_Receipt ( p_trh_rec IN ar_transaction_history%ROWTYPE ,

1551: | |
1552: +==============================================================================*/
1553:
1554:
1555: PROCEDURE Reverse_Receipt ( p_trh_rec IN ar_transaction_history%ROWTYPE ,
1556: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
1557: p_reversal_reason IN VARCHAR2 ,
1558: p_called_from IN VARCHAR2 )
1559: IS

Line 1669: PROCEDURE Unapply_Receipt ( p_trh_rec IN ar_transaction_history%ROWTYPE ,

1665: | |
1666: +==============================================================================*/
1667:
1668:
1669: PROCEDURE Unapply_Receipt ( p_trh_rec IN ar_transaction_history%ROWTYPE ,
1670: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1671: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
1672: p_called_from IN VARCHAR2 )
1673: IS

Line 1933: PROCEDURE Unapply_STD ( p_trh_rec IN ar_transaction_history%ROWTYPE ,

1929: | |
1930: +==============================================================================*/
1931:
1932:
1933: PROCEDURE Unapply_STD ( p_trh_rec IN ar_transaction_history%ROWTYPE ,
1934: p_called_from IN VARCHAR2 ,
1935: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE )
1936:
1937: IS

Line 2045: PROCEDURE Unpaid ( p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE ,

2041: | BR - Unpaid |
2042: | |
2043: +==============================================================================*/
2044:
2045: PROCEDURE Unpaid ( p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE ,
2046: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2047: p_remittance_batch_id IN ra_customer_trx.remittance_batch_id%TYPE,
2048: p_unpaid_reason IN VARCHAR2 )
2049: IS

Line 2056: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE ;

2052: l_batch_rec ar_batches%ROWTYPE ;
2053: l_called_from VARCHAR2(30) := NULL ;
2054: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE ;
2055: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2056: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE ;
2057:
2058: BEGIN
2059:
2060: IF PG_DEBUG in ('Y', 'C') THEN

Line 2235: p_trh_rec IN ar_transaction_history%ROWTYPE )

2231:
2232:
2233: PROCEDURE Factore_Recourse ( p_batch_rec IN ar_batches%ROWTYPE ,
2234: p_ps_rec IN ar_payment_schedules%ROWTYPE ,
2235: p_trh_rec IN ar_transaction_history%ROWTYPE )
2236:
2237: IS
2238:
2239: l_cr_id NUMBER;

Line 2584: PROCEDURE Apply_Receipt (p_trh_rec IN ar_transaction_history%ROWTYPE ,

2580: | |
2581: +==============================================================================*/
2582:
2583:
2584: PROCEDURE Apply_Receipt (p_trh_rec IN ar_transaction_history%ROWTYPE ,
2585: p_ps_rec IN ar_payment_schedules%ROWTYPE ,
2586: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
2587: p_called_from IN VARCHAR2 )
2588:

Line 2705: PROCEDURE Link_Application_History (p_trh_rec IN ar_transaction_history%ROWTYPE)

2701: | |
2702: +==============================================================================*/
2703:
2704:
2705: PROCEDURE Link_Application_History (p_trh_rec IN ar_transaction_history%ROWTYPE)
2706:
2707: IS
2708:
2709: CURSOR last_application_cur IS