APPS.ARP_CTL_PRIVATE_PKG dependencies on RA_CUSTOMER_TRX

Line 31: p_line_rec IN ra_customer_trx_lines%rowtype) IS

27: | 19-JUL-95 Subash C Created |
28: | 07-APR-05 Debbie Sue Jancis ETax: Added Ship to Id's |
29: +===========================================================================*/
30: PROCEDURE display_line_rec(
31: p_line_rec IN ra_customer_trx_lines%rowtype) IS
32: BEGIN
33: arp_util.debug('arp_ctl_private_pkg.display_line_rec()+');
34:
35: arp_util.debug('******** Dump of ra_customer_trx_lines record *********');

Line 35: arp_util.debug('******** Dump of ra_customer_trx_lines record *********');

31: p_line_rec IN ra_customer_trx_lines%rowtype) IS
32: BEGIN
33: arp_util.debug('arp_ctl_private_pkg.display_line_rec()+');
34:
35: arp_util.debug('******** Dump of ra_customer_trx_lines record *********');
36: arp_util.debug('customer_trx_line_id : '||
37: p_line_rec.customer_trx_line_id);
38: arp_util.debug('customer_trx_id : '||
39: p_line_rec.customer_trx_id);

Line 250: ra_customer_trx_lines.customer_trx_line_id%type) IS

246: | |
247: +===========================================================================*/
248: PROCEDURE display_line_p(
249: p_customer_trx_line_id IN
250: ra_customer_trx_lines.customer_trx_line_id%type) IS
251:
252: l_line_rec ra_customer_trx_lines%rowtype;
253: BEGIN
254: arp_util.debug('arp_ctl_private_pkg.display_line_p()+');

Line 252: l_line_rec ra_customer_trx_lines%rowtype;

248: PROCEDURE display_line_p(
249: p_customer_trx_line_id IN
250: ra_customer_trx_lines.customer_trx_line_id%type) IS
251:
252: l_line_rec ra_customer_trx_lines%rowtype;
253: BEGIN
254: arp_util.debug('arp_ctl_private_pkg.display_line_p()+');
255:
256: arp_ctl_pkg.fetch_p(l_line_rec, p_customer_trx_line_id);

Line 305: ra_customer_trx_lines.link_to_cust_trx_line_id%type)

301: +===========================================================================*/
302:
303:
304: PROCEDURE display_line_f_lctl_id( p_link_to_cust_trx_line_id IN
305: ra_customer_trx_lines.link_to_cust_trx_line_id%type)
306: IS
307:
308:
309: CURSOR line_cursor IS

Line 311: FROM ra_customer_trx_lines

307:
308:
309: CURSOR line_cursor IS
310: SELECT *
311: FROM ra_customer_trx_lines
312: WHERE link_to_cust_trx_line_id = p_link_to_cust_trx_line_id
313: ORDER BY line_type,
314: line_number;
315:

Line 324: ' Dump of ra_customer_trx_lines records for ltctlid: '||

320:
321: arp_util.debug('=====================================================' ||
322: '==========================');
323: arp_util.debug('========== ' ||
324: ' Dump of ra_customer_trx_lines records for ltctlid: '||
325: to_char( p_link_to_cust_trx_line_id ) || ' ' ||
326: '==========');
327:
328: FOR l_line_rec IN line_cursor LOOP

Line 333: ' Dump of ra_customer_trx_lines records for ltctlid: '||

329: display_line_p(l_line_rec.customer_trx_line_id);
330: END LOOP;
331:
332: arp_util.debug('====== End ' ||
333: ' Dump of ra_customer_trx_lines records for ltctlid: '||
334: to_char( p_link_to_cust_trx_line_id ) || ' ' ||
335: '=======');
336: arp_util.debug('=====================================================' ||
337: '==========================');

Line 386: ra_customer_trx.customer_trx_id%type )

382: +===========================================================================*/
383:
384:
385: PROCEDURE display_line_f_ct_id( p_customer_trx_id IN
386: ra_customer_trx.customer_trx_id%type )
387: IS
388:
389:
390: CURSOR line_cursor IS

Line 392: FROM ra_customer_trx_lines

388:
389:
390: CURSOR line_cursor IS
391: SELECT *
392: FROM ra_customer_trx_lines
393: WHERE customer_trx_id = p_customer_trx_id
394: ORDER BY line_type,
395: line_number;
396:

Line 405: ' Dump of ra_customer_trx_lines records for ctid: '||

401:
402: arp_util.debug('=====================================================' ||
403: '==========================');
404: arp_util.debug('========== ' ||
405: ' Dump of ra_customer_trx_lines records for ctid: '||
406: to_char( p_customer_trx_id ) || ' ' ||
407: '==========');
408:
409: FOR l_line_rec IN line_cursor LOOP

Line 414: ' Dump of ra_customer_trx_lines records for ctid: '||

410: display_line_p(l_line_rec.customer_trx_line_id);
411: END LOOP;
412:
413: arp_util.debug('====== End ' ||
414: ' Dump of ra_customer_trx_lines records for ctid: '||
415: to_char( p_customer_trx_id ) || ' ' ||
416: '=======');
417: arp_util.debug('=====================================================' ||
418: '==========================');