DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_HEADER_UTIL

Line 5742: l_header_rec:= OE_Header_UTIL.Query_Row(p_header_id=> p_entity_id_tbl(i).entity_id ); --added for bug 12895421

5738: END LOOP;
5739: END IF;
5740: elsif p_entity_id_tbl(i).requesting_entity_code = 'HEADER' THEN
5741: /* Calculating total new tax value from l_tax_rec_out_tbl record*/
5742: l_header_rec:= OE_Header_UTIL.Query_Row(p_header_id=> p_entity_id_tbl(i).entity_id ); --added for bug 12895421
5743: FOR j IN 1..l_tax_rec_out_tbl.count
5744: LOOP
5745: IF l_tax_rec_out_tbl(j).trx_id = p_entity_id_tbl(i).entity_id AND l_tax_rec_out_tbl(j).line_id IS NULL THEN
5746: l_total_tax := l_total_tax + l_tax_rec_out_tbl(j).tax_amount;

Line 5763: l_header_rec:= OE_Header_UTIL.Query_Row(p_header_id=> p_entity_id_tbl(i).entity_id );

5759: IF l_debug_level > 0 THEN
5760: oe_debug_pub.add('Updateing tax value from '||TO_CHAR(l_old_total_tax)|| ' To ' ||TO_CHAR(l_total_tax) ,2);
5761: END IF;
5762: /* getting header record*/
5763: l_header_rec:= OE_Header_UTIL.Query_Row(p_header_id=> p_entity_id_tbl(i).entity_id );
5764: SELECT payment_type_code
5765: INTO l_payment_type_code
5766: FROM oe_order_headers_all
5767: WHERE header_id = l_header_rec.header_id;