APPS.AR_TRANSACTION_GRP dependencies on RA_CUST_TRX_TYPES

Line 72: PROCEDURE fetch_trx_type( p_trx_type_rec OUT NOCOPY ra_cust_trx_types%rowtype,

68: | MODIFICATION HISTORY |
69: | |
70: +===========================================================================*/
71:
72: PROCEDURE fetch_trx_type( p_trx_type_rec OUT NOCOPY ra_cust_trx_types%rowtype,
73: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
74: x_return_status OUT NOCOPY VARCHAR2
75: )
76: IS

Line 89: FROM ra_cust_trx_types trxtype, ra_customer_trx header

85: p_trx_type_rec.name,
86: p_trx_type_rec.allow_overapplication_flag,
87: p_trx_type_rec.natural_application_only_flag,
88: p_trx_type_rec.creation_sign
89: FROM ra_cust_trx_types trxtype, ra_customer_trx header
90: WHERE header.customer_trx_id = p_customer_trx_id
91: AND trxtype.cust_trx_type_id = header.cust_trx_type_id;
92:
93: EXCEPTION

Line 160: l_trx_type_rec ra_cust_trx_types%rowtype;

156: l_api_name CONSTANT VARCHAR2(30) := 'COMPLETE_TRANSACTION';
157: l_api_version CONSTANT NUMBER := 1.0;
158:
159: l_trx_rec ra_customer_trx%rowtype;
160: l_trx_type_rec ra_cust_trx_types%rowtype;
161: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
162: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
163: l_line_number NUMBER;
164: l_gl_tax_code VARCHAR2(50);

Line 476: l_trx_type_rec ra_cust_trx_types%rowtype;

472: l_api_name CONSTANT VARCHAR2(30) := 'INCOMPLETE_TRANSACTION';
473: l_api_version CONSTANT NUMBER := 1.0;
474:
475: l_trx_rec ra_customer_trx%rowtype;
476: l_trx_type_rec ra_cust_trx_types%rowtype;
477: l_posted_flag VARCHAR2(1);
478: l_activity_flag VARCHAR2(1);
479:
480: l_init_msg_list VARCHAR2(1);