APPS.AR_BILLS_CREATION_VAL_PVT dependencies on RA_CUSTOMER_TRX

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

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

Line 78: l_trx_rec ra_customer_trx%ROWTYPE;

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

Line 1008: FROM RA_CUSTOMER_TRX

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

Line 1056: FROM RA_CUSTOMER_TRX_LINES

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

Line 1095: p_trx_rec IN ra_customer_trx%ROWTYPE ,

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

Line 1187: p_trx_rec IN ra_customer_trx%ROWTYPE ,

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

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

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

Line 1497: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;

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

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

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

Line 1557: p_trx_rec IN ra_customer_trx%ROWTYPE ,

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

Line 1558: p_BR_rec IN ra_customer_trx%ROWTYPE )

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

Line 1690: 'RA_CUSTOMER_TRX_LINES' );

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