1857: END LOOP;
1858:
1859: SELECT nvl(max(event_number),0) + 1
1860: INTO l_event_number
1861: FROM PN_ACCOUNTING_EVENTS_ALL
1862: WHERE source_table = 'PN_PAYMENT_TERMS'
1863: AND SOURCE_ID = v_pn_payment_term_id
1864: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1865:
1864: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1865:
1866: pnp_debug_pkg.log('Before event insert');
1867:
1868: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
1869: (
1870: ACCOUNTING_EVENT_ID ,
1871: EVENT_TYPE_CODE ,
1872: ACCOUNTING_DATE ,
2611: END LOOP;
2612:
2613: SELECT nvl(max(event_number),0) + 1
2614: INTO l_event_number
2615: FROM pn_accounting_events_all
2616: WHERE source_table = 'PN_PAYMENT_TERMS'
2617: AND SOURCE_ID = v_pn_payment_term_id
2618: AND EVENT_TYPE_CODE = v_pn_event_type_code;
2619:
2621:
2622:
2623: l_context := 'Inserting into PN_ACCOUNTING_EVENTS';
2624:
2625: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
2626: (
2627: ACCOUNTING_EVENT_ID ,
2628: EVENT_TYPE_CODE ,
2629: ACCOUNTING_DATE ,