DBA Data[Home] [Help]

APPS.ARP_PROCESS_FREIGHT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 275: ra_cust_trx_line_gl_dist.code_combination_id%type,

271: PROCEDURE set_flags(
272: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
273: p_new_frt_rec IN ra_customer_trx_lines%rowtype,
274: p_new_ccid IN
275: ra_cust_trx_line_gl_dist.code_combination_id%type,
276: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
277: p_amount_changed_flag OUT NOCOPY boolean,
278: p_ccid_changed_flag OUT NOCOPY boolean,
279: p_gl_date_changed_flag OUT NOCOPY boolean) IS

Line 276: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

272: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
273: p_new_frt_rec IN ra_customer_trx_lines%rowtype,
274: p_new_ccid IN
275: ra_cust_trx_line_gl_dist.code_combination_id%type,
276: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
277: p_amount_changed_flag OUT NOCOPY boolean,
278: p_ccid_changed_flag OUT NOCOPY boolean,
279: p_gl_date_changed_flag OUT NOCOPY boolean) IS
280:

Line 282: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

278: p_ccid_changed_flag OUT NOCOPY boolean,
279: p_gl_date_changed_flag OUT NOCOPY boolean) IS
280:
281: l_old_frt_rec ra_customer_trx_lines%rowtype;
282: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
283: l_old_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
284:
285: BEGIN
286: arp_util.debug('arp_process_freight.set_flags()+');

Line 283: l_old_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;

279: p_gl_date_changed_flag OUT NOCOPY boolean) IS
280:
281: l_old_frt_rec ra_customer_trx_lines%rowtype;
282: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
283: l_old_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
284:
285: BEGIN
286: arp_util.debug('arp_process_freight.set_flags()+');
287:

Line 303: from ra_cust_trx_line_gl_dist

299: select max(code_combination_id),
300: max(gl_date)
301: into l_old_ccid,
302: l_old_gl_date
303: from ra_cust_trx_line_gl_dist
304: where customer_trx_line_id = p_customer_trx_line_id;
305:
306: IF (nvl(l_old_ccid, 0) <> nvl(p_new_ccid, 0)) THEN
307: p_ccid_changed_flag := TRUE;

Line 374: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

370: p_form_name IN varchar2,
371: p_form_version IN number,
372: p_frt_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
373: p_trx_class IN ra_cust_trx_types.type%type,
374: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
375: p_frt_ccid IN
376: ra_cust_trx_line_gl_dist.code_combination_id%type,
377: p_customer_trx_line_id OUT NOCOPY
378: ra_customer_trx_lines.customer_trx_line_id%type,

Line 376: ra_cust_trx_line_gl_dist.code_combination_id%type,

372: p_frt_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
373: p_trx_class IN ra_cust_trx_types.type%type,
374: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
375: p_frt_ccid IN
376: ra_cust_trx_line_gl_dist.code_combination_id%type,
377: p_customer_trx_line_id OUT NOCOPY
378: ra_customer_trx_lines.customer_trx_line_id%type,
379: p_status OUT NOCOPY varchar2,
380: p_run_autoacc_flag IN varchar2 DEFAULT 'Y')

Line 387: ra_cust_trx_line_gl_dist.code_combination_id%type;

383:
384: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
385: l_result integer;
386: l_ccid
387: ra_cust_trx_line_gl_dist.code_combination_id%type;
388: l_concat_segments varchar2(200);
389: l_num_failed_dist_rows number;
390: l_rows_processed number;
391: l_errorbuf varchar2(200);

Line 552: ra_cust_trx_line_gl_dist.gl_date%type,

548: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
549: p_frt_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
550: p_trx_class IN ra_cust_trx_types.type%type,
551: p_gl_date IN
552: ra_cust_trx_line_gl_dist.gl_date%type,
553: p_frt_ccid IN
554: ra_cust_trx_line_gl_dist.code_combination_id%type,
555: p_complete_flag IN varchar2,
556: p_open_rec_flag IN varchar2,

Line 554: ra_cust_trx_line_gl_dist.code_combination_id%type,

550: p_trx_class IN ra_cust_trx_types.type%type,
551: p_gl_date IN
552: ra_cust_trx_line_gl_dist.gl_date%type,
553: p_frt_ccid IN
554: ra_cust_trx_line_gl_dist.code_combination_id%type,
555: p_complete_flag IN varchar2,
556: p_open_rec_flag IN varchar2,
557: p_status OUT NOCOPY varchar2)
558: IS