APPS.AR_BILLS_CREATION_LIB_PVT dependencies on RA_CUSTOMER_TRX

Line 295: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,

291: +==============================================================================*/
292:
293:
294: PROCEDURE Get_Payment_Schedule_ID (
295: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
296: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE )
297: IS
298:
299: BEGIN

Line 344: PROCEDURE Check_Header_Mandatory_Data ( p_trx_rec IN ra_customer_trx%ROWTYPE)

340: +==============================================================================*/
341:
342:
343:
344: PROCEDURE Check_Header_Mandatory_Data ( p_trx_rec IN ra_customer_trx%ROWTYPE)
345: IS
346: BEGIN
347:
348: IF PG_DEBUG in ('Y', 'C') THEN

Line 525: PROCEDURE Default_Create_BR_Header ( p_trx_rec IN OUT NOCOPY ra_customer_trx%ROWTYPE ,

521: | |
522: +==============================================================================*/
523:
524:
525: PROCEDURE Default_Create_BR_Header ( p_trx_rec IN OUT NOCOPY ra_customer_trx%ROWTYPE ,
526: p_gl_date IN OUT NOCOPY DATE )
527:
528: IS
529: l_signed_flag VARCHAR2(1);

Line 694: 'RA_CUSTOMER_TRX' );

690: p_trx_rec.attribute12 ,
691: p_trx_rec.attribute13 ,
692: p_trx_rec.attribute14 ,
693: p_trx_rec.attribute15 ,
694: 'RA_CUSTOMER_TRX' );
695:
696:
697: END IF;
698:

Line 726: PROCEDURE Default_Update_BR_Header ( p_trx_rec IN OUT NOCOPY ra_customer_trx%ROWTYPE)

722: | |
723: +==============================================================================*/
724:
725:
726: PROCEDURE Default_Update_BR_Header ( p_trx_rec IN OUT NOCOPY ra_customer_trx%ROWTYPE)
727: IS
728:
729: BEGIN
730:

Line 741: FROM ra_customer_trx

737: +-----------------------------------------------*/
738:
739: SELECT batch_source_id
740: INTO p_trx_rec.batch_source_id
741: FROM ra_customer_trx
742: WHERE customer_trx_id = p_trx_rec.customer_trx_id;
743:
744:
745: IF PG_DEBUG in ('Y', 'C') THEN

Line 777: PROCEDURE Default_Create_BR_Assignment (p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE,

773: | |
774: +==============================================================================*/
775:
776:
777: PROCEDURE Default_Create_BR_Assignment (p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE,
778: p_ps_rec IN ar_payment_schedules%ROWTYPE )
779: IS
780:
781: l_amount_due_remaining NUMBER;

Line 797: FROM RA_CUSTOMER_TRX_LINES

793: +-----------------------------------------------*/
794:
795: SELECT count(*)
796: INTO l_count
797: FROM RA_CUSTOMER_TRX_LINES
798: WHERE br_ref_payment_schedule_id = p_ps_rec.payment_schedule_id
799: AND customer_trx_id = p_trl_rec.customer_trx_id;
800:
801: IF (l_count > 0)

Line 857: PROCEDURE DeAssign_BR (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE)

853: | |
854: +==============================================================================*/
855:
856:
857: PROCEDURE DeAssign_BR (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE)
858: IS
859:
860: CURSOR assignment_cur IS
861: SELECT customer_trx_line_id

Line 862: FROM ra_customer_trx_lines

858: IS
859:
860: CURSOR assignment_cur IS
861: SELECT customer_trx_line_id
862: FROM ra_customer_trx_lines
863: WHERE customer_trx_id = p_customer_trx_id;
864:
865: assignment_rec assignment_cur%ROWTYPE;
866: