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 284: l_c_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_index));

280: -- Solution to 2: Do Not worry - Reservations NOT supported in BULK mode.
281:
282: -- No need to do ATO validations: ATOs not supported in BULK mode
283: -- ADDING code
284: l_c_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_index));
285: IF (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FOUR'
286: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FIVE') AND
287: (p_line_rec.item_type_code(p_index) <> 'STANDARD'
288: OR p_line_rec.ato_line_id(p_index) is not null) THEN

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

281:
282: -- No need to do ATO validations: ATOs not supported in BULK mode
283: -- ADDING code
284: l_c_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_index));
285: IF (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FOUR'
286: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FIVE') AND
287: (p_line_rec.item_type_code(p_index) <> 'STANDARD'
288: OR p_line_rec.ato_line_id(p_index) is not null) THEN
289:

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

282: -- No need to do ATO validations: ATOs not supported in BULK mode
283: -- ADDING code
284: l_c_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_index));
285: IF (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FOUR'
286: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).scheduling_level_code = 'FIVE') AND
287: (p_line_rec.item_type_code(p_index) <> 'STANDARD'
288: OR p_line_rec.ato_line_id(p_index) is not null) THEN
289:
290: IF l_debug_level > 0 THEN

Line 332: l_c_index := OE_BULK_CACHE.Load_Item

328: fnd_profile.value('INV_CTP') = '5'
329: THEN
330:
331: l_org_id := nvl(p_line_rec.ship_from_org_id(p_index), OE_BULK_ORDER_PVT.G_ITEM_ORG);
332: l_c_index := OE_BULK_CACHE.Load_Item
333: (p_key1 => p_line_rec.inventory_item_id(p_index)
334: ,p_key2 => l_org_id
335: ,p_default_attributes => 'Y');
336:

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

333: (p_key1 => p_line_rec.inventory_item_id(p_index)
334: ,p_key2 => l_org_id
335: ,p_default_attributes => 'Y');
336:
337: l_make_buy := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).planning_make_buy_code;
338:
339: IF l_debug_level > 0 THEN
340: oe_debug_pub.add( 'L_MAKE_BUY' || L_MAKE_BUY , 2 ) ;
341: END IF;

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

1085:
1086: -- If inventory item is not assigned to the item validation org,
1087: -- cache api will raise no_data_found and this validation function
1088: -- will return FALSE.
1089: l_c_index := OE_Bulk_Cache.Load_Item(p_inventory_item_id,null);
1090:
1091: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
1092:
1093: /* Bug 1741158 chhung modify BEGIN */

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

1096: IF p_source_document_type_id = 10
1097: THEN
1098: /* for Internal Orders */
1099: /* Internal Orders only support standard item */
1100: IF OE_Bulk_Cache.G_ITEM_TBL(l_c_index).internal_order_enabled_flag
1101: <> 'Y'
1102: THEN
1103: RETURN FALSE;
1104: END IF;

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

1112: nvl(p_top_model_line_id, -1) <> p_line_id)
1113: THEN
1114: RETURN TRUE;
1115: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1116: IF OE_Bulk_Cache.G_ITEM_TBL(l_c_index).customer_order_enabled_flag
1117: <> 'Y'
1118: THEN
1119: RETURN FALSE;
1120: END IF;

Line 1378: l_c_index := OE_BULK_CACHE.Load_Item

1374: THEN
1375:
1376: BEGIN
1377:
1378: l_c_index := OE_BULK_CACHE.Load_Item
1379: (p_key1 => p_line_rec.inventory_item_id(p_index)
1380: ,p_key2 => p_line_rec.ship_from_org_id(p_index)
1381: ,p_default_attributes => 'Y');
1382:

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

1380: ,p_key2 => p_line_rec.ship_from_org_id(p_index)
1381: ,p_default_attributes => 'Y');
1382:
1383: p_line_rec.accounting_rule_id(p_index) := nvl(p_line_rec.accounting_rule_id(p_index)
1384: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).accounting_rule_id);
1385: p_line_rec.invoicing_rule_id(p_index) := nvl(p_line_rec.invoicing_rule_id(p_index)
1386: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).invoicing_rule_id);
1387: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1388: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);

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

1382:
1383: p_line_rec.accounting_rule_id(p_index) := nvl(p_line_rec.accounting_rule_id(p_index)
1384: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).accounting_rule_id);
1385: p_line_rec.invoicing_rule_id(p_index) := nvl(p_line_rec.invoicing_rule_id(p_index)
1386: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).invoicing_rule_id);
1387: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1388: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);
1389: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1390: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);

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

1384: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).accounting_rule_id);
1385: p_line_rec.invoicing_rule_id(p_index) := nvl(p_line_rec.invoicing_rule_id(p_index)
1386: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).invoicing_rule_id);
1387: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1388: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);
1389: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1390: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);
1391: p_line_rec.order_quantity_uom(p_index) := nvl(p_line_rec.order_quantity_uom(p_index)
1392: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).primary_uom_code);

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

1386: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).invoicing_rule_id);
1387: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1388: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);
1389: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1390: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);
1391: p_line_rec.order_quantity_uom(p_index) := nvl(p_line_rec.order_quantity_uom(p_index)
1392: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).primary_uom_code);
1393: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1394: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).default_shipping_org);

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

1388: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_above);
1389: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1390: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);
1391: p_line_rec.order_quantity_uom(p_index) := nvl(p_line_rec.order_quantity_uom(p_index)
1392: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).primary_uom_code);
1393: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1394: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).default_shipping_org);
1395:
1396: -- Invalid item - error message populated during validation

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

1390: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_tolerance_below);
1391: p_line_rec.order_quantity_uom(p_index) := nvl(p_line_rec.order_quantity_uom(p_index)
1392: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).primary_uom_code);
1393: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1394: ,OE_BULK_CACHE.G_ITEM_TBL(l_c_index).default_shipping_org);
1395:
1396: -- Invalid item - error message populated during validation
1397: EXCEPTION
1398: WHEN NO_DATA_FOUND THEN

Line 1424: l_c_index := OE_BULK_CACHE.Load_Ship_To

1420: THEN
1421:
1422: BEGIN
1423:
1424: l_c_index := OE_BULK_CACHE.Load_Ship_To
1425: (p_key => p_line_rec.ship_to_org_id(p_index)
1426: ,p_default_attributes => 'Y');
1427:
1428: p_line_rec.fob_point_code(p_index) := nvl(p_line_rec.fob_point_code(p_index)

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

1425: (p_key => p_line_rec.ship_to_org_id(p_index)
1426: ,p_default_attributes => 'Y');
1427:
1428: p_line_rec.fob_point_code(p_index) := nvl(p_line_rec.fob_point_code(p_index)
1429: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).fob_point_code);
1430: p_line_rec.freight_terms_code(p_index) := nvl(p_line_rec.freight_terms_code(p_index)
1431: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).freight_terms_code);
1432: p_line_rec.shipping_method_code(p_index) := nvl(p_line_rec.shipping_method_code(p_index)
1433: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);

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

1427:
1428: p_line_rec.fob_point_code(p_index) := nvl(p_line_rec.fob_point_code(p_index)
1429: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).fob_point_code);
1430: p_line_rec.freight_terms_code(p_index) := nvl(p_line_rec.freight_terms_code(p_index)
1431: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).freight_terms_code);
1432: p_line_rec.shipping_method_code(p_index) := nvl(p_line_rec.shipping_method_code(p_index)
1433: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);
1434: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1435: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);

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

1429: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).fob_point_code);
1430: p_line_rec.freight_terms_code(p_index) := nvl(p_line_rec.freight_terms_code(p_index)
1431: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).freight_terms_code);
1432: p_line_rec.shipping_method_code(p_index) := nvl(p_line_rec.shipping_method_code(p_index)
1433: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);
1434: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1435: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);
1436: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1437: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);

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

1431: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).freight_terms_code);
1432: p_line_rec.shipping_method_code(p_index) := nvl(p_line_rec.shipping_method_code(p_index)
1433: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);
1434: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1435: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);
1436: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1437: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);
1438: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1439: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);

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

1433: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).shipping_method_code);
1434: p_line_rec.ship_tolerance_above(p_index) := nvl(p_line_rec.ship_tolerance_above(p_index)
1435: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);
1436: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1437: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);
1438: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1439: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);
1440: p_line_rec.item_identifier_type(p_index) := nvl(p_line_rec.item_identifier_type(p_index)
1441: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).item_identifier_type);

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

1435: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_above);
1436: p_line_rec.ship_tolerance_below(p_index) := nvl(p_line_rec.ship_tolerance_below(p_index)
1437: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);
1438: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1439: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);
1440: p_line_rec.item_identifier_type(p_index) := nvl(p_line_rec.item_identifier_type(p_index)
1441: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).item_identifier_type);
1442: p_line_rec.demand_class_code(p_index) := nvl(p_line_rec.demand_class_code(p_index)
1443: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).demand_class_code);

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

1437: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_tolerance_below);
1438: p_line_rec.ship_from_org_id(p_index) := nvl(p_line_rec.ship_from_org_id(p_index)
1439: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);
1440: p_line_rec.item_identifier_type(p_index) := nvl(p_line_rec.item_identifier_type(p_index)
1441: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).item_identifier_type);
1442: p_line_rec.demand_class_code(p_index) := nvl(p_line_rec.demand_class_code(p_index)
1443: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).demand_class_code);
1444:
1445: -- Invalid ship to - error message populated during validation

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

1439: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).ship_from_org_id);
1440: p_line_rec.item_identifier_type(p_index) := nvl(p_line_rec.item_identifier_type(p_index)
1441: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).item_identifier_type);
1442: p_line_rec.demand_class_code(p_index) := nvl(p_line_rec.demand_class_code(p_index)
1443: ,OE_BULK_CACHE.G_SHIP_TO_TBL(l_c_index).demand_class_code);
1444:
1445: -- Invalid ship to - error message populated during validation
1446: EXCEPTION
1447: WHEN NO_DATA_FOUND THEN

Line 1459: l_c_index := OE_Bulk_Cache.Load_Order_Type

1455:
1456: -- Default line type from order type
1457:
1458: IF p_line_rec.line_type_id(p_index) IS NULL THEN
1459: l_c_index := OE_Bulk_Cache.Load_Order_Type
1460: (p_key => OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index)
1461: ,p_default_attributes => 'Y'
1462: );
1463: p_line_rec.line_type_id(p_index) :=

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

1460: (p_key => OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index)
1461: ,p_default_attributes => 'Y'
1462: );
1463: p_line_rec.line_type_id(p_index) :=
1464: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).default_outbound_line_type_id;
1465: END IF;
1466:
1467: -- Default remaining attributes from Order Header
1468:

Line 1737: l_c_index := OE_BULK_CACHE.Load_Item

1733: oe_debug_pub.add( 'Populate_Internal_Fields 3' ) ;
1734: IF p_line_rec.inventory_item_id(p_index) IS NOT NULL THEN
1735:
1736: l_inventory_item_id := p_line_rec.inventory_item_id(p_index);
1737: l_c_index := OE_BULK_CACHE.Load_Item
1738: (p_key1 => l_inventory_item_id
1739: ,p_key2 => p_line_rec.ship_from_org_id(p_index)
1740: );
1741: oe_debug_pub.add( 'Populate_Internal_Fields 3a' ) ;

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

1743: -- VAlidate bom item type
1744: IF p_process_configurations = 'Y' THEN
1745: oe_debug_pub.add( 'Populate_Internal_Fields a' ) ;
1746: -- Error if unsupported Item Type for Bulk Mode
1747: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1748: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1749: THEN -- Service item type
1750: oe_debug_pub.add( 'Populate_Internal_Fields ab' ) ;
1751: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');

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

1744: IF p_process_configurations = 'Y' THEN
1745: oe_debug_pub.add( 'Populate_Internal_Fields a' ) ;
1746: -- Error if unsupported Item Type for Bulk Mode
1747: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1748: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1749: THEN -- Service item type
1750: oe_debug_pub.add( 'Populate_Internal_Fields ab' ) ;
1751: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1752: OE_BULK_MSG_PUB.Add('Y', 'ERROR');

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

1755: p_line_rec.lock_control(p_index) := -98;
1756: ELSE
1757: oe_debug_pub.add( 'Populate_Internal_Fields bc' ) ;
1758: --bug 3798477
1759: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND
1760: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1761: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1762: OR -- 4282392
1763: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND

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

1756: ELSE
1757: oe_debug_pub.add( 'Populate_Internal_Fields bc' ) ;
1758: --bug 3798477
1759: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND
1760: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1761: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1762: OR -- 4282392
1763: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1764: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')

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

1757: oe_debug_pub.add( 'Populate_Internal_Fields bc' ) ;
1758: --bug 3798477
1759: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND
1760: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1761: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1762: OR -- 4282392
1763: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1764: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')
1765: THEN

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

1759: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND
1760: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1761: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1762: OR -- 4282392
1763: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1764: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')
1765: THEN
1766: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;
1767: oe_debug_pub.add( 'Populate_Internal_Fields b' ) ;

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

1760: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1761: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y' )
1762: OR -- 4282392
1763: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1764: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')
1765: THEN
1766: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;
1767: oe_debug_pub.add( 'Populate_Internal_Fields b' ) ;
1768: END IF;

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

1774:
1775:
1776: IF p_line_rec.item_type_code(p_index) IS NULL THEN
1777:
1778: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 1 AND
1779: nvl(p_line_rec.top_model_line_id(p_index), -1)
1780: = p_line_rec.line_id(p_index)
1781: THEN
1782: p_line_rec.item_type_code(p_index) := 'MODEL';

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

1783: END IF;
1784:
1785: oe_debug_pub.add( 'Populate_Internal_Fields aa' ) ;
1786:
1787: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 1 AND
1788: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND
1789: nvl(p_line_rec.top_model_line_id(p_index), -1) <> p_line_rec.line_id(p_index)
1790: THEN
1791:

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

1784:
1785: oe_debug_pub.add( 'Populate_Internal_Fields aa' ) ;
1786:
1787: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 1 AND
1788: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND
1789: nvl(p_line_rec.top_model_line_id(p_index), -1) <> p_line_rec.line_id(p_index)
1790: THEN
1791:
1792: p_line_rec.item_type_code(p_index) := 'CLASS';

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

1791:
1792: p_line_rec.item_type_code(p_index) := 'CLASS';
1793: END IF;
1794:
1795: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 2 THEN
1796: p_line_rec.item_type_code(p_index) := 'CLASS';
1797: END IF;
1798:
1799: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN

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

1795: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 2 THEN
1796: p_line_rec.item_type_code(p_index) := 'CLASS';
1797: END IF;
1798:
1799: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN
1800:
1801: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN
1802: p_line_rec.item_type_code(p_index) := 'KIT';
1803: ELSIF p_line_rec.top_model_line_id(p_index) IS NOT NULL THEN

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

1797: END IF;
1798:
1799: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN
1800:
1801: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN
1802: p_line_rec.item_type_code(p_index) := 'KIT';
1803: ELSIF p_line_rec.top_model_line_id(p_index) IS NOT NULL THEN
1804: p_line_rec.item_type_code(p_index) := 'OPTION';
1805: oe_debug_pub.add( 'Populate_Internal_Fields bb' ) ;

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

1811:
1812: END IF; -- item_type_code IS NULL
1813:
1814: -- Logic before config support change
1815: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 AND
1816: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y'
1817: THEN
1818: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1819: p_line_rec.top_model_line_id(p_index) := p_line_rec.line_id(p_index);

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

1812: END IF; -- item_type_code IS NULL
1813:
1814: -- Logic before config support change
1815: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 AND
1816: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y'
1817: THEN
1818: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1819: p_line_rec.top_model_line_id(p_index) := p_line_rec.line_id(p_index);
1820: oe_debug_pub.add( 'Populate_Internal_Fields cc' ) ;

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

1818: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1819: p_line_rec.top_model_line_id(p_index) := p_line_rec.line_id(p_index);
1820: oe_debug_pub.add( 'Populate_Internal_Fields cc' ) ;
1821: --p_line_rec.ship_model_complete_flag(p_index)
1822: -- := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_model_complete_flag;
1823: p_line_rec.ship_tolerance_above(p_index) := 0;
1824: p_line_rec.ship_tolerance_below(p_index) := 0;
1825: END IF; --bom_item_type = 4
1826:

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

1826:
1827: -- Set ato_line_id on ato_item
1828: oe_debug_pub.add( 'Populate_Internal_Fields dd' ) ;
1829: IF p_line_rec.item_type_code(p_index) IN ('OPTION', 'STANDARD') AND
1830: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND
1831: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).build_in_wip_flag, 'N') = 'Y'
1832: THEN
1833: p_line_rec.ato_line_id(p_index) := p_line_rec.line_id(p_index);
1834: END IF;

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

1827: -- Set ato_line_id on ato_item
1828: oe_debug_pub.add( 'Populate_Internal_Fields dd' ) ;
1829: IF p_line_rec.item_type_code(p_index) IN ('OPTION', 'STANDARD') AND
1830: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).replenish_to_order_flag, 'N') = 'Y' AND
1831: nvl(OE_BULK_CACHE.G_Item_Tbl(l_c_index).build_in_wip_flag, 'N') = 'Y'
1832: THEN
1833: p_line_rec.ato_line_id(p_index) := p_line_rec.line_id(p_index);
1834: END IF;
1835: oe_debug_pub.add( 'Populate_Internal_Fields ee' ) ;

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

1861: END IF;
1862: oe_debug_pub.add( 'Populate_Internal_Fields ii' ) ;
1863: -- set ship_model_complete_flag
1864: p_line_rec.ship_model_complete_flag(p_index) :=
1865: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_model_complete_flag;
1866: END IF; -- supported items
1867:
1868: ELSE -- p_process_configuration = 'N'
1869: IF l_debug_level > 0 THEN

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

1874:
1875: -- Error if unsupported Item Type for Bulk Mode
1876:
1877: IF -- Model and Class Items
1878: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type IN (1,2)
1879: -- Service Items
1880: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1881: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1882: -- ATO Items

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

1876:
1877: IF -- Model and Class Items
1878: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type IN (1,2)
1879: -- Service Items
1880: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1881: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1882: -- ATO Items
1883: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).replenish_to_order_flag = 'Y')
1884: THEN

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

1877: IF -- Model and Class Items
1878: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type IN (1,2)
1879: -- Service Items
1880: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1881: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1882: -- ATO Items
1883: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).replenish_to_order_flag = 'Y')
1884: THEN
1885: oe_debug_pub.add( 'Populate_Internal_Fields 4a' ) ;

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

1879: -- Service Items
1880: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1881: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1882: -- ATO Items
1883: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).replenish_to_order_flag = 'Y')
1884: THEN
1885: oe_debug_pub.add( 'Populate_Internal_Fields 4a' ) ;
1886: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1887: OE_BULK_MSG_PUB.Add('Y', 'ERROR');

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

1891:
1892: ELSE
1893: oe_debug_pub.add( 'Populate_Internal_Fields 5a' ) ;
1894: --bug 3798477
1895: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND -- INVCONV
1896: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1897: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1898: OR -- 4282392
1899: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND

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

1892: ELSE
1893: oe_debug_pub.add( 'Populate_Internal_Fields 5a' ) ;
1894: --bug 3798477
1895: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND -- INVCONV
1896: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1897: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1898: OR -- 4282392
1899: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1900: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )

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

1893: oe_debug_pub.add( 'Populate_Internal_Fields 5a' ) ;
1894: --bug 3798477
1895: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND -- INVCONV
1896: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1897: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1898: OR -- 4282392
1899: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1900: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )
1901:

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

1895: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' AND -- INVCONV
1896: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1897: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1898: OR -- 4282392
1899: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1900: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )
1901:
1902: THEN
1903: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;

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

1896: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'P' AND
1897: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).wms_enabled_flag = 'Y')
1898: OR -- 4282392
1899: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1900: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )
1901:
1902: THEN
1903: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;
1904: END IF;

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

1904: END IF;
1905: --bug 3798477
1906: -- Item Type can be STANDARD or KIT in BULK mode
1907:
1908: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN
1909: oe_debug_pub.add( 'Populate_Internal_Fields 6a' ) ;
1910: -- KIT Item
1911: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN
1912: oe_debug_pub.add( 'Populate_Internal_Fields 7a' ) ;

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

1907:
1908: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4 THEN
1909: oe_debug_pub.add( 'Populate_Internal_Fields 6a' ) ;
1910: -- KIT Item
1911: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN
1912: oe_debug_pub.add( 'Populate_Internal_Fields 7a' ) ;
1913: p_line_rec.item_type_code(p_index) := OE_GLOBALS.G_ITEM_KIT;
1914: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1915: p_line_rec.top_model_line_id(p_index)

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

1914: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1915: p_line_rec.top_model_line_id(p_index)
1916: := p_line_rec.line_id(p_index);
1917: p_line_rec.ship_model_complete_flag(p_index)
1918: := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ship_model_complete_flag;
1919:
1920: p_line_rec.ship_tolerance_above(p_index) := 0;
1921: p_line_rec.ship_tolerance_below(p_index) := 0;
1922:

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

1926: END IF;
1927: END IF;
1928: oe_debug_pub.add( 'Populate_Internal_Fields 8a' ) ;
1929: p_line_rec.shippable_flag(p_index)
1930: := OE_BULK_CACHE.G_ITEM_TBL(l_c_index).shippable_item_flag;
1931: oe_debug_pub.add( 'Populate_Internal_Fields 9a' ) ;
1932: END IF;
1933:
1934: oe_debug_pub.add( 'Populate_Internal_Fields 4' ) ;

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

1939: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1940: -- INVCONV take out defaulting for grade as normal defaulting takes place.
1941:
1942:
1943: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' -- INVCONV --
1944: THEN
1945: IF l_debug_level > 0 THEN
1946: oe_debug_pub.add( 'about to call CALL calculate_dual_quantity ' ) ;
1947: END IF;

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

1948: oe_debug_pub.add( 'Populate_Internal_Fields 5' ) ;
1949: calculate_dual_quantity(
1950: p_line_rec => p_line_rec
1951: ,p_index => p_index
1952: ,p_dualum_ind => OE_BULK_CACHE.G_ITEM_TBL(l_c_index).secondary_default_ind
1953: ,p_x_return_status => l_return_code
1954: );
1955: IF l_debug_level > 0 THEN
1956: oe_debug_pub.add( 'out of calculate_dual_quantity 1 ' ) ;

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

1967: oe_debug_pub.add( 'Populate_Internal_Fields 6' ) ;
1968: IF l_debug_level > 0 THEN
1969: oe_debug_pub.add( 'out of calculate_dual_quantity 2 ' ) ;
1970: END IF;
1971: END IF; -- IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index)..tracking_quantity_ind == 'PS' -- INVCONV
1972:
1973:
1974: END IF; -- IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1975:

Line 1987: l_c_index := OE_BULK_CACHE.Load_Line_Type

1983:
1984: -- Checks based on line type
1985: BEGIN
1986:
1987: l_c_index := OE_BULK_CACHE.Load_Line_Type
1988: (p_key => p_line_rec.line_type_id(p_index));
1989:
1990: l_d_index := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index));
1991:

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

1986:
1987: l_c_index := OE_BULK_CACHE.Load_Line_Type
1988: (p_key => p_line_rec.line_type_id(p_index));
1989:
1990: l_d_index := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index));
1991:
1992: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).order_category_code
1993: <> 'ORDER'
1994: THEN

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

1988: (p_key => p_line_rec.line_type_id(p_index));
1989:
1990: l_d_index := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index));
1991:
1992: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).order_category_code
1993: <> 'ORDER'
1994: THEN
1995: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');
1996: OE_BULK_MSG_PUB.Add('Y', 'ERROR');

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

2000: END IF;
2001:
2002: IF l_debug_level > 0 THEN
2003: oe_debug_pub.add( 'tax_calculation_flag = '||
2004: OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag )
2005: ;
2006: oe_debug_pub.add( 'tax_calculation_event = '||
2007: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event
2008: ) ;

Line 2007: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event

2003: oe_debug_pub.add( 'tax_calculation_flag = '||
2004: OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag )
2005: ;
2006: oe_debug_pub.add( 'tax_calculation_event = '||
2007: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event
2008: ) ;
2009: oe_debug_pub.add( 'p_process_tax = '|| p_process_tax ) ;
2010: END IF;
2011:

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

2011:
2012:
2013: /*--commented for bug 7685103 .We will still import the lines ,tax shall be calculated later from UI
2014:
2015: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag = 'Y'
2016: AND ((OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event NOT IN ( 'INVOICING' , 'SHIPPING' ))
2017: OR (OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event IS NULL))
2018: AND NVL(p_process_tax,'N') <> 'Y'
2019: THEN

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

2012:
2013: /*--commented for bug 7685103 .We will still import the lines ,tax shall be calculated later from UI
2014:
2015: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag = 'Y'
2016: AND ((OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event NOT IN ( 'INVOICING' , 'SHIPPING' ))
2017: OR (OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event IS NULL))
2018: AND NVL(p_process_tax,'N') <> 'Y'
2019: THEN
2020: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_TAX_CAL');

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

2013: /*--commented for bug 7685103 .We will still import the lines ,tax shall be calculated later from UI
2014:
2015: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).tax_calculation_flag = 'Y'
2016: AND ((OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event NOT IN ( 'INVOICING' , 'SHIPPING' ))
2017: OR (OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event IS NULL))
2018: AND NVL(p_process_tax,'N') <> 'Y'
2019: THEN
2020: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_TAX_CAL');
2021: OE_BULK_MSG_PUB.Add('Y', 'ERROR');

Line 2734: l_c_index := OE_BULK_CACHE.Load_Item

2730: -- second process check if cached opm_item_id is NULL OR warehouse is discrete , do not supply process attributes
2731: /* IF p_line_rec.inventory_item_id(l_index) IS NOT NULL THEN
2732:
2733: l_inventory_item_id := p_line_rec.inventory_item_id(l_index);
2734: l_c_index := OE_BULK_CACHE.Load_Item
2735: (p_key1 => l_inventory_item_id
2736: ,p_key2 => p_line_rec.ship_from_org_id(l_index)
2737: );
2738: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL

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

2734: l_c_index := OE_BULK_CACHE.Load_Item
2735: (p_key1 => l_inventory_item_id
2736: ,p_key2 => p_line_rec.ship_from_org_id(l_index)
2737: );
2738: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL
2739: OR OE_BULK_CACHE.G_ITEM_TBL(l_c_index).process_warehouse_flag <> 'Y' )
2740: THEN
2741: IF (p_line_rec.ordered_quantity_uom2(l_index) IS NOT NULL)
2742: OR

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

2735: (p_key1 => l_inventory_item_id
2736: ,p_key2 => p_line_rec.ship_from_org_id(l_index)
2737: );
2738: IF ( OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL
2739: OR OE_BULK_CACHE.G_ITEM_TBL(l_c_index).process_warehouse_flag <> 'Y' )
2740: THEN
2741: IF (p_line_rec.ordered_quantity_uom2(l_index) IS NOT NULL)
2742: OR
2743: (p_line_rec.ordered_quantity2(l_index) IS NOT NULL)

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

2750: END IF;
2751: fnd_message.set_name('ONT','OE_BULK_OPM_NOT_PROCESS');
2752: OE_BULK_MSG_PUB.Add('Y','ERROR');
2753: END IF;
2754: END IF; -- OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL THEN
2755:
2756: END IF; -- p_line_rec.inventory_item_id(p_index) IS NOT NULL THEN
2757:
2758: END IF; -- IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN

Line 4058: l_c_index := OE_Bulk_Cache.Load_Salesrep

4054: x_line_scredit_rec.line_id.extend(1);
4055: x_line_scredit_rec.salesrep_id.extend(1);
4056: x_line_scredit_rec.sales_credit_type_id.extend(1);
4057:
4058: l_c_index := OE_Bulk_Cache.Load_Salesrep
4059: (p_key => p_line_rec.salesrep_id(l_index));
4060:
4061: x_line_scredit_rec.header_id(l_scredit_index)
4062: := p_line_rec.header_id(l_index);

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

4064: := p_line_rec.line_id(l_index);
4065: x_line_scredit_rec.salesrep_id(l_scredit_index)
4066: := p_line_rec.salesrep_id(l_index);
4067: x_line_scredit_rec.sales_credit_type_id(l_scredit_index)
4068: := OE_Bulk_Cache.G_SALESREP_TBL(l_c_index).sales_credit_type_id;
4069:
4070: l_scredit_index := l_scredit_index + 1;
4071:
4072: END IF;

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

4165: ---------------------------------------------------------------
4166: -- SCHEDULING VALIDATIONS
4167: ---------------------------------------------------------------
4168: oe_debug_pub.add(' SCHEDULING :');
4169: l_c_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(header_counter));
4170:
4171: IF (OE_BULK_ORDER_PVT.G_AUTO_SCHEDULE = 'Y'
4172: OR OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).auto_scheduling_flag = 'Y'
4173: OR p_line_rec.schedule_ship_date(l_index) IS NOT NULL

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

4168: oe_debug_pub.add(' SCHEDULING :');
4169: l_c_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(header_counter));
4170:
4171: IF (OE_BULK_ORDER_PVT.G_AUTO_SCHEDULE = 'Y'
4172: OR OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).auto_scheduling_flag = 'Y'
4173: OR p_line_rec.schedule_ship_date(l_index) IS NOT NULL
4174: OR p_line_rec.schedule_arrival_date(l_index) IS NOT NULL)
4175: AND p_line_rec.source_type_code(l_index) = 'INTERNAL'
4176: AND p_line_rec.lock_control(l_index) <> -99

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

4184: IF l_debug_level > 0 THEN
4185: oe_debug_pub.add( 'SCHEDULING VALIDATIONS - ato scheduling') ;
4186: END IF;
4187:
4188: l_d_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(l_index));
4189: IF ( OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4190: AND l_on_generic_hold )
4191: THEN
4192: -- Add scheduling on hold message

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

4192: -- Add scheduling on hold message
4193: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
4194: OE_BULK_MSG_PUB.Add;
4195: ELSE
4196: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'ONE'
4197: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL
4198: AND OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).scheduling_level_code = 'ONE')
4199: THEN
4200: -- Add ATP Only message

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

4193: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
4194: OE_BULK_MSG_PUB.Add;
4195: ELSE
4196: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'ONE'
4197: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL
4198: AND OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).scheduling_level_code = 'ONE')
4199: THEN
4200: -- Add ATP Only message
4201: FND_MESSAGE.SET_NAME('ONT','OE_ATP_ONLY');

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

4194: OE_BULK_MSG_PUB.Add;
4195: ELSE
4196: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'ONE'
4197: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL
4198: AND OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).scheduling_level_code = 'ONE')
4199: THEN
4200: -- Add ATP Only message
4201: FND_MESSAGE.SET_NAME('ONT','OE_ATP_ONLY');
4202: OE_BULK_MSG_PUB.Add;

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

4206: ,x_return_status => l_return_status);
4207:
4208: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4209:
4210: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FOUR'
4211: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FIVE'
4212: THEN
4213:
4214: IF p_line_rec.ship_from_org_id(l_index) IS NOT NULL THEN

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

4207:
4208: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4209:
4210: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FOUR'
4211: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FIVE'
4212: THEN
4213:
4214: IF p_line_rec.ship_from_org_id(l_index) IS NOT NULL THEN
4215: IF p_line_rec.schedule_ship_date(l_index) IS NOT NULL THEN

Line 4316: l_c_index := OE_Bulk_Cache.Load_Ship_To

4312: AND nvl(p_line_rec.lock_control(l_index),0) <> - 99
4313: THEN
4314:
4315: IF p_line_rec.ship_to_org_id(l_index) IS NOT NULL THEN
4316: l_c_index := OE_Bulk_Cache.Load_Ship_To
4317: (p_key => p_line_rec.ship_to_org_id(l_index)
4318: ,p_edi_attributes => 'Y'
4319: );
4320: END IF;

Line 4323: l_c_index := OE_Bulk_Cache.Load_Invoice_To

4319: );
4320: END IF;
4321:
4322: IF p_line_rec.invoice_to_org_id(l_index) IS NOT NULL THEN
4323: l_c_index := OE_Bulk_Cache.Load_Invoice_To
4324: (p_key => p_line_rec.invoice_to_org_id(l_index)
4325: ,p_edi_attributes => 'Y'
4326: );
4327: END IF;

Line 4330: l_c_index := OE_Bulk_Cache.Load_Ship_From

4326: );
4327: END IF;
4328:
4329: IF p_line_rec.ship_from_org_id(l_index) IS NOT NULL THEN
4330: l_c_index := OE_Bulk_Cache.Load_Ship_From
4331: (p_key => p_line_rec.ship_from_org_id(l_index)
4332: );
4333: END IF;
4334: --{Bug 5054618

Line 4337: l_c_index := OE_Bulk_Cache.Load_End_customer

4333: END IF;
4334: --{Bug 5054618
4335: -- added for endcustomer changes
4336: IF p_line_rec.end_customer_id(l_index) IS NOT NULL THEN
4337: l_c_index := OE_Bulk_Cache.Load_End_customer
4338: (p_key => p_line_rec.end_customer_id(l_index)
4339: ,p_edi_attributes => 'Y'
4340: );
4341: END IF;

Line 4344: l_c_index := OE_Bulk_Cache.Load_end_customer_site

4340: );
4341: END IF;
4342:
4343: IF p_line_rec.End_customer_site_use_id(l_index) IS NOT NULL THEN
4344: l_c_index := OE_Bulk_Cache.Load_end_customer_site
4345: (p_key => p_line_rec.end_customer_site_use_id(l_index)
4346: ,p_edi_attributes => 'Y'
4347: );
4348: END IF;

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

4929: l_index NUMBER;
4930: BEGIN
4931:
4932: l_index :=
4933: OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_line_index));
4934:
4935: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
4936: -- Line type is null so get value from order type
4937:

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

4931:
4932: l_index :=
4933: OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(p_line_index));
4934:
4935: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
4936: -- Line type is null so get value from order type
4937:
4938: l_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(p_header_index));
4939:

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

4934:
4935: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
4936: -- Line type is null so get value from order type
4937:
4938: l_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(p_header_index));
4939:
4940:
4941: IF OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
4942: -- Get info from profile value

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

4937:
4938: l_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(p_header_index));
4939:
4940:
4941: IF OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id IS NULL THEN
4942: -- Get info from profile value
4943:
4944: IF G_INV_TRN_TYPE_ID IS NULL THEN
4945: G_INV_TRN_TYPE_ID := FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');

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

4953: p_line_rec.cust_trx_type_id(p_line_index) := G_INV_TRN_TYPE_ID;
4954: p_line_rec.tax_calculation_flag(p_line_index) := G_INV_TAX_CALC_FLAG;
4955: END IF;
4956: ELSE
4957: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id;
4958: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).tax_calculation_flag;
4959: END IF;
4960:
4961: ELSE

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

4954: p_line_rec.tax_calculation_flag(p_line_index) := G_INV_TAX_CALC_FLAG;
4955: END IF;
4956: ELSE
4957: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).cust_trx_type_id;
4958: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_index).tax_calculation_flag;
4959: END IF;
4960:
4961: ELSE
4962:

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

4960:
4961: ELSE
4962:
4963: -- Take values from line type
4964: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id;
4965: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).tax_calculation_flag;
4966:
4967: END IF;
4968:

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

4961: ELSE
4962:
4963: -- Take values from line type
4964: p_line_rec.cust_trx_type_id(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).cust_trx_type_id;
4965: p_line_rec.tax_calculation_flag(p_line_index) := OE_BULK_CACHE.G_LINE_TYPE_TBL(l_index).tax_calculation_flag;
4966:
4967: END IF;
4968:
4969: EXCEPTION