DBA Data[Home] [Help]

APPS.AR_BILLS_MAINTAIN_VAL_PVT dependencies on RA_CUSTOMER_TRX

Line 108: FROM ra_customer_trx trx

104: END IF;
105:
106: SELECT count(*)
107: INTO l_count
108: FROM ra_customer_trx trx
109: WHERE customer_trx_id=p_customer_trx_id
110: AND trx.bill_to_customer_id IN
111: (
112: SELECT arel.related_cust_account_id

Line 174: FROM ra_customer_trx

170: END IF;
171:
172: SELECT bill_to_customer_id
173: INTO l_bill_to_customer_id
174: FROM ra_customer_trx
175: WHERE customer_trx_id=p_customer_trx_id;
176:
177: IF (l_bill_to_customer_id <> p_drawee_id)
178: THEN

Line 292: PROCEDURE Validate_Assignment (p_trx_rec IN OUT NOCOPY ra_customer_trx%ROWTYPE) IS

288: | The total of the assignments match the BR Total Amount |
289: | |
290: +==============================================================================*/
291:
292: PROCEDURE Validate_Assignment (p_trx_rec IN OUT NOCOPY ra_customer_trx%ROWTYPE) IS
293:
294: /*-------------------------------------------+
295: | Cursor to fetch the assignments of the BR |
296: +-------------------------------------------*/

Line 300: FROM ra_customer_trx_lines

296: +-------------------------------------------*/
297:
298: CURSOR assignment_cur IS
299: SELECT br_ref_customer_trx_id, extended_amount, br_ref_payment_schedule_id
300: FROM ra_customer_trx_lines
301: WHERE customer_trx_id = p_trx_rec.customer_trx_id;
302:
303: assignment_rec assignment_cur%ROWTYPE;
304:

Line 310: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

306: l_functional_currency VARCHAR2(15);
307: l_reference_rate NUMBER;
308: l_total NUMBER;
309: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
310: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
311:
312: BEGIN
313:
314: IF PG_DEBUG in ('Y', 'C') THEN

Line 542: PROCEDURE Validate_Assignment_Exist (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE)

538: | Validates that the exchanged transaction have not been purged |
539: | |
540: +==============================================================================*/
541:
542: PROCEDURE Validate_Assignment_Exist (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE)
543: IS
544:
545: /*-------------------------------------------+
546: | Cursor to fetch the assignments of the BR |

Line 551: FROM ra_customer_trx_lines

547: +-------------------------------------------*/
548:
549: CURSOR assignment_cur IS
550: SELECT br_ref_customer_trx_id
551: FROM ra_customer_trx_lines
552: WHERE customer_trx_id = p_customer_trx_id;
553:
554: assignment_rec assignment_cur%ROWTYPE;
555:

Line 567: FROM ra_customer_trx

563:
564: FOR assignment_rec IN assignment_cur LOOP
565: SELECT 'Y'
566: INTO l_assignment_exists
567: FROM ra_customer_trx
568: WHERE customer_trx_id = assignment_rec.br_ref_customer_trx_id;
569:
570: END LOOP;
571:

Line 829: p_trx_rec IN OUT NOCOPY ra_customer_trx%ROWTYPE ,

825: +==============================================================================*/
826:
827:
828: PROCEDURE Validate_Complete_BR (
829: p_trx_rec IN OUT NOCOPY ra_customer_trx%ROWTYPE ,
830: p_gl_date IN DATE )
831: IS
832:
833: BEGIN

Line 874: p_trx_rec IN ra_customer_trx%ROWTYPE,

870: +==============================================================================*/
871:
872:
873: PROCEDURE Validate_Accept_BR (
874: p_trx_rec IN ra_customer_trx%ROWTYPE,
875: p_trh_rec IN ar_transaction_history%ROWTYPE)
876: IS
877:
878: BEGIN

Line 944: PROCEDURE Validate_Cancel_BR (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE)

940: | |
941: +==============================================================================*/
942:
943:
944: PROCEDURE Validate_Cancel_BR (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE)
945: IS
946:
947: BEGIN
948:

Line 991: l_trx_rec ra_customer_trx%ROWTYPE;

987: IS
988:
989: l_batch_rec AR_BATCHES%ROWTYPE;
990: l_amount_applied NUMBER;
991: l_trx_rec ra_customer_trx%ROWTYPE;
992:
993: BEGIN
994:
995: IF PG_DEBUG in ('Y', 'C') THEN

Line 1127: p_trx_number IN ra_customer_trx.trx_number%TYPE )

1123:
1124:
1125: PROCEDURE Validate_Remittance_Dates ( p_batch_rec IN ar_batches%ROWTYPE ,
1126: p_trh_rec IN ar_transaction_history%ROWTYPE ,
1127: p_trx_number IN ra_customer_trx.trx_number%TYPE )
1128:
1129: IS
1130:
1131: BEGIN