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 1342: PROCEDURE Reverse_Assignments_Adjustment ( p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE ,

1338: | |
1339: +==============================================================================*/
1340:
1341:
1342: PROCEDURE Reverse_Assignments_Adjustment ( p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE ,
1343: p_acceptance_flag IN VARCHAR2 )
1344: IS
1345:
1346: CURSOR assignment_cur IS

Line 1359: l_trh_rec ar_transaction_history%ROWTYPE ;

1355: l_msg_count NUMBER ;
1356: l_return_status VARCHAR2(1) ;
1357: l_ps_rec ar_payment_schedules%ROWTYPE ;
1358: l_trx_rec ra_customer_trx%ROWTYPE ;
1359: l_trh_rec ar_transaction_history%ROWTYPE ;
1360:
1361: BEGIN
1362:
1363: IF PG_DEBUG in ('Y', 'C') THEN

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

1589: | |
1590: +==============================================================================*/
1591:
1592:
1593: PROCEDURE Reverse_Receipt ( p_trh_rec IN ar_transaction_history%ROWTYPE ,
1594: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
1595: p_reversal_reason IN VARCHAR2 ,
1596: p_called_from IN VARCHAR2 )
1597: IS

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

1703: | |
1704: +==============================================================================*/
1705:
1706:
1707: PROCEDURE Unapply_Receipt ( p_trh_rec IN ar_transaction_history%ROWTYPE ,
1708: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1709: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
1710: p_called_from IN VARCHAR2 )
1711: IS

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

1967: | |
1968: +==============================================================================*/
1969:
1970:
1971: PROCEDURE Unapply_STD ( p_trh_rec IN ar_transaction_history%ROWTYPE ,
1972: p_called_from IN VARCHAR2 ,
1973: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE )
1974:
1975: IS

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

2079: | BR - Unpaid |
2080: | |
2081: +==============================================================================*/
2082:
2083: PROCEDURE Unpaid ( p_trh_rec IN OUT NOCOPY ar_transaction_history%ROWTYPE ,
2084: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2085: p_remittance_batch_id IN ra_customer_trx.remittance_batch_id%TYPE,
2086: p_unpaid_reason IN VARCHAR2 )
2087: IS

Line 2094: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE ;

2090: l_batch_rec ar_batches%ROWTYPE ;
2091: l_called_from VARCHAR2(30) := NULL ;
2092: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE ;
2093: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2094: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE ;
2095:
2096: BEGIN
2097:
2098: IF PG_DEBUG in ('Y', 'C') THEN

Line 2273: p_trh_rec IN ar_transaction_history%ROWTYPE )

2269:
2270:
2271: PROCEDURE Factore_Recourse ( p_batch_rec IN ar_batches%ROWTYPE ,
2272: p_ps_rec IN ar_payment_schedules%ROWTYPE ,
2273: p_trh_rec IN ar_transaction_history%ROWTYPE )
2274:
2275: IS
2276:
2277: l_cr_id NUMBER;

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

2618: | |
2619: +==============================================================================*/
2620:
2621:
2622: PROCEDURE Apply_Receipt (p_trh_rec IN ar_transaction_history%ROWTYPE ,
2623: p_ps_rec IN ar_payment_schedules%ROWTYPE ,
2624: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
2625: p_called_from IN VARCHAR2 )
2626:

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

2739: | |
2740: +==============================================================================*/
2741:
2742:
2743: PROCEDURE Link_Application_History (p_trh_rec IN ar_transaction_history%ROWTYPE)
2744:
2745: IS
2746:
2747: CURSOR last_application_cur IS