APPS.AR_BILLS_CREATION_PUB dependencies on RA_CUSTOMER_TRX

Line 114: l_trx_rec ra_customer_trx%ROWTYPE;

110: IS
111: l_api_name CONSTANT VARCHAR2(20) := 'Create_BR_Header';
112: l_api_version CONSTANT NUMBER := 1.0;
113:
114: l_trx_rec ra_customer_trx%ROWTYPE;
115: l_trh_rec ar_transaction_history%ROWTYPE;
116:
117: l_gl_date DATE ;
118:

Line 397: l_trx_rec ra_customer_trx%ROWTYPE;

393: IS
394: l_api_name CONSTANT VARCHAR2(20) := 'Update_BR_Header';
395: l_api_version CONSTANT NUMBER := 1.0;
396:
397: l_trx_rec ra_customer_trx%ROWTYPE;
398: l_trh_rec ar_transaction_history%ROWTYPE;
399: l_ps_rec ar_payment_schedules%ROWTYPE;
400:
401: l_gl_date DATE ;

Line 694: l_trx_rec ra_customer_trx%ROWTYPE;

690: l_restate_flag VARCHAR2(1);
691: l_exchange_flag VARCHAR2(1);
692: l_delete_flag VARCHAR2(1);
693:
694: l_trx_rec ra_customer_trx%ROWTYPE;
695:
696: BEGIN
697:
698: IF PG_DEBUG in ('Y', 'C') THEN

Line 932: l_trx_rec ra_customer_trx%ROWTYPE;

928: IS
929: l_api_name CONSTANT VARCHAR2(20) := 'Lock_BR_Header';
930: l_api_version CONSTANT NUMBER := 1.0;
931:
932: l_trx_rec ra_customer_trx%ROWTYPE;
933:
934:
935:
936: BEGIN

Line 1144: l_trl_rec ra_customer_trx_lines%ROWTYPE ;

1140:
1141: IS
1142: l_api_name CONSTANT VARCHAR2(20) := 'Create_BR_Assignment';
1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_trl_rec ra_customer_trx_lines%ROWTYPE ;
1145: l_ps_rec ar_payment_schedules%ROWTYPE ;
1146: l_trx_rec ra_customer_trx%ROWTYPE ;
1147: l_BR_rec ra_customer_trx%ROWTYPE ;
1148: l_customer_trx_line_id NUMBER ;

Line 1146: l_trx_rec ra_customer_trx%ROWTYPE ;

1142: l_api_name CONSTANT VARCHAR2(20) := 'Create_BR_Assignment';
1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_trl_rec ra_customer_trx_lines%ROWTYPE ;
1145: l_ps_rec ar_payment_schedules%ROWTYPE ;
1146: l_trx_rec ra_customer_trx%ROWTYPE ;
1147: l_BR_rec ra_customer_trx%ROWTYPE ;
1148: l_customer_trx_line_id NUMBER ;
1149: l_trh_rec ar_transaction_history%ROWTYPE ;
1150:

Line 1147: l_BR_rec ra_customer_trx%ROWTYPE ;

1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_trl_rec ra_customer_trx_lines%ROWTYPE ;
1145: l_ps_rec ar_payment_schedules%ROWTYPE ;
1146: l_trx_rec ra_customer_trx%ROWTYPE ;
1147: l_BR_rec ra_customer_trx%ROWTYPE ;
1148: l_customer_trx_line_id NUMBER ;
1149: l_trh_rec ar_transaction_history%ROWTYPE ;
1150:
1151: BEGIN

Line 1443: l_trl_rec ra_customer_trx_lines%ROWTYPE;

1439: IS
1440: l_api_name CONSTANT VARCHAR2(20) := 'Update_BR_Assignment';
1441: l_api_version CONSTANT NUMBER := 1.0;
1442:
1443: l_trl_rec ra_customer_trx_lines%ROWTYPE;
1444: l_ps_rec ar_payment_schedules%ROWTYPE;
1445:
1446: l_trx_rec ra_customer_trx%ROWTYPE;
1447: l_BR_rec ra_customer_trx%ROWTYPE;

Line 1446: l_trx_rec ra_customer_trx%ROWTYPE;

1442:
1443: l_trl_rec ra_customer_trx_lines%ROWTYPE;
1444: l_ps_rec ar_payment_schedules%ROWTYPE;
1445:
1446: l_trx_rec ra_customer_trx%ROWTYPE;
1447: l_BR_rec ra_customer_trx%ROWTYPE;
1448:
1449: BEGIN
1450:

Line 1447: l_BR_rec ra_customer_trx%ROWTYPE;

1443: l_trl_rec ra_customer_trx_lines%ROWTYPE;
1444: l_ps_rec ar_payment_schedules%ROWTYPE;
1445:
1446: l_trx_rec ra_customer_trx%ROWTYPE;
1447: l_BR_rec ra_customer_trx%ROWTYPE;
1448:
1449: BEGIN
1450:
1451: IF PG_DEBUG in ('Y', 'C') THEN

Line 1652: l_trl_rec ra_customer_trx_lines%ROWTYPE;

1648:
1649: IS
1650: l_api_name CONSTANT VARCHAR2(20) := 'Delete_BR_Assignment';
1651: l_api_version CONSTANT NUMBER := 1.0;
1652: l_trl_rec ra_customer_trx_lines%ROWTYPE;
1653: l_BR_rec ra_customer_trx%ROWTYPE;
1654:
1655:
1656: BEGIN

Line 1653: l_BR_rec ra_customer_trx%ROWTYPE;

1649: IS
1650: l_api_name CONSTANT VARCHAR2(20) := 'Delete_BR_Assignment';
1651: l_api_version CONSTANT NUMBER := 1.0;
1652: l_trl_rec ra_customer_trx_lines%ROWTYPE;
1653: l_BR_rec ra_customer_trx%ROWTYPE;
1654:
1655:
1656: BEGIN
1657:

Line 1845: l_trl_rec ra_customer_trx_lines%ROWTYPE;

1841: IS
1842: l_api_name CONSTANT VARCHAR2(20) := 'Lock_BR_Assignment';
1843: l_api_version CONSTANT NUMBER := 1.0;
1844:
1845: l_trl_rec ra_customer_trx_lines%ROWTYPE;
1846:
1847:
1848: BEGIN
1849: