DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_PVT dependencies on OE_ORDER_CACHE

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

358: --TaxER start
359: IF NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' then
360: BEGIN
361:
362: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
363:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)

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

360: BEGIN
361:
362: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
363:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;

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

361:
362: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
363:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;

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

362: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
363:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;
370:

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

364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;
370:
371: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

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

367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;
370:
371: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
373: l_tax_calculation_event_code := 0;
374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;

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

368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;
370:
371: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
373: l_tax_calculation_event_code := 0;
374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;
376: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then

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

370:
371: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
373: l_tax_calculation_event_code := 0;
374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;
376: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
377: l_tax_calculation_event_code := 2;
378: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then

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

372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
373: l_tax_calculation_event_code := 0;
374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;
376: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
377: l_tax_calculation_event_code := 2;
378: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
379: l_tax_calculation_event_code := 3;
380: else

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

374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;
376: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
377: l_tax_calculation_event_code := 2;
378: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
379: l_tax_calculation_event_code := 3;
380: else
381: l_tax_calculation_event_code := -1;
382: end if ;