APPS.ARP_TRX_DEFAULTS_2 dependencies on RA_CUSTOMER_TRX

Line 57: ra_customer_trx.trx_date%type,

53: ra_batch_sources.batch_source_id%type,
54: p_ctt_class IN
55: ra_cust_trx_types.type%type,
56: p_trx_date IN
57: ra_customer_trx.trx_date%type,
58: p_trx_number IN
59: ra_customer_trx.trx_number%type,
60: p_default_batch_source_id OUT NOCOPY
61: ra_batch_sources.batch_source_id%type,

Line 59: ra_customer_trx.trx_number%type,

55: ra_cust_trx_types.type%type,
56: p_trx_date IN
57: ra_customer_trx.trx_date%type,
58: p_trx_number IN
59: ra_customer_trx.trx_number%type,
60: p_default_batch_source_id OUT NOCOPY
61: ra_batch_sources.batch_source_id%type,
62: p_default_batch_source_name OUT NOCOPY
63: ra_batch_sources.name%type,

Line 209: ra_customer_trx.trx_date%type,

205: PROCEDURE get_type_defaults(
206: p_cust_trx_type_id IN
207: ra_cust_trx_types.cust_trx_type_id%type,
208: p_trx_date IN
209: ra_customer_trx.trx_date%type,
210: p_ctt_class IN
211: ra_cust_trx_types.type%type,
212: p_row_id IN varchar2,
213: p_invoicing_rule_id IN ra_rules.rule_id%type,

Line 216: ra_customer_trx.complete_flag%type,

212: p_row_id IN varchar2,
213: p_invoicing_rule_id IN ra_rules.rule_id%type,
214: p_rev_recog_run_flag IN varchar2,
215: p_complete_flag IN
216: ra_customer_trx.complete_flag%type,
217: p_open_receivables_flag IN
218: ra_cust_trx_types.accounting_affect_flag%type,
219: p_customer_trx_id IN
220: ra_customer_trx.customer_trx_id%type,

Line 220: ra_customer_trx.customer_trx_id%type,

216: ra_customer_trx.complete_flag%type,
217: p_open_receivables_flag IN
218: ra_cust_trx_types.accounting_affect_flag%type,
219: p_customer_trx_id IN
220: ra_customer_trx.customer_trx_id%type,
221: p_default_cust_trx_type_id OUT NOCOPY
222: ra_cust_trx_types.cust_trx_type_id%type,
223: p_default_type_name OUT NOCOPY
224: ra_cust_trx_types.name%type,

Line 255: ra_customer_trx.term_due_date%type,

251: p_default_term_name OUT NOCOPY
252: ra_terms.name%type,
253: p_number_of_due_dates OUT NOCOPY number,
254: p_term_due_date OUT NOCOPY
255: ra_customer_trx.term_due_date%type,
256: p_security_inv_enter_flag IN
257: varchar2 DEFAULT 'Y',
258: p_security_cm_enter_flag IN
259: varchar2 DEFAULT 'Y',

Line 268: l_term_due_date ra_customer_trx.term_due_date%type;

264: ) IS
265:
266: l_number_of_due_dates number;
267: l_default_term_id ra_terms.term_id%type;
268: l_term_due_date ra_customer_trx.term_due_date%type;
269:
270: BEGIN
271:
272: IF PG_DEBUG in ('Y', 'C') THEN

Line 389: FROM ra_customer_trx_lines ctl

385: AND -- Check allow freight constraint and
386: -- prevent transactions with charges from being changed
387: -- into transactions that do not allow charges.
388: NOT EXISTS ( SELECT 'violates allow freight'
389: FROM ra_customer_trx_lines ctl
390: WHERE ctl.customer_trx_id = p_customer_trx_id
391: AND (
392: (
393: ctt.allow_freight_flag = 'N'

Line 406: FROM ra_customer_trx_lines ctl

402: )
403: AND -- Check creation sign constraint
404: NOT EXISTS (
405: SELECT 'VIOLATES CREATION SIGN'
406: FROM ra_customer_trx_lines ctl
407: WHERE ctl.customer_trx_id = p_customer_trx_id
408: GROUP BY ctt.creation_sign
409: HAVING DECODE(
410: SIGN( SUM(ctl.extended_amount) ),