DBA Data[Home] [Help]

APPS.ARP_PROCESS_HEADER dependencies on AR_LINE_CONTS

Line 1737: | deletes rows from ar_line_conts and ar_deferred_lines. |

1733: | PROCEDURE |
1734: | delete_cont_defer_data | |
1735: | |
1736: | DESCRIPTION |
1737: | deletes rows from ar_line_conts and ar_deferred_lines. |
1738: | |
1739: | SCOPE - PRIVATE |
1740: | |
1741: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1762: ar_line_conts alc

1758: PROCEDURE delete_cont_defer_data(p_customer_trx_id IN NUMBER) IS
1759: CURSOR cont_cursor IS
1760: select alc.customer_trx_line_id
1761: from ra_customer_trx_lines ctl,
1762: ar_line_conts alc
1763: where
1764: ctl.customer_trx_id = p_customer_trx_id
1765: and ctl.customer_trx_line_id = alc.customer_trx_line_id
1766: and ctl.line_type = 'LINE'

Line 1780: delete from ar_line_conts

1776: BEGIN
1777: arp_util.debug('arp_process_header.delete_cont_defer_data+');
1778:
1779: FOR l_cont_rec IN cont_cursor LOOP
1780: delete from ar_line_conts
1781: where customer_trx_line_id = l_cont_rec.customer_trx_line_id;
1782: END LOOP;
1783:
1784: FOR l_deferred_rec IN deferred_cursor LOOP