APPS.OE_INVOICE_PUB dependencies on OE_INVOICE_NUMBERS

Line 8122: FROM oe_invoice_numbers

8118: END IF;
8119: inv_num_base := p_del_name;
8120: SELECT nvl((max(index_number)+1), 0)
8121: INTO inv_num_index
8122: FROM oe_invoice_numbers
8123: WHERE delivery_id = p_del_id;
8124: IF ( SQL%NOTFOUND ) THEN
8125: inv_num_index := 1;
8126: END IF;

Line 8136: INSERT INTO OE_INVOICE_NUMBERS(

8132: IF l_debug_level > 0 THEN
8133: oe_debug_pub.add( 'GLOBAL USER ' || NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637
8134: oe_debug_pub.add( 'INV NUM INDEX ' || TO_CHAR ( INV_NUM_INDEX ) ) ;
8135: END IF;
8136: INSERT INTO OE_INVOICE_NUMBERS(
8137: INVOICE_NUMBER_ID
8138: , DELIVERY_ID
8139: , INDEX_NUMBER
8140: , LAST_UPDATE_DATE

Line 8145: ( oe_invoice_numbers_s.nextval

8141: , LAST_UPDATED_BY
8142: , CREATION_DATE
8143: , CREATED_BY)
8144: VALUES
8145: ( oe_invoice_numbers_s.nextval
8146: , p_del_id
8147: , inv_num_index
8148: , SYSDATE
8149: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id) -- 3169637