DBA Data[Home] [Help]

APPS.OE_HEADER_ADJ_UTIL dependencies on OE_ORDER_CACHE

Line 1166: OE_Order_Cache.Load_Order_Header(p_header_id);

1162: If l_debug_level > 0 Then
1163: oe_debug_pub.add('in log_request_for_margin');
1164: oe_debug_pub.add('p_header_id : '||p_header_id);
1165: End If;
1166: OE_Order_Cache.Load_Order_Header(p_header_id);
1167: l_booked_flag := OE_ORDER_CACHE.g_header_rec.booked_flag;
1168: oe_debug_pub.add('l_booked_flag : '||l_booked_flag);
1169: /*
1170: select booked_flag into l_booked_flag from oe_order_headers_all

Line 1167: l_booked_flag := OE_ORDER_CACHE.g_header_rec.booked_flag;

1163: oe_debug_pub.add('in log_request_for_margin');
1164: oe_debug_pub.add('p_header_id : '||p_header_id);
1165: End If;
1166: OE_Order_Cache.Load_Order_Header(p_header_id);
1167: l_booked_flag := OE_ORDER_CACHE.g_header_rec.booked_flag;
1168: oe_debug_pub.add('l_booked_flag : '||l_booked_flag);
1169: /*
1170: select booked_flag into l_booked_flag from oe_order_headers_all
1171: where header_id = p_header_id;

Line 4625: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN

4621: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y')
4622: AND p_x_header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' THEN
4623: BEGIN
4624:
4625: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
4626:
4627: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4628: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4629: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)

Line 4627: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)

4623: BEGIN
4624:
4625: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
4626:
4627: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4628: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4629: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
4630: THEN
4631: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;

Line 4628: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)

4624:
4625: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
4626:
4627: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4628: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4629: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
4630: THEN
4631: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
4632: END IF ;

Line 4629: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)

4625: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
4626:
4627: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4628: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4629: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
4630: THEN
4631: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
4632: END IF ;
4633:

Line 4631: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;

4627: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
4628: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
4629: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
4630: THEN
4631: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
4632: END IF ;
4633:
4634: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4635: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

Line 4634: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN

4630: THEN
4631: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
4632: END IF ;
4633:
4634: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4635: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
4636: l_tax_calculation_event_code := 0;
4637: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
4638: l_tax_calculation_event_code := 1;

Line 4635: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

4631: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
4632: END IF ;
4633:
4634: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4635: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
4636: l_tax_calculation_event_code := 0;
4637: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
4638: l_tax_calculation_event_code := 1;
4639: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then

Line 4637: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then

4633:
4634: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
4635: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
4636: l_tax_calculation_event_code := 0;
4637: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
4638: l_tax_calculation_event_code := 1;
4639: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
4640: l_tax_calculation_event_code := 2;
4641: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then

Line 4639: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then

4635: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
4636: l_tax_calculation_event_code := 0;
4637: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
4638: l_tax_calculation_event_code := 1;
4639: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
4640: l_tax_calculation_event_code := 2;
4641: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
4642: l_tax_calculation_event_code := 3;
4643: else

Line 4641: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then

4637: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
4638: l_tax_calculation_event_code := 1;
4639: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
4640: l_tax_calculation_event_code := 2;
4641: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
4642: l_tax_calculation_event_code := 3;
4643: else
4644: l_tax_calculation_event_code := -1;
4645: end if ;