eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_PROCESS_LINE dependencies on OE_BULK_CACHE

Line 23: oe_debug_pub.add( 'start Date :'|| OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).start_date_active);

19: l_c_index NUMBER;
20: BEGIN
21: oe_debug_pub.add( ' Enter Validate_Line_Type',1);
22: oe_debug_pub.add( ' Order Date :' || to_char(p_ordered_date));
23: oe_debug_pub.add( 'start Date :'|| OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).start_date_active);
24: oe_debug_pub.add( 'end Date :'|| OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).end_date_active);
25: l_c_index := OE_BULK_CACHE.Load_Line_Type
26: (p_key => p_line_type_id);
27:

Line 24: oe_debug_pub.add( 'end Date :'|| OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).end_date_active);

20: BEGIN
21: oe_debug_pub.add( ' Enter Validate_Line_Type',1);
22: oe_debug_pub.add( ' Order Date :' || to_char(p_ordered_date));
23: oe_debug_pub.add( 'start Date :'|| OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).start_date_active);
24: oe_debug_pub.add( 'end Date :'|| OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).end_date_active);
25: l_c_index := OE_BULK_CACHE.Load_Line_Type
26: (p_key => p_line_type_id);
27:
28: IF p_ordered_date BETWEEN

Line 25: l_c_index := OE_BULK_CACHE.Load_Line_Type

21: oe_debug_pub.add( ' Enter Validate_Line_Type',1);
22: oe_debug_pub.add( ' Order Date :' || to_char(p_ordered_date));
23: oe_debug_pub.add( 'start Date :'|| OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).start_date_active);
24: oe_debug_pub.add( 'end Date :'|| OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).end_date_active);
25: l_c_index := OE_BULK_CACHE.Load_Line_Type
26: (p_key => p_line_type_id);
27:
28: IF p_ordered_date BETWEEN
29: nvl(OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).start_date_active,sysdate)

Line 29: nvl(OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).start_date_active,sysdate)

25: l_c_index := OE_BULK_CACHE.Load_Line_Type
26: (p_key => p_line_type_id);
27:
28: IF p_ordered_date BETWEEN
29: nvl(OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).start_date_active,sysdate)
30: AND nvl(OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).end_date_active,sysdate)
31: THEN
32: oe_debug_pub.add( 'Line Type Valid');
33: RETURN TRUE;

Line 30: AND nvl(OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).end_date_active,sysdate)

26: (p_key => p_line_type_id);
27:
28: IF p_ordered_date BETWEEN
29: nvl(OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).start_date_active,sysdate)
30: AND nvl(OE_BULK_CACHE.G_LINE_TYPE_TBL(p_line_type_id).end_date_active,sysdate)
31: THEN
32: oe_debug_pub.add( 'Line Type Valid');
33: RETURN TRUE;
34: ELSE

Line 309: l_c_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_index));

305: -- Solution to 2: Do Not worry - Reservations NOT supported in BULK mode.
306:
307: -- No need to do ATO validations: ATOs not supported in BULK mode
308: -- ADDING code
309: l_c_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_index));
310: IF (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FOUR'
311: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FIVE') AND
312: (p_line_rec.item_type_code(p_index) <> 'STANDARD'
313: OR p_line_rec.ato_line_id(p_index) is not null) THEN

Line 310: IF (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FOUR'

306:
307: -- No need to do ATO validations: ATOs not supported in BULK mode
308: -- ADDING code
309: l_c_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_index));
310: IF (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FOUR'
311: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FIVE') AND
312: (p_line_rec.item_type_code(p_index) <> 'STANDARD'
313: OR p_line_rec.ato_line_id(p_index) is not null) THEN
314:

Line 311: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FIVE') AND

307: -- No need to do ATO validations: ATOs not supported in BULK mode
308: -- ADDING code
309: l_c_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_index));
310: IF (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FOUR'
311: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FIVE') AND
312: (p_line_rec.item_type_code(p_index) <> 'STANDARD'
313: OR p_line_rec.ato_line_id(p_index) is not null) THEN
314:
315: IF l_debug_level > 0 THEN

Line 358: l_c_index := OE_BULK_CACHE.Load_Item

354: fnd_profile.value('INV_CTP') = '5'
355: THEN
356:
357: l_org_id := nvl(p_line_rec.ship_from_org_id(p_index), OE_BULK_ORDER_PVT.G_ITEM_ORG);
358: l_c_index := OE_BULK_CACHE.Load_Item
359: (p_key1 => p_line_rec.inventory_item_id(p_index)
360: ,p_key2 => l_org_id
361: ,p_default_attributes => 'Y');
362:

Line 363: l_make_buy := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).planning_make_buy_code;

359: (p_key1 => p_line_rec.inventory_item_id(p_index)
360: ,p_key2 => l_org_id
361: ,p_default_attributes => 'Y');
362:
363: l_make_buy := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).planning_make_buy_code;
364:
365: IF l_debug_level > 0 THEN
366: oe_debug_pub.add( 'L_MAKE_BUY' || L_MAKE_BUY , 2 ) ;
367: END IF;

Line 1115: l_c_index := OE_Bulk_Cache.Load_Item(p_inventory_item_id,null);

1111:
1112: -- If inventory item is not assigned to the item validation org,
1113: -- cache api will raise no_data_found and this validation function
1114: -- will return FALSE.
1115: l_c_index := OE_Bulk_Cache.Load_Item(p_inventory_item_id,null);
1116:
1117: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
1118:
1119: /* Bug 1741158 chhung modify BEGIN */

Line 1126: IF OE_Bulk_Cache.G_ITEM_TBL(l_c_index).internal_order_enabled_flag

1122: IF p_source_document_type_id = 10
1123: THEN
1124: /* for Internal Orders */
1125: /* Internal Orders only support standard item */
1126: IF OE_Bulk_Cache.G_ITEM_TBL(l_c_index).internal_order_enabled_flag
1127: <> 'Y'
1128: THEN
1129: RETURN FALSE;
1130: END IF;

Line 1142: IF OE_Bulk_Cache.G_ITEM_TBL(l_c_index).customer_order_enabled_flag

1138: nvl(p_top_model_line_id, -1) <> p_line_id)
1139: THEN
1140: RETURN TRUE;
1141: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1142: IF OE_Bulk_Cache.G_ITEM_TBL(l_c_index).customer_order_enabled_flag
1143: <> 'Y'
1144: THEN
1145: RETURN FALSE;
1146: END IF;

Line 1404: l_c_index := OE_BULK_CACHE.Load_Item

1400: THEN
1401:
1402: BEGIN
1403:
1404: l_c_index := OE_BULK_CACHE.Load_Item
1405: (p_key1 => p_line_rec.inventory_item_id(p_index)
1406: ,p_key2 => p_line_rec.ship_from_org_id(p_index)
1407: ,p_default_attributes => 'Y');
1408:

Line 1410: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).accounting_rule_id);

1406: ,p_key2 => p_line_rec.ship_from_org_id(p_index)
1407: ,p_default_attributes => 'Y');
1408:
1409: p_line_rec.accounting_rule_id(p_index) := nvl(p_line_rec.accounting_rule_id(p_index)
1410: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).accounting_rule_id);
1411: p_line_rec.invoicing_rule_id(p_index) := nvl(p_line_rec.invoicing_rule_id(p_index)
1412: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).invoicing_rule_id);
1413: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1414: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);

Line 1412: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).invoicing_rule_id);

1408:
1409: p_line_rec.accounting_rule_id(p_index) := nvl(p_line_rec.accounting_rule_id(p_index)
1410: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).accounting_rule_id);
1411: p_line_rec.invoicing_rule_id(p_index) := nvl(p_line_rec.invoicing_rule_id(p_index)
1412: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).invoicing_rule_id);
1413: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1414: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);
1415: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1416: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);

Line 1414: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);

1410: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).accounting_rule_id);
1411: p_line_rec.invoicing_rule_id(p_index) := nvl(p_line_rec.invoicing_rule_id(p_index)
1412: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).invoicing_rule_id);
1413: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1414: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);
1415: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1416: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);
1417: p_line_rec.order_quantity_uom(p_index) := nvl(p_line_rec.order_quantity_uom(p_index)
1418: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).primary_uom_code);

Line 1416: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);

1412: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).invoicing_rule_id);
1413: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1414: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);
1415: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1416: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);
1417: p_line_rec.order_quantity_uom(p_index) := nvl(p_line_rec.order_quantity_uom(p_index)
1418: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).primary_uom_code);
1419: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1420: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).default_shipping_org);

Line 1418: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).primary_uom_code);

1414: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);
1415: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1416: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);
1417: p_line_rec.order_quantity_uom(p_index) := nvl(p_line_rec.order_quantity_uom(p_index)
1418: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).primary_uom_code);
1419: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1420: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).default_shipping_org);
1421:
1422: -- Invalid item - error message populated during validation

Line 1420: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).default_shipping_org);

1416: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);
1417: p_line_rec.order_quantity_uom(p_index) := nvl(p_line_rec.order_quantity_uom(p_index)
1418: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).primary_uom_code);
1419: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1420: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).default_shipping_org);
1421:
1422: -- Invalid item - error message populated during validation
1423: EXCEPTION
1424: WHEN NO_DATA_FOUND THEN

Line 1450: l_c_index := OE_BULK_CACHE.Load_Ship_To

1446: THEN
1447:
1448: BEGIN
1449:
1450: l_c_index := OE_BULK_CACHE.Load_Ship_To
1451: (p_key => p_line_rec.ship_to_org_id(p_index)
1452: ,p_default_attributes => 'Y');
1453:
1454: p_line_rec.fob_point_code(p_index) := nvl(p_line_rec.fob_point_code(p_index)

Line 1455: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).fob_point_code);

1451: (p_key => p_line_rec.ship_to_org_id(p_index)
1452: ,p_default_attributes => 'Y');
1453:
1454: p_line_rec.fob_point_code(p_index) := nvl(p_line_rec.fob_point_code(p_index)
1455: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).fob_point_code);
1456: p_line_rec.freight_terms_code(p_index) := nvl(p_line_rec.freight_terms_code(p_index)
1457: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).freight_terms_code);
1458: p_line_rec.shipping_method_code(p_index) := nvl(p_line_rec.shipping_method_code(p_index)
1459: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);

Line 1457: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).freight_terms_code);

1453:
1454: p_line_rec.fob_point_code(p_index) := nvl(p_line_rec.fob_point_code(p_index)
1455: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).fob_point_code);
1456: p_line_rec.freight_terms_code(p_index) := nvl(p_line_rec.freight_terms_code(p_index)
1457: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).freight_terms_code);
1458: p_line_rec.shipping_method_code(p_index) := nvl(p_line_rec.shipping_method_code(p_index)
1459: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);
1460: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1461: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);

Line 1459: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);

1455: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).fob_point_code);
1456: p_line_rec.freight_terms_code(p_index) := nvl(p_line_rec.freight_terms_code(p_index)
1457: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).freight_terms_code);
1458: p_line_rec.shipping_method_code(p_index) := nvl(p_line_rec.shipping_method_code(p_index)
1459: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);
1460: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1461: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);
1462: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1463: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);

Line 1461: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);

1457: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).freight_terms_code);
1458: p_line_rec.shipping_method_code(p_index) := nvl(p_line_rec.shipping_method_code(p_index)
1459: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);
1460: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1461: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);
1462: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1463: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);
1464: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1465: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);

Line 1463: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);

1459: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);
1460: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1461: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);
1462: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1463: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);
1464: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1465: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);
1466: p_line_rec.item_identifier_type(p_index) := nvl(p_line_rec.item_identifier_type(p_index)
1467: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).item_identifier_type);

Line 1465: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);

1461: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);
1462: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1463: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);
1464: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1465: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);
1466: p_line_rec.item_identifier_type(p_index) := nvl(p_line_rec.item_identifier_type(p_index)
1467: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).item_identifier_type);
1468: p_line_rec.demand_class_code(p_index) := nvl(p_line_rec.demand_class_code(p_index)
1469: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).demand_class_code);

Line 1467: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).item_identifier_type);

1463: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);
1464: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1465: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);
1466: p_line_rec.item_identifier_type(p_index) := nvl(p_line_rec.item_identifier_type(p_index)
1467: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).item_identifier_type);
1468: p_line_rec.demand_class_code(p_index) := nvl(p_line_rec.demand_class_code(p_index)
1469: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).demand_class_code);
1470:
1471: -- Invalid ship to - error message populated during validation

Line 1469: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).demand_class_code);

1465: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);
1466: p_line_rec.item_identifier_type(p_index) := nvl(p_line_rec.item_identifier_type(p_index)
1467: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).item_identifier_type);
1468: p_line_rec.demand_class_code(p_index) := nvl(p_line_rec.demand_class_code(p_index)
1469: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).demand_class_code);
1470:
1471: -- Invalid ship to - error message populated during validation
1472: EXCEPTION
1473: WHEN NO_DATA_FOUND THEN

Line 1485: l_c_index := OE_Bulk_Cache.Load_Order_Type

1481:
1482: -- Default line type from order type
1483:
1484: IF p_line_rec.line_type_id(p_index) IS NULL THEN
1485: l_c_index := OE_Bulk_Cache.Load_Order_Type
1486: (p_key => OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index)
1487: ,p_default_attributes => 'Y'
1488: );
1489: p_line_rec.line_type_id(p_index) :=

Line 1490: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).default_outbound_line_type_id;

1486: (p_key => OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index)
1487: ,p_default_attributes => 'Y'
1488: );
1489: p_line_rec.line_type_id(p_index) :=
1490: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).default_outbound_line_type_id;
1491: END IF;
1492:
1493: -- Default remaining attributes from Order Header
1494:

Line 1765: l_c_index := OE_BULK_CACHE.Load_Item

1761: oe_debug_pub.add( 'Populate_Internal_Fields 3' ) ;
1762: IF p_line_rec.inventory_item_id(p_index) IS NOT NULL THEN
1763:
1764: l_inventory_item_id := p_line_rec.inventory_item_id(p_index);
1765: l_c_index := OE_BULK_CACHE.Load_Item
1766: (p_key1 => l_inventory_item_id
1767: ,p_key2 => p_line_rec.ship_from_org_id(p_index)
1768: );
1769: oe_debug_pub.add( 'Populate_Internal_Fields 3a' ) ;

Line 1775: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4

1771: -- VAlidate bom item type
1772: IF p_process_configurations = 'Y' THEN
1773: oe_debug_pub.add( 'Populate_Internal_Fields a' ) ;
1774: -- Error if unsupported Item Type for Bulk Mode
1775: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1776: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1777: THEN -- Service item type
1778: oe_debug_pub.add( 'Populate_Internal_Fields ab' ) ;
1779: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');

Line 1776: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')

1772: IF p_process_configurations = 'Y' THEN
1773: oe_debug_pub.add( 'Populate_Internal_Fields a' ) ;
1774: -- Error if unsupported Item Type for Bulk Mode
1775: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1776: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1777: THEN -- Service item type
1778: oe_debug_pub.add( 'Populate_Internal_Fields ab' ) ;
1779: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1780: OE_BULK_MSG_PUB.Add('Y', 'ERROR');

Line 1787: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND

1783: p_line_rec.lock_control(p_index) := -98;
1784: ELSE
1785: oe_debug_pub.add( 'Populate_Internal_Fields bc' ) ;
1786: --bug 3798477
1787: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND
1788: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1789: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1790: OR -- 4282392
1791: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND

Line 1788: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND

1784: ELSE
1785: oe_debug_pub.add( 'Populate_Internal_Fields bc' ) ;
1786: --bug 3798477
1787: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND
1788: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1789: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1790: OR -- 4282392
1791: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1792: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')

Line 1789: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )

1785: oe_debug_pub.add( 'Populate_Internal_Fields bc' ) ;
1786: --bug 3798477
1787: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND
1788: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1789: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1790: OR -- 4282392
1791: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1792: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')
1793: THEN

Line 1791: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND

1787: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND
1788: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1789: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1790: OR -- 4282392
1791: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1792: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')
1793: THEN
1794: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;
1795: oe_debug_pub.add( 'Populate_Internal_Fields b' ) ;

Line 1792: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')

1788: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1789: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1790: OR -- 4282392
1791: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1792: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')
1793: THEN
1794: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;
1795: oe_debug_pub.add( 'Populate_Internal_Fields b' ) ;
1796: END IF;

Line 1806: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 1 AND

1802:
1803:
1804: IF p_line_rec.item_type_code(p_index) IS NULL THEN
1805:
1806: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 1 AND
1807: nvl(p_line_rec.top_model_line_id(p_index), -1)
1808: = p_line_rec.line_id(p_index)
1809: THEN
1810: p_line_rec.item_type_code(p_index) := 'MODEL';

Line 1815: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 1 AND

1811: END IF;
1812:
1813: oe_debug_pub.add( 'Populate_Internal_Fields aa' ) ;
1814:
1815: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 1 AND
1816: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND
1817: nvl(p_line_rec.top_model_line_id(p_index), -1) <> p_line_rec.line_id(p_index)
1818: THEN
1819:

Line 1816: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND

1812:
1813: oe_debug_pub.add( 'Populate_Internal_Fields aa' ) ;
1814:
1815: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 1 AND
1816: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND
1817: nvl(p_line_rec.top_model_line_id(p_index), -1) <> p_line_rec.line_id(p_index)
1818: THEN
1819:
1820: p_line_rec.item_type_code(p_index) := 'CLASS';

Line 1823: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 2 THEN

1819:
1820: p_line_rec.item_type_code(p_index) := 'CLASS';
1821: END IF;
1822:
1823: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 2 THEN
1824: p_line_rec.item_type_code(p_index) := 'CLASS';
1825: END IF;
1826:
1827: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN

Line 1827: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN

1823: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 2 THEN
1824: p_line_rec.item_type_code(p_index) := 'CLASS';
1825: END IF;
1826:
1827: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN
1828:
1829: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN
1830: p_line_rec.item_type_code(p_index) := 'KIT';
1831: ELSIF p_line_rec.top_model_line_id(p_index) IS NOT NULL THEN

Line 1829: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN

1825: END IF;
1826:
1827: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN
1828:
1829: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN
1830: p_line_rec.item_type_code(p_index) := 'KIT';
1831: ELSIF p_line_rec.top_model_line_id(p_index) IS NOT NULL THEN
1832: p_line_rec.item_type_code(p_index) := 'OPTION';
1833: oe_debug_pub.add( 'Populate_Internal_Fields bb' ) ;

Line 1843: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 AND

1839:
1840: END IF; -- item_type_code IS NULL
1841:
1842: -- Logic before config support change
1843: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 AND
1844: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y'
1845: THEN
1846: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1847: p_line_rec.top_model_line_id(p_index) := p_line_rec.line_id(p_index);

Line 1844: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y'

1840: END IF; -- item_type_code IS NULL
1841:
1842: -- Logic before config support change
1843: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 AND
1844: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y'
1845: THEN
1846: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1847: p_line_rec.top_model_line_id(p_index) := p_line_rec.line_id(p_index);
1848: oe_debug_pub.add( 'Populate_Internal_Fields cc' ) ;

Line 1850: -- := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_model_complete_flag;

1846: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1847: p_line_rec.top_model_line_id(p_index) := p_line_rec.line_id(p_index);
1848: oe_debug_pub.add( 'Populate_Internal_Fields cc' ) ;
1849: --p_line_rec.ship_model_complete_flag(p_index)
1850: -- := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_model_complete_flag;
1851: p_line_rec.ship_tolerance_above(p_index) := 0;
1852: p_line_rec.ship_tolerance_below(p_index) := 0;
1853: END IF; --bom_item_type = 4
1854:

Line 1858: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND

1854:
1855: -- Set ato_line_id on ato_item
1856: oe_debug_pub.add( 'Populate_Internal_Fields dd' ) ;
1857: IF p_line_rec.item_type_code(p_index) IN ('OPTION', 'STANDARD') AND
1858: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND
1859: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).build_in_wip_flag, 'N') = 'Y'
1860: THEN
1861: p_line_rec.ato_line_id(p_index) := p_line_rec.line_id(p_index);
1862: END IF;

Line 1859: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).build_in_wip_flag, 'N') = 'Y'

1855: -- Set ato_line_id on ato_item
1856: oe_debug_pub.add( 'Populate_Internal_Fields dd' ) ;
1857: IF p_line_rec.item_type_code(p_index) IN ('OPTION', 'STANDARD') AND
1858: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND
1859: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).build_in_wip_flag, 'N') = 'Y'
1860: THEN
1861: p_line_rec.ato_line_id(p_index) := p_line_rec.line_id(p_index);
1862: END IF;
1863: oe_debug_pub.add( 'Populate_Internal_Fields ee' ) ;

Line 1893: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_model_complete_flag;

1889: END IF;
1890: oe_debug_pub.add( 'Populate_Internal_Fields ii' ) ;
1891: -- set ship_model_complete_flag
1892: p_line_rec.ship_model_complete_flag(p_index) :=
1893: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_model_complete_flag;
1894: END IF; -- supported items
1895:
1896: ELSE -- p_process_configuration = 'N'
1897: IF l_debug_level > 0 THEN

Line 1906: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type IN (1,2)

1902:
1903: -- Error if unsupported Item Type for Bulk Mode
1904:
1905: IF -- Model and Class Items
1906: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type IN (1,2)
1907: -- Service Items
1908: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1909: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1910: -- ATO Items

Line 1908: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4

1904:
1905: IF -- Model and Class Items
1906: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type IN (1,2)
1907: -- Service Items
1908: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1909: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1910: -- ATO Items
1911: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).replenish_to_order_flag = 'Y')
1912: THEN

Line 1909: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')

1905: IF -- Model and Class Items
1906: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type IN (1,2)
1907: -- Service Items
1908: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1909: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1910: -- ATO Items
1911: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).replenish_to_order_flag = 'Y')
1912: THEN
1913: oe_debug_pub.add( 'Populate_Internal_Fields 4a' ) ;

Line 1911: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).replenish_to_order_flag = 'Y')

1907: -- Service Items
1908: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1909: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1910: -- ATO Items
1911: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).replenish_to_order_flag = 'Y')
1912: THEN
1913: oe_debug_pub.add( 'Populate_Internal_Fields 4a' ) ;
1914: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1915: OE_BULK_MSG_PUB.Add('Y', 'ERROR');

Line 1923: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND -- INVCONV

1919:
1920: ELSE
1921: oe_debug_pub.add( 'Populate_Internal_Fields 5a' ) ;
1922: --bug 3798477
1923: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND -- INVCONV
1924: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1925: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1926: OR -- 4282392
1927: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND

Line 1924: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND

1920: ELSE
1921: oe_debug_pub.add( 'Populate_Internal_Fields 5a' ) ;
1922: --bug 3798477
1923: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND -- INVCONV
1924: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1925: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1926: OR -- 4282392
1927: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1928: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )

Line 1925: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')

1921: oe_debug_pub.add( 'Populate_Internal_Fields 5a' ) ;
1922: --bug 3798477
1923: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND -- INVCONV
1924: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1925: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1926: OR -- 4282392
1927: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1928: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )
1929:

Line 1927: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND

1923: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND -- INVCONV
1924: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1925: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1926: OR -- 4282392
1927: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1928: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )
1929:
1930: THEN
1931: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;

Line 1928: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )

1924: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1925: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1926: OR -- 4282392
1927: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1928: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )
1929:
1930: THEN
1931: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;
1932: END IF;

Line 1936: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN

1932: END IF;
1933: --bug 3798477
1934: -- Item Type can be STANDARD or KIT in BULK mode
1935:
1936: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN
1937: oe_debug_pub.add( 'Populate_Internal_Fields 6a' ) ;
1938: -- KIT Item
1939: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN
1940: oe_debug_pub.add( 'Populate_Internal_Fields 7a' ) ;

Line 1939: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN

1935:
1936: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN
1937: oe_debug_pub.add( 'Populate_Internal_Fields 6a' ) ;
1938: -- KIT Item
1939: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN
1940: oe_debug_pub.add( 'Populate_Internal_Fields 7a' ) ;
1941: p_line_rec.item_type_code(p_index) := OE_GLOBALS.G_ITEM_KIT;
1942: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1943: p_line_rec.top_model_line_id(p_index)

Line 1946: := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_model_complete_flag;

1942: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1943: p_line_rec.top_model_line_id(p_index)
1944: := p_line_rec.line_id(p_index);
1945: p_line_rec.ship_model_complete_flag(p_index)
1946: := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_model_complete_flag;
1947:
1948: p_line_rec.ship_tolerance_above(p_index) := 0;
1949: p_line_rec.ship_tolerance_below(p_index) := 0;
1950:

Line 1958: := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).shippable_item_flag;

1954: END IF;
1955: END IF;
1956: oe_debug_pub.add( 'Populate_Internal_Fields 8a' ) ;
1957: p_line_rec.shippable_flag(p_index)
1958: := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).shippable_item_flag;
1959: oe_debug_pub.add( 'Populate_Internal_Fields 9a' ) ;
1960: END IF;
1961:
1962: oe_debug_pub.add( 'Populate_Internal_Fields 4' ) ;

Line 1971: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' -- INVCONV --

1967: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1968: -- INVCONV take out defaulting for grade as normal defaulting takes place.
1969:
1970:
1971: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' -- INVCONV --
1972: THEN
1973: IF l_debug_level > 0 THEN
1974: oe_debug_pub.add( 'about to call CALL calculate_dual_quantity ' ) ;
1975: END IF;

Line 1980: ,p_dualum_ind => OE_BULK_CACHE.G_ITEM_TBL(l_c_index).secondary_default_ind

1976: oe_debug_pub.add( 'Populate_Internal_Fields 5' ) ;
1977: calculate_dual_quantity(
1978: p_line_rec => p_line_rec
1979: ,p_index => p_index
1980: ,p_dualum_ind => OE_BULK_CACHE.G_ITEM_TBL(l_c_index).secondary_default_ind
1981: ,p_x_return_status => l_return_code
1982: );
1983: IF l_debug_level > 0 THEN
1984: oe_debug_pub.add( 'out of calculate_dual_quantity 1 ' ) ;

Line 1999: END IF; -- IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index)..tracking_quantity_ind == 'PS' -- INVCONV

1995: oe_debug_pub.add( 'Populate_Internal_Fields 6' ) ;
1996: IF l_debug_level > 0 THEN
1997: oe_debug_pub.add( 'out of calculate_dual_quantity 2 ' ) ;
1998: END IF;
1999: END IF; -- IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index)..tracking_quantity_ind == 'PS' -- INVCONV
2000:
2001: --ER#14763609 Start
2002: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS')
2003: THEN

Line 2002: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS')

1998: END IF;
1999: END IF; -- IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index)..tracking_quantity_ind == 'PS' -- INVCONV
2000:
2001: --ER#14763609 Start
2002: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS')
2003: THEN
2004: l_line_fb_rec.line_id := p_line_rec.line_id(p_index) ;
2005: l_line_fb_rec.line_category_code := p_line_rec.line_category_code(p_index) ;
2006: l_line_fb_rec.return_context := p_line_rec.return_context(p_index) ;

Line 2042: l_c_index := OE_BULK_CACHE.Load_Line_Type

2038:
2039: -- Checks based on line type
2040: BEGIN
2041:
2042: l_c_index := OE_BULK_CACHE.Load_Line_Type
2043: (p_key => p_line_rec.line_type_id(p_index));
2044:
2045: l_d_index := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index));
2046:

Line 2045: l_d_index := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index));

2041:
2042: l_c_index := OE_BULK_CACHE.Load_Line_Type
2043: (p_key => p_line_rec.line_type_id(p_index));
2044:
2045: l_d_index := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index));
2046:
2047: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).order_category_code
2048: <> 'ORDER'
2049: THEN

Line 2047: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).order_category_code

2043: (p_key => p_line_rec.line_type_id(p_index));
2044:
2045: l_d_index := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index));
2046:
2047: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).order_category_code
2048: <> 'ORDER'
2049: THEN
2050: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');
2051: OE_BULK_MSG_PUB.Add('Y', 'ERROR');

Line 2059: OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag )

2055: END IF;
2056:
2057: IF l_debug_level > 0 THEN
2058: oe_debug_pub.add( 'tax_calculation_flag = '||
2059: OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag )
2060: ;
2061: oe_debug_pub.add( 'tax_calculation_event = '||
2062: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event
2063: ) ;

Line 2062: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event

2058: oe_debug_pub.add( 'tax_calculation_flag = '||
2059: OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag )
2060: ;
2061: oe_debug_pub.add( 'tax_calculation_event = '||
2062: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event
2063: ) ;
2064: oe_debug_pub.add( 'p_process_tax = '|| p_process_tax ) ;
2065: END IF;
2066:

Line 2070: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag = 'Y'

2066:
2067:
2068: /*--commented for bug 7685103 .We will still import the lines ,tax shall be calculated later from UI
2069:
2070: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag = 'Y'
2071: AND ((OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event NOT IN ( 'INVOICING' , 'SHIPPING' ))
2072: OR (OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event IS NULL))
2073: AND NVL(p_process_tax,'N') <> 'Y'
2074: THEN

Line 2071: AND ((OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event NOT IN ( 'INVOICING' , 'SHIPPING' ))

2067:
2068: /*--commented for bug 7685103 .We will still import the lines ,tax shall be calculated later from UI
2069:
2070: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag = 'Y'
2071: AND ((OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event NOT IN ( 'INVOICING' , 'SHIPPING' ))
2072: OR (OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event IS NULL))
2073: AND NVL(p_process_tax,'N') <> 'Y'
2074: THEN
2075: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_TAX_CAL');

Line 2072: OR (OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event IS NULL))

2068: /*--commented for bug 7685103 .We will still import the lines ,tax shall be calculated later from UI
2069:
2070: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag = 'Y'
2071: AND ((OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event NOT IN ( 'INVOICING' , 'SHIPPING' ))
2072: OR (OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event IS NULL))
2073: AND NVL(p_process_tax,'N') <> 'Y'
2074: THEN
2075: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_TAX_CAL');
2076: OE_BULK_MSG_PUB.Add('Y', 'ERROR');

Line 2789: l_c_index := OE_BULK_CACHE.Load_Item

2785: -- second process check if cached opm_item_id is NULL OR warehouse is discrete , do not supply process attributes
2786: /* IF p_line_rec.inventory_item_id(l_index) IS NOT NULL THEN
2787:
2788: l_inventory_item_id := p_line_rec.inventory_item_id(l_index);
2789: l_c_index := OE_BULK_CACHE.Load_Item
2790: (p_key1 => l_inventory_item_id
2791: ,p_key2 => p_line_rec.ship_from_org_id(l_index)
2792: );
2793: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL

Line 2793: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL

2789: l_c_index := OE_BULK_CACHE.Load_Item
2790: (p_key1 => l_inventory_item_id
2791: ,p_key2 => p_line_rec.ship_from_org_id(l_index)
2792: );
2793: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL
2794: OR OE_BULK_CACHE.G_ITEM_TBL(l_c_index).process_warehouse_flag <> 'Y' )
2795: THEN
2796: IF (p_line_rec.ordered_quantity_uom2(l_index) IS NOT NULL)
2797: OR

Line 2794: OR OE_BULK_CACHE.G_ITEM_TBL(l_c_index).process_warehouse_flag <> 'Y' )

2790: (p_key1 => l_inventory_item_id
2791: ,p_key2 => p_line_rec.ship_from_org_id(l_index)
2792: );
2793: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL
2794: OR OE_BULK_CACHE.G_ITEM_TBL(l_c_index).process_warehouse_flag <> 'Y' )
2795: THEN
2796: IF (p_line_rec.ordered_quantity_uom2(l_index) IS NOT NULL)
2797: OR
2798: (p_line_rec.ordered_quantity2(l_index) IS NOT NULL)

Line 2809: END IF; -- OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL THEN

2805: END IF;
2806: fnd_message.set_name('ONT','OE_BULK_OPM_NOT_PROCESS');
2807: OE_BULK_MSG_PUB.Add('Y','ERROR');
2808: END IF;
2809: END IF; -- OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL THEN
2810:
2811: END IF; -- p_line_rec.inventory_item_id(p_index) IS NOT NULL THEN
2812:
2813: END IF; -- IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN

Line 4113: l_c_index := OE_Bulk_Cache.Load_Salesrep

4109: x_line_scredit_rec.line_id.extend(1);
4110: x_line_scredit_rec.salesrep_id.extend(1);
4111: x_line_scredit_rec.sales_credit_type_id.extend(1);
4112:
4113: l_c_index := OE_Bulk_Cache.Load_Salesrep
4114: (p_key => p_line_rec.salesrep_id(l_index));
4115:
4116: x_line_scredit_rec.header_id(l_scredit_index)
4117: := p_line_rec.header_id(l_index);

Line 4123: := OE_Bulk_Cache.G_SALESREP_TBL(l_c_index).sales_credit_type_id;

4119: := p_line_rec.line_id(l_index);
4120: x_line_scredit_rec.salesrep_id(l_scredit_index)
4121: := p_line_rec.salesrep_id(l_index);
4122: x_line_scredit_rec.sales_credit_type_id(l_scredit_index)
4123: := OE_Bulk_Cache.G_SALESREP_TBL(l_c_index).sales_credit_type_id;
4124:
4125: l_scredit_index := l_scredit_index + 1;
4126:
4127: END IF;

Line 4232: l_c_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(header_counter));

4228: ---------------------------------------------------------------
4229: -- SCHEDULING VALIDATIONS
4230: ---------------------------------------------------------------
4231: oe_debug_pub.add(' SCHEDULING :');
4232: l_c_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(header_counter));
4233:
4234: IF (OE_BULK_ORDER_PVT.G_AUTO_SCHEDULE = 'Y'
4235: OR OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).auto_scheduling_flag = 'Y'
4236: OR p_line_rec.schedule_ship_date(l_index) IS NOT NULL

Line 4235: OR OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).auto_scheduling_flag = 'Y'

4231: oe_debug_pub.add(' SCHEDULING :');
4232: l_c_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(header_counter));
4233:
4234: IF (OE_BULK_ORDER_PVT.G_AUTO_SCHEDULE = 'Y'
4235: OR OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).auto_scheduling_flag = 'Y'
4236: OR p_line_rec.schedule_ship_date(l_index) IS NOT NULL
4237: OR p_line_rec.schedule_arrival_date(l_index) IS NOT NULL)
4238: AND p_line_rec.source_type_code(l_index) = 'INTERNAL'
4239: AND p_line_rec.lock_control(l_index) <> -99

Line 4251: l_d_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(l_index));

4247: IF l_debug_level > 0 THEN
4248: oe_debug_pub.add( 'SCHEDULING VALIDATIONS - ato scheduling') ;
4249: END IF;
4250:
4251: l_d_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(l_index));
4252: IF ( OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4253: AND l_on_generic_hold )
4254: THEN
4255: -- Add scheduling on hold message

Line 4259: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'ONE'

4255: -- Add scheduling on hold message
4256: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
4257: OE_BULK_MSG_PUB.Add;
4258: ELSE
4259: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'ONE'
4260: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL
4261: AND OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).scheduling_level_code = 'ONE')
4262: THEN
4263: -- Add ATP Only message

Line 4260: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL

4256: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
4257: OE_BULK_MSG_PUB.Add;
4258: ELSE
4259: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'ONE'
4260: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL
4261: AND OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).scheduling_level_code = 'ONE')
4262: THEN
4263: -- Add ATP Only message
4264: FND_MESSAGE.SET_NAME('ONT','OE_ATP_ONLY');

Line 4261: AND OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).scheduling_level_code = 'ONE')

4257: OE_BULK_MSG_PUB.Add;
4258: ELSE
4259: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'ONE'
4260: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL
4261: AND OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).scheduling_level_code = 'ONE')
4262: THEN
4263: -- Add ATP Only message
4264: FND_MESSAGE.SET_NAME('ONT','OE_ATP_ONLY');
4265: OE_BULK_MSG_PUB.Add;

Line 4273: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FOUR'

4269: ,x_return_status => l_return_status);
4270:
4271: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4272:
4273: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FOUR'
4274: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FIVE'
4275: THEN
4276:
4277: IF p_line_rec.ship_from_org_id(l_index) IS NOT NULL THEN

Line 4274: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FIVE'

4270:
4271: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4272:
4273: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FOUR'
4274: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FIVE'
4275: THEN
4276:
4277: IF p_line_rec.ship_from_org_id(l_index) IS NOT NULL THEN
4278: IF p_line_rec.schedule_ship_date(l_index) IS NOT NULL THEN

Line 4379: l_c_index := OE_Bulk_Cache.Load_Ship_To

4375: AND nvl(p_line_rec.lock_control(l_index),0) <> - 99
4376: THEN
4377:
4378: IF p_line_rec.ship_to_org_id(l_index) IS NOT NULL THEN
4379: l_c_index := OE_Bulk_Cache.Load_Ship_To
4380: (p_key => p_line_rec.ship_to_org_id(l_index)
4381: ,p_edi_attributes => 'Y'
4382: );
4383: END IF;

Line 4386: l_c_index := OE_Bulk_Cache.Load_Invoice_To

4382: );
4383: END IF;
4384:
4385: IF p_line_rec.invoice_to_org_id(l_index) IS NOT NULL THEN
4386: l_c_index := OE_Bulk_Cache.Load_Invoice_To
4387: (p_key => p_line_rec.invoice_to_org_id(l_index)
4388: ,p_edi_attributes => 'Y'
4389: );
4390: END IF;

Line 4393: l_c_index := OE_Bulk_Cache.Load_Ship_From

4389: );
4390: END IF;
4391:
4392: IF p_line_rec.ship_from_org_id(l_index) IS NOT NULL THEN
4393: l_c_index := OE_Bulk_Cache.Load_Ship_From
4394: (p_key => p_line_rec.ship_from_org_id(l_index)
4395: );
4396: END IF;
4397: --{Bug 5054618

Line 4400: l_c_index := OE_Bulk_Cache.Load_End_customer

4396: END IF;
4397: --{Bug 5054618
4398: -- added for endcustomer changes
4399: IF p_line_rec.end_customer_id(l_index) IS NOT NULL THEN
4400: l_c_index := OE_Bulk_Cache.Load_End_customer
4401: (p_key => p_line_rec.end_customer_id(l_index)
4402: ,p_edi_attributes => 'Y'
4403: );
4404: END IF;

Line 4407: l_c_index := OE_Bulk_Cache.Load_end_customer_site

4403: );
4404: END IF;
4405:
4406: IF p_line_rec.End_customer_site_use_id(l_index) IS NOT NULL THEN
4407: l_c_index := OE_Bulk_Cache.Load_end_customer_site
4408: (p_key => p_line_rec.end_customer_site_use_id(l_index)
4409: ,p_edi_attributes => 'Y'
4410: );
4411: END IF;

Line 5038: OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_line_index));

5034: l_index NUMBER;
5035: BEGIN
5036:
5037: l_index :=
5038: OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_line_index));
5039:
5040: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
5041: -- Line type is null so get value from order type
5042:

Line 5040: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN

5036:
5037: l_index :=
5038: OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_line_index));
5039:
5040: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
5041: -- Line type is null so get value from order type
5042:
5043: l_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(p_header_index));
5044:

Line 5043: l_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(p_header_index));

5039:
5040: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
5041: -- Line type is null so get value from order type
5042:
5043: l_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(p_header_index));
5044:
5045:
5046: IF OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
5047: -- Get info from profile value

Line 5046: IF OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN

5042:
5043: l_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(p_header_index));
5044:
5045:
5046: IF OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
5047: -- Get info from profile value
5048:
5049: IF G_INV_TRN_TYPE_ID IS NULL THEN
5050: G_INV_TRN_TYPE_ID := FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');

Line 5062: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id;

5058: p_line_rec.cust_trx_type_id(p_line_index) := G_INV_TRN_TYPE_ID;
5059: p_line_rec.tax_calculation_flag(p_line_index) := G_INV_TAX_CALC_FLAG;
5060: END IF;
5061: ELSE
5062: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id;
5063: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).tax_calculation_flag;
5064: END IF;
5065:
5066: ELSE

Line 5063: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).tax_calculation_flag;

5059: p_line_rec.tax_calculation_flag(p_line_index) := G_INV_TAX_CALC_FLAG;
5060: END IF;
5061: ELSE
5062: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id;
5063: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).tax_calculation_flag;
5064: END IF;
5065:
5066: ELSE
5067:

Line 5069: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id;

5065:
5066: ELSE
5067:
5068: -- Take values from line type
5069: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id;
5070: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).tax_calculation_flag;
5071:
5072: END IF;
5073:

Line 5070: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).tax_calculation_flag;

5066: ELSE
5067:
5068: -- Take values from line type
5069: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id;
5070: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).tax_calculation_flag;
5071:
5072: END IF;
5073:
5074: EXCEPTION