DBA Data[Home] [Help]

APPS.ARP_PROCESS_HEADER dependencies on AR_LINE_CONTS

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

1813: | PROCEDURE |
1814: | delete_cont_defer_data | |
1815: | |
1816: | DESCRIPTION |
1817: | deletes rows from ar_line_conts and ar_deferred_lines. |
1818: | |
1819: | SCOPE - PRIVATE |
1820: | |
1821: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1842: ar_line_conts alc

1838: PROCEDURE delete_cont_defer_data(p_customer_trx_id IN NUMBER) IS
1839: CURSOR cont_cursor IS
1840: select alc.customer_trx_line_id
1841: from ra_customer_trx_lines ctl,
1842: ar_line_conts alc
1843: where
1844: ctl.customer_trx_id = p_customer_trx_id
1845: and ctl.customer_trx_line_id = alc.customer_trx_line_id
1846: and ctl.line_type = 'LINE'

Line 1860: delete from ar_line_conts

1856: BEGIN
1857: arp_util.debug('arp_process_header.delete_cont_defer_data+');
1858:
1859: FOR l_cont_rec IN cont_cursor LOOP
1860: delete from ar_line_conts
1861: where customer_trx_line_id = l_cont_rec.customer_trx_line_id;
1862: END LOOP;
1863:
1864: FOR l_deferred_rec IN deferred_cursor LOOP