DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_HEADER_UTIL

Line 5645: oe_Header_util.query_row (p_header_id => p_Header_id

5641: G_STMT_NO := 'calculate_adjustments#30';
5642:
5643: Begin
5644:
5645: oe_Header_util.query_row (p_header_id => p_Header_id
5646: ,x_header_rec=>OE_Order_PUB.g_hdr );
5647: Exception when no_data_found then
5648: x_return_status := 'NOOP';
5649: adj_debug(G_STMT_NO||'Invalid header_id '||p_Header_id,1);

Line 5759: oe_Header_util.query_row

5755:
5756: If p_use_current_header = FALSE Then
5757: Begin
5758: If l_line_tbl.first is not null Then
5759: oe_Header_util.query_row
5760: (p_header_id=> l_line_Tbl(l_line_tbl.first).Header_id, x_header_rec => OE_Order_PUB.g_hdr );
5761: Else
5762: oe_debug_pub.add(' Error: No line records in l_line_tbl');
5763: End If;

Line 10850: OE_Header_Util.Query_Row(p_header_id => p_header_id

10846:
10847: -- ASO installed; check whether it's a CRM order
10848: If (p_Header_id Is Not Null AND p_header_id <> FND_API.G_MISS_NUM) Then
10849: adj_debug('query source document type for header :'||p_header_id);
10850: OE_Header_Util.Query_Row(p_header_id => p_header_id
10851: , x_header_rec => l_header_rec);
10852: l_source_document_type_id := l_header_rec.source_document_type_id;
10853: l_booked_flag := l_header_rec.booked_flag;
10854: l_header_id := p_header_id;

Line 11214: OE_Header_Util.Query_Row(

11210: p_line_id => p_line_id
11211: , x_line_tbl => l_line_tbl1
11212: );
11213:
11214: OE_Header_Util.Query_Row(
11215: p_header_id => l_Line_Tbl1(1).header_id
11216: , x_header_rec => l_header_rec
11217: );
11218: Else

Line 11220: OE_Header_Util.Query_Row(

11216: , x_header_rec => l_header_rec
11217: );
11218: Else
11219:
11220: OE_Header_Util.Query_Row(
11221: p_header_id => p_header_id
11222: , x_header_rec => l_header_rec
11223: );
11224:

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

12685: OE_Order_PUB.G_LINE := NULL;
12686: OE_Order_PUB.G_HDR := NULL;
12687:
12688: If p_header_id is Not Null and p_cross_order = 'N' Then
12689: oe_Header_util.query_row(p_header_id=>p_header_id,x_header_rec => OE_Order_PUB.g_hdr );
12690: End If;
12691:
12692:
12693: G_STMT_NO := 'Get_manual_adjustment#1';

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

12695: While line_Tbl_Index is not null loop
12696:
12697: --Cross order lines, lines may not came from same header need to query header for each line
12698: If p_cross_order = 'Y' and p_header_id Is Null Then
12699: oe_Header_util.query_row(p_header_id=>l_line_tbl(line_tbl_index).header_id,
12700: x_header_rec => OE_Order_PUB.g_hdr );
12701: oe_debug_pub.add(' Currency Code:'||OE_Order_PUB.g_hdr.transactional_curr_code);
12702: x_header_id := l_line_tbl(line_tbl_index).header_id;
12703: End If;