DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_HEADER_UTIL

Line 5728: oe_Header_util.query_row (p_header_id => p_Header_id

5724: G_STMT_NO := 'calculate_adjustments#30';
5725:
5726: Begin
5727:
5728: oe_Header_util.query_row (p_header_id => p_Header_id
5729: ,x_header_rec=>OE_Order_PUB.g_hdr );
5730: Exception when no_data_found then
5731: x_return_status := 'NOOP';
5732: adj_debug(G_STMT_NO||'Invalid header_id '||p_Header_id,1);

Line 5850: oe_Header_util.query_row

5846:
5847: If p_use_current_header = FALSE Then
5848: Begin
5849: If l_line_tbl.first is not null Then
5850: oe_Header_util.query_row
5851: (p_header_id=> l_line_Tbl(l_line_tbl.first).Header_id, x_header_rec => OE_Order_PUB.g_hdr );
5852: Else
5853: oe_debug_pub.add(' Error: No line records in l_line_tbl');
5854: End If;

Line 10958: OE_Header_Util.Query_Row(p_header_id => p_header_id

10954:
10955: -- ASO installed; check whether it's a CRM order
10956: If (p_Header_id Is Not Null AND p_header_id <> FND_API.G_MISS_NUM) Then
10957: adj_debug('query source document type for header :'||p_header_id);
10958: OE_Header_Util.Query_Row(p_header_id => p_header_id
10959: , x_header_rec => l_header_rec);
10960: l_source_document_type_id := l_header_rec.source_document_type_id;
10961: l_booked_flag := l_header_rec.booked_flag;
10962: l_header_id := p_header_id;

Line 11322: OE_Header_Util.Query_Row(

11318: p_line_id => p_line_id
11319: , x_line_tbl => l_line_tbl1
11320: );
11321:
11322: OE_Header_Util.Query_Row(
11323: p_header_id => l_Line_Tbl1(1).header_id
11324: , x_header_rec => l_header_rec
11325: );
11326: Else

Line 11328: OE_Header_Util.Query_Row(

11324: , x_header_rec => l_header_rec
11325: );
11326: Else
11327:
11328: OE_Header_Util.Query_Row(
11329: p_header_id => p_header_id
11330: , x_header_rec => l_header_rec
11331: );
11332:

Line 11867: OE_Header_Util.Lock_Row

11863: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
11864: l_Price_Control_Rec.Simulation_Flag := 'N';
11865:
11866: --13727700 start
11867: OE_Header_Util.Lock_Row
11868: (p_header_id => l_header_id
11869: ,p_x_header_rec => l_locked_header_rec
11870: ,x_return_status => l_return_status
11871: );

Line 11922: OE_Header_Util.Lock_Row

11918: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
11919: l_Price_Control_Rec.Simulation_Flag := 'N';
11920:
11921: --13727700 start
11922: OE_Header_Util.Lock_Row
11923: (p_header_id => l_header_id
11924: ,p_x_header_rec => l_locked_header_rec
11925: ,x_return_status => l_return_status
11926: );

Line 12173: OE_Header_Util.Lock_Row

12169: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
12170: l_Price_Control_Rec.Simulation_Flag := 'N';
12171:
12172: --14647325 start
12173: OE_Header_Util.Lock_Row
12174: (p_header_id => l_header_id
12175: ,p_x_header_rec => l_locked_header_rec
12176: ,x_return_status => l_return_status
12177: );

Line 12853: oe_Header_util.query_row(p_header_id=>p_header_id,x_header_rec => OE_Order_PUB.g_hdr );

12849: OE_Order_PUB.G_LINE := NULL;
12850: OE_Order_PUB.G_HDR := NULL;
12851:
12852: If p_header_id is Not Null and p_cross_order = 'N' Then
12853: oe_Header_util.query_row(p_header_id=>p_header_id,x_header_rec => OE_Order_PUB.g_hdr );
12854: End If;
12855:
12856:
12857: G_STMT_NO := 'Get_manual_adjustment#1';

Line 12863: oe_Header_util.query_row(p_header_id=>l_line_tbl(line_tbl_index).header_id,

12859: While line_Tbl_Index is not null loop
12860:
12861: --Cross order lines, lines may not came from same header need to query header for each line
12862: If p_cross_order = 'Y' and p_header_id Is Null Then
12863: oe_Header_util.query_row(p_header_id=>l_line_tbl(line_tbl_index).header_id,
12864: x_header_rec => OE_Order_PUB.g_hdr );
12865: oe_debug_pub.add(' Currency Code:'||OE_Order_PUB.g_hdr.transactional_curr_code);
12866: x_header_id := l_line_tbl(line_tbl_index).header_id;
12867: End If;