APPS.AR_BILLS_CREATION_VAL_PVT dependencies on RA_CUSTOMER_TRX

Line 75: PROCEDURE Validate_Update_Maturity_Date (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

71: | Validates that Maturity Date can be updated |
72: | |
73: +==============================================================================*/
74:
75: PROCEDURE Validate_Update_Maturity_Date (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
76: p_term_due_date IN DATE )
77: IS
78:
79: l_trx_rec ra_customer_trx%ROWTYPE;

Line 79: l_trx_rec ra_customer_trx%ROWTYPE;

75: PROCEDURE Validate_Update_Maturity_Date (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
76: p_term_due_date IN DATE )
77: IS
78:
79: l_trx_rec ra_customer_trx%ROWTYPE;
80: l_ps_rec ar_payment_schedules%ROWTYPE;
81: l_trh_rec ar_transaction_history%ROWTYPE;
82:
83: BEGIN

Line 1010: FROM RA_CUSTOMER_TRX

1006: END IF;
1007:
1008: SELECT 'Y'
1009: INTO l_customer_trx_id_valid
1010: FROM RA_CUSTOMER_TRX
1011: WHERE customer_trx_id = p_customer_trx_id;
1012:
1013: IF PG_DEBUG in ('Y', 'C') THEN
1014: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_ID ()-');

Line 1058: FROM RA_CUSTOMER_TRX_LINES

1054: END IF;
1055:
1056: SELECT 'Y'
1057: INTO l_valid
1058: FROM RA_CUSTOMER_TRX_LINES
1059: WHERE customer_trx_line_id = p_customer_trx_line_id;
1060:
1061: IF PG_DEBUG in ('Y', 'C') THEN
1062: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_Line_ID ()-');

Line 1097: p_trx_rec IN ra_customer_trx%ROWTYPE ,

1093: +==============================================================================*/
1094:
1095:
1096: PROCEDURE Validate_Create_BR_Header (
1097: p_trx_rec IN ra_customer_trx%ROWTYPE ,
1098: p_gl_date IN DATE )
1099: IS
1100:
1101: BEGIN

Line 1189: p_trx_rec IN ra_customer_trx%ROWTYPE ,

1185: +==============================================================================*/
1186:
1187:
1188: PROCEDURE Validate_Update_BR_Header (
1189: p_trx_rec IN ra_customer_trx%ROWTYPE ,
1190: p_gl_date IN DATE )
1191:
1192: IS
1193:

Line 1281: PROCEDURE Validate_Assigned_Amount ( p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE ,

1277: | - Calculates the accounted assigned amount |
1278: | |
1279: +==============================================================================*/
1280:
1281: PROCEDURE Validate_Assigned_Amount ( p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE ,
1282: p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS
1283:
1284:
1285: l_exchange_rate NUMBER;

Line 1499: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

1495: PROCEDURE Validate_Assignment_Status ( p_customer_trx_id IN NUMBER,
1496: p_trx_number IN ar_payment_schedules.trx_number%TYPE) IS
1497:
1498: l_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE;
1499: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
1500:
1501: BEGIN
1502: IF PG_DEBUG in ('Y', 'C') THEN
1503: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Assignment_Status ()+');

Line 1557: PROCEDURE Validate_BR_Assignment (p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE ,

1553: | |
1554: +==============================================================================*/
1555:
1556:
1557: PROCEDURE Validate_BR_Assignment (p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE ,
1558: p_ps_rec IN ar_payment_schedules%ROWTYPE ,
1559: p_trx_rec IN ra_customer_trx%ROWTYPE ,
1560: p_BR_rec IN ra_customer_trx%ROWTYPE )
1561: IS

Line 1559: p_trx_rec IN ra_customer_trx%ROWTYPE ,

1555:
1556:
1557: PROCEDURE Validate_BR_Assignment (p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE ,
1558: p_ps_rec IN ar_payment_schedules%ROWTYPE ,
1559: p_trx_rec IN ra_customer_trx%ROWTYPE ,
1560: p_BR_rec IN ra_customer_trx%ROWTYPE )
1561: IS
1562:
1563: l_type VARCHAR2(20);

Line 1560: p_BR_rec IN ra_customer_trx%ROWTYPE )

1556:
1557: PROCEDURE Validate_BR_Assignment (p_trl_rec IN OUT NOCOPY ra_customer_trx_lines%ROWTYPE ,
1558: p_ps_rec IN ar_payment_schedules%ROWTYPE ,
1559: p_trx_rec IN ra_customer_trx%ROWTYPE ,
1560: p_BR_rec IN ra_customer_trx%ROWTYPE )
1561: IS
1562:
1563: l_type VARCHAR2(20);
1564:

Line 1692: 'RA_CUSTOMER_TRX_LINES' );

1688: p_trl_rec.attribute12 ,
1689: p_trl_rec.attribute13 ,
1690: p_trl_rec.attribute14 ,
1691: p_trl_rec.attribute15 ,
1692: 'RA_CUSTOMER_TRX_LINES' );
1693:
1694: END IF;
1695:
1696: