DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS_2 dependencies on RA_CUST_TRX_TYPES

Line 55: ra_cust_trx_types.type%type,

51: PROCEDURE get_source_default(
52: p_batch_source_id IN
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,

Line 71: ra_cust_trx_types.cust_trx_type_id%type

67: ra_batch_sources.batch_source_type%type,
68: p_copy_doc_number_flag OUT NOCOPY
69: ra_batch_sources.copy_doc_number_flag%type,
70: p_default_cust_trx_type_id OUT NOCOPY
71: ra_cust_trx_types.cust_trx_type_id%type
72: ) IS
73:
74:
75: BEGIN

Line 99: FROM ra_cust_trx_types ctt,

95: p_auto_trx_numbering_flag,
96: p_batch_source_type,
97: p_default_cust_trx_type_id,
98: p_copy_doc_number_flag
99: FROM ra_cust_trx_types ctt,
100: ra_batch_sources bs
101: WHERE bs.batch_source_id = p_batch_source_id
102: AND bs.default_inv_trx_type = ctt.cust_trx_type_id(+)
103: AND NVL(p_ctt_class, '-99') =

Line 207: ra_cust_trx_types.cust_trx_type_id%type,

203: +===========================================================================*/
204:
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,

Line 211: ra_cust_trx_types.type%type,

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,
214: p_rev_recog_run_flag IN varchar2,
215: p_complete_flag IN

Line 218: ra_cust_trx_types.accounting_affect_flag%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,
221: p_default_cust_trx_type_id OUT NOCOPY
222: ra_cust_trx_types.cust_trx_type_id%type,

Line 222: ra_cust_trx_types.cust_trx_type_id%type,

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,
225: p_default_class OUT NOCOPY
226: ra_cust_trx_types.type%type,

Line 224: ra_cust_trx_types.name%type,

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,
225: p_default_class OUT NOCOPY
226: ra_cust_trx_types.type%type,
227: p_deflt_open_receivables_flag OUT NOCOPY
228: ra_cust_trx_types.accounting_affect_flag%type,

Line 226: ra_cust_trx_types.type%type,

222: ra_cust_trx_types.cust_trx_type_id%type,
223: p_default_type_name OUT NOCOPY
224: ra_cust_trx_types.name%type,
225: p_default_class OUT NOCOPY
226: ra_cust_trx_types.type%type,
227: p_deflt_open_receivables_flag OUT NOCOPY
228: ra_cust_trx_types.accounting_affect_flag%type,
229: p_default_post_to_gl_flag OUT NOCOPY
230: ra_cust_trx_types.post_to_gl%type,

Line 228: ra_cust_trx_types.accounting_affect_flag%type,

224: ra_cust_trx_types.name%type,
225: p_default_class OUT NOCOPY
226: ra_cust_trx_types.type%type,
227: p_deflt_open_receivables_flag OUT NOCOPY
228: ra_cust_trx_types.accounting_affect_flag%type,
229: p_default_post_to_gl_flag OUT NOCOPY
230: ra_cust_trx_types.post_to_gl%type,
231: p_default_allow_freight_flag OUT NOCOPY
232: ra_cust_trx_types.allow_freight_flag%type,

Line 230: ra_cust_trx_types.post_to_gl%type,

226: ra_cust_trx_types.type%type,
227: p_deflt_open_receivables_flag OUT NOCOPY
228: ra_cust_trx_types.accounting_affect_flag%type,
229: p_default_post_to_gl_flag OUT NOCOPY
230: ra_cust_trx_types.post_to_gl%type,
231: p_default_allow_freight_flag OUT NOCOPY
232: ra_cust_trx_types.allow_freight_flag%type,
233: p_default_creation_sign OUT NOCOPY
234: ra_cust_trx_types.creation_sign%type,

Line 232: ra_cust_trx_types.allow_freight_flag%type,

228: ra_cust_trx_types.accounting_affect_flag%type,
229: p_default_post_to_gl_flag OUT NOCOPY
230: ra_cust_trx_types.post_to_gl%type,
231: p_default_allow_freight_flag OUT NOCOPY
232: ra_cust_trx_types.allow_freight_flag%type,
233: p_default_creation_sign OUT NOCOPY
234: ra_cust_trx_types.creation_sign%type,
235: p_default_allow_overapp_flag OUT NOCOPY
236: ra_cust_trx_types.allow_overapplication_flag%type,

Line 234: ra_cust_trx_types.creation_sign%type,

230: ra_cust_trx_types.post_to_gl%type,
231: p_default_allow_freight_flag OUT NOCOPY
232: ra_cust_trx_types.allow_freight_flag%type,
233: p_default_creation_sign OUT NOCOPY
234: ra_cust_trx_types.creation_sign%type,
235: p_default_allow_overapp_flag OUT NOCOPY
236: ra_cust_trx_types.allow_overapplication_flag%type,
237: p_deflt_natural_app_only_flag OUT NOCOPY
238: ra_cust_trx_types.natural_application_only_flag%type,

Line 236: ra_cust_trx_types.allow_overapplication_flag%type,

232: ra_cust_trx_types.allow_freight_flag%type,
233: p_default_creation_sign OUT NOCOPY
234: ra_cust_trx_types.creation_sign%type,
235: p_default_allow_overapp_flag OUT NOCOPY
236: ra_cust_trx_types.allow_overapplication_flag%type,
237: p_deflt_natural_app_only_flag OUT NOCOPY
238: ra_cust_trx_types.natural_application_only_flag%type,
239: p_default_tax_calculation_flag OUT NOCOPY
240: ra_cust_trx_types.tax_calculation_flag%type,

Line 238: ra_cust_trx_types.natural_application_only_flag%type,

234: ra_cust_trx_types.creation_sign%type,
235: p_default_allow_overapp_flag OUT NOCOPY
236: ra_cust_trx_types.allow_overapplication_flag%type,
237: p_deflt_natural_app_only_flag OUT NOCOPY
238: ra_cust_trx_types.natural_application_only_flag%type,
239: p_default_tax_calculation_flag OUT NOCOPY
240: ra_cust_trx_types.tax_calculation_flag%type,
241: p_default_status_code OUT NOCOPY
242: ar_lookups.lookup_code%type,

Line 240: ra_cust_trx_types.tax_calculation_flag%type,

236: ra_cust_trx_types.allow_overapplication_flag%type,
237: p_deflt_natural_app_only_flag OUT NOCOPY
238: ra_cust_trx_types.natural_application_only_flag%type,
239: p_default_tax_calculation_flag OUT NOCOPY
240: ra_cust_trx_types.tax_calculation_flag%type,
241: p_default_status_code OUT NOCOPY
242: ar_lookups.lookup_code%type,
243: p_default_status OUT NOCOPY
244: ar_lookups.meaning%type,

Line 316: ra_cust_trx_types ctt

312: p_default_term_name
313: FROM ar_lookups arl_print,
314: ar_lookups arl_status,
315: ra_terms rat,
316: ra_cust_trx_types ctt
317: WHERE ctt.cust_trx_type_id = p_cust_trx_type_id
318: AND 'INVOICE_PRINT_OPTIONS' = arl_print.lookup_type(+)
319: AND ctt.default_printing_option = arl_print.lookup_code(+)
320: AND 'INVOICE_TRX_STATUS' = arl_status.lookup_type(+)