DBA Data[Home] [Help]

APPS.ARP_CMA_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 630: IN ra_customer_trx_lines.customer_trx_line_id%type)

626: | |
627: +===========================================================================*/
628:
629: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
630: IN ra_customer_trx_lines.customer_trx_line_id%type)
631: IS
632:
633: CURSOR lock_c IS
634: SELECT credit_memo_amount_id

Line 987: IN ra_customer_trx_lines.customer_trx_line_id%type)

983: | |
984: +===========================================================================*/
985:
986: procedure delete_f_ctl_id( p_customer_trx_line_id
987: IN ra_customer_trx_lines.customer_trx_line_id%type)
988: IS
989:
990:
991: BEGIN

Line 1049: FROM ra_customer_trx_lines

1045:
1046: DELETE FROM ar_credit_memo_amounts
1047: WHERE customer_trx_line_id IN
1048: (SELECT customer_trx_line_id
1049: FROM ra_customer_trx_lines
1050: WHERE customer_trx_id = p_customer_trx_id);
1051:
1052: arp_util.debug('arp_cma_pkg.delete_f_ct_id()-');
1053:

Line 1150: ra_customer_trx_lines.customer_trx_line_id%type)

1146: +===========================================================================*/
1147:
1148: PROCEDURE update_f_ctl_id( p_cma_rec IN ar_credit_memo_amounts%rowtype,
1149: p_customer_trx_line_id IN
1150: ra_customer_trx_lines.customer_trx_line_id%type)
1151: IS
1152:
1153:
1154: BEGIN