DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on OE_HEADER_UTIL

Line 410: Oe_Header_Util.Query_Row(l_line_rec.header_id, l_header_rec);

406: IF Oe_Genesis_Util.Status_Needs_Sync(p_flow_status_code) THEN
407: IF Oe_Genesis_Util.Source_AIA_Enabled(p_order_source_id)
408: THEN
409: Oe_Line_Util.Query_Row(p_line_id, l_line_rec);
410: Oe_Header_Util.Query_Row(l_line_rec.header_id, l_header_rec);
411:
412: SELECT oe_xml_message_seq_s.NEXTVAL
413: INTO l_item_key_sso
414: FROM Dual;

Line 481: Oe_Header_Util.Query_Row(p_header_id, l_header_rec);

477: END IF;
478:
479: IF Oe_Genesis_Util.Status_Needs_Sync(p_flow_status_code) = TRUE THEN
480:
481: Oe_Header_Util.Query_Row(p_header_id, l_header_rec);
482:
483: IF Oe_Genesis_Util.Source_AIA_Enabled(l_header_rec.order_source_id) THEN
484:
485: SELECT oe_xml_message_seq_s.NEXTVAL

Line 8969: --bug 5336623 Moved the following call to OE_Header_Util.Query_row after the line is locked

8965: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8967: END IF; */
8968:
8969: --bug 5336623 Moved the following call to OE_Header_Util.Query_row after the line is locked
8970: --OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
8971: IF p_itemtype = OE_GLOBALS.G_WFI_HDR THEN
8972: p_header_id := l_line_rec.header_id;
8973: END IF;

Line 8970: --OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);

8966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8967: END IF; */
8968:
8969: --bug 5336623 Moved the following call to OE_Header_Util.Query_row after the line is locked
8970: --OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
8971: IF p_itemtype = OE_GLOBALS.G_WFI_HDR THEN
8972: p_header_id := l_line_rec.header_id;
8973: END IF;
8974: -- Set message context

Line 9046: OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);

9042: END IF;
9043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9044: END;
9045:
9046: OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
9047: --bug 5336623
9048:
9049:
9050: ---Bug 8683948 : Start

Line 9671: OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);

9667: LOOP
9668: FETCH delivery_lines_cursor INTO l_line_id;
9669: EXIT WHEN delivery_lines_cursor%NOTFOUND;
9670: OE_Line_Util.Query_Row(p_line_id=>l_line_id, x_line_rec=>l_line_rec);
9671: OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
9672: IF l_debug_level > 0 THEN
9673: oe_debug_pub.add( 'LINE ID : '||L_LINE_REC.LINE_ID , 5 ) ;
9674: END IF;
9675: --gaynagar processing non-invoiceable lines with delivery lines