APPS.OE_INVOICE_PUB dependencies on OE_INVOICE_NUMBERS

Line 7738: FROM oe_invoice_numbers

7734: END IF;
7735: inv_num_base := p_del_name;
7736: SELECT nvl((max(index_number)+1), 0)
7737: INTO inv_num_index
7738: FROM oe_invoice_numbers
7739: WHERE delivery_id = p_del_id;
7740: IF ( SQL%NOTFOUND ) THEN
7741: inv_num_index := 1;
7742: END IF;

Line 7752: INSERT INTO OE_INVOICE_NUMBERS(

7748: IF l_debug_level > 0 THEN
7749: oe_debug_pub.add( 'GLOBAL USER ' || NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637
7750: oe_debug_pub.add( 'INV NUM INDEX ' || TO_CHAR ( INV_NUM_INDEX ) ) ;
7751: END IF;
7752: INSERT INTO OE_INVOICE_NUMBERS(
7753: INVOICE_NUMBER_ID
7754: , DELIVERY_ID
7755: , INDEX_NUMBER
7756: , LAST_UPDATE_DATE

Line 7761: ( oe_invoice_numbers_s.nextval

7757: , LAST_UPDATED_BY
7758: , CREATION_DATE
7759: , CREATED_BY)
7760: VALUES
7761: ( oe_invoice_numbers_s.nextval
7762: , p_del_id
7763: , inv_num_index
7764: , SYSDATE
7765: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id) -- 3169637