APPS.ARP_TRX_DEFAULTS_2 dependencies on RA_BATCH_SOURCES

Line 53: ra_batch_sources.batch_source_id%type,

49: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
50:
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,

Line 61: ra_batch_sources.batch_source_id%type,

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,
64: p_auto_trx_numbering_flag OUT NOCOPY
65: ra_batch_sources.auto_trx_numbering_flag%type,

Line 63: ra_batch_sources.name%type,

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,
64: p_auto_trx_numbering_flag OUT NOCOPY
65: ra_batch_sources.auto_trx_numbering_flag%type,
66: p_batch_source_type OUT NOCOPY
67: ra_batch_sources.batch_source_type%type,

Line 65: ra_batch_sources.auto_trx_numbering_flag%type,

61: ra_batch_sources.batch_source_id%type,
62: p_default_batch_source_name OUT NOCOPY
63: ra_batch_sources.name%type,
64: p_auto_trx_numbering_flag OUT NOCOPY
65: ra_batch_sources.auto_trx_numbering_flag%type,
66: p_batch_source_type OUT NOCOPY
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,

Line 67: ra_batch_sources.batch_source_type%type,

63: ra_batch_sources.name%type,
64: p_auto_trx_numbering_flag OUT NOCOPY
65: ra_batch_sources.auto_trx_numbering_flag%type,
66: p_batch_source_type OUT NOCOPY
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

Line 69: ra_batch_sources.copy_doc_number_flag%type,

65: ra_batch_sources.auto_trx_numbering_flag%type,
66: p_batch_source_type OUT NOCOPY
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:

Line 100: ra_batch_sources bs

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') =
104: DECODE(p_ctt_class,