eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_COMMITMENT dependencies on RA_CUSTOMER_TRX

Line 118: ra_customer_trx.customer_trx_id%type,

114: +===========================================================================*/
115:
116: PROCEDURE insert_line_salescredit(
117: p_customer_trx_id IN
118: ra_customer_trx.customer_trx_id%type,
119: p_customer_trx_line_id IN
120: ra_customer_trx_lines.customer_trx_line_id%type,
121: p_salesrep_id IN
122: ra_cust_trx_line_salesreps.salesrep_id%type,

Line 120: ra_customer_trx_lines.customer_trx_line_id%type,

116: PROCEDURE insert_line_salescredit(
117: p_customer_trx_id IN
118: ra_customer_trx.customer_trx_id%type,
119: p_customer_trx_line_id IN
120: ra_customer_trx_lines.customer_trx_line_id%type,
121: p_salesrep_id IN
122: ra_cust_trx_line_salesreps.salesrep_id%type,
123: p_extended_amount IN
124: ra_customer_trx_lines.extended_amount%type) IS

Line 124: ra_customer_trx_lines.extended_amount%type) IS

120: ra_customer_trx_lines.customer_trx_line_id%type,
121: p_salesrep_id IN
122: ra_cust_trx_line_salesreps.salesrep_id%type,
123: p_extended_amount IN
124: ra_customer_trx_lines.extended_amount%type) IS
125:
126: l_srep_rec
127: ra_cust_trx_line_salesreps%rowtype;
128: l_cust_trx_line_salesrep_id

Line 188: ra_customer_trx.customer_trx_id%type,

184: | |
185: +===========================================================================*/
186:
187: PROCEDURE insert_dist_line(p_customer_trx_id IN
188: ra_customer_trx.customer_trx_id%type,
189: p_customer_trx_line_id IN
190: ra_customer_trx_lines.customer_trx_line_id%type,
191: p_gl_date IN
192: ra_cust_trx_line_gl_dist.gl_date%type,

Line 190: ra_customer_trx_lines.customer_trx_line_id%type,

186:
187: PROCEDURE insert_dist_line(p_customer_trx_id IN
188: ra_customer_trx.customer_trx_id%type,
189: p_customer_trx_line_id IN
190: ra_customer_trx_lines.customer_trx_line_id%type,
191: p_gl_date IN
192: ra_cust_trx_line_gl_dist.gl_date%type,
193: p_status OUT NOCOPY varchar2)
194: IS

Line 228: from ra_customer_trx cust_trx,

224: Begin
225:
226: select cust_trx_type.gl_id_rev
227: into l_passed_ccid
228: from ra_customer_trx cust_trx,
229: ra_cust_trx_types cust_trx_type
230: where cust_trx_type.type ='DEP' and
231: cust_trx.cust_trx_type_id =cust_trx_type.cust_trx_type_id and
232: cust_trx.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;

Line 331: ra_customer_trx.customer_trx_id%type,

327: | |
328: +===========================================================================*/
329:
330: PROCEDURE header_post_insert ( p_customer_trx_id IN
331: ra_customer_trx.customer_trx_id%type,
332: p_commitment_rec IN commitment_rec_type,
333: p_primary_salesrep_id IN
334: ra_customer_trx.primary_salesrep_id%type,
335: p_gl_date IN

Line 334: ra_customer_trx.primary_salesrep_id%type,

330: PROCEDURE header_post_insert ( p_customer_trx_id IN
331: ra_customer_trx.customer_trx_id%type,
332: p_commitment_rec IN commitment_rec_type,
333: p_primary_salesrep_id IN
334: ra_customer_trx.primary_salesrep_id%type,
335: p_gl_date IN
336: ra_cust_trx_line_gl_dist.gl_date%type,
337: p_customer_trx_line_id OUT NOCOPY
338: ra_customer_trx_lines.customer_trx_line_id%type,

Line 338: ra_customer_trx_lines.customer_trx_line_id%type,

334: ra_customer_trx.primary_salesrep_id%type,
335: p_gl_date IN
336: ra_cust_trx_line_gl_dist.gl_date%type,
337: p_customer_trx_line_id OUT NOCOPY
338: ra_customer_trx_lines.customer_trx_line_id%type,
339: p_status OUT NOCOPY varchar2
340: )
341: IS
342:

Line 343: l_line_rec ra_customer_trx_lines%rowtype;

339: p_status OUT NOCOPY varchar2
340: )
341: IS
342:
343: l_line_rec ra_customer_trx_lines%rowtype;
344: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
345:
346: BEGIN
347:

Line 344: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

340: )
341: IS
342:
343: l_line_rec ra_customer_trx_lines%rowtype;
344: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
345:
346: BEGIN
347:
348: arp_util.debug('arp_process_commitment.header_post_insert()+');

Line 351: | Insert row into ra_customer_trx_lines |

347:
348: arp_util.debug('arp_process_commitment.header_post_insert()+');
349:
350: /*-----------------------------------------+
351: | Insert row into ra_customer_trx_lines |
352: +-----------------------------------------*/
353:
354:
355: l_line_rec.customer_trx_id := p_customer_trx_id;

Line 514: l_old_commitment_rec ra_customer_trx_lines%rowtype;

510: PROCEDURE set_flags(p_new_commitment_rec IN commitment_rec_type,
511: p_changed_flags_rec OUT NOCOPY changed_flags_rec_type)
512: IS
513:
514: l_old_commitment_rec ra_customer_trx_lines%rowtype;
515:
516: BEGIN
517:
518: arp_util.debug('arp_process_commitment.set_flags()+',

Line 968: ra_customer_trx.exchange_rate%type,

964: PROCEDURE header_post_update( p_commitment_rec IN commitment_rec_type,
965: p_foreign_currency_code IN
966: fnd_currencies.currency_code%type,
967: p_exchange_rate IN
968: ra_customer_trx.exchange_rate%type,
969: p_rerun_autoacc_flag IN boolean )
970: IS
971:
972: l_changed_flags_rec changed_flags_rec_type;

Line 973: l_line_rec ra_customer_trx_lines%rowtype;

969: p_rerun_autoacc_flag IN boolean )
970: IS
971:
972: l_changed_flags_rec changed_flags_rec_type;
973: l_line_rec ra_customer_trx_lines%rowtype;
974:
975: BEGIN
976:
977: arp_util.debug('arp_process_commitment.header_post_update()+');