DBA Data[Home] [Help]

APPS.OE_ORDER_COPY_UTIL dependencies on STANDARD

Line 1306: -- Standard line when the model item record is not passed in.

1302: -- issues when destination order type is RETURN.
1303: -- It deletes rows for Included Items, Config items and options when top model
1304: -- record is passed in since Process ORder will re-explode them.
1305: -- It converts rows for Included Items, Class items, Config items and options to
1306: -- Standard line when the model item record is not passed in.
1307: -- Delete Class items always.
1308: -- This functions also deletes fully cancelled lines based on the flag.
1309:
1310: Procedure Handle_Return_Lines

Line 1356: -- If Model or Standard then do nothing.

1352: GOTO Excluded_cancelled_line;
1353:
1354: END IF;
1355:
1356: -- If Model or Standard then do nothing.
1357: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1358: OE_GLOBALS.G_ITEM_MODEL) THEN
1359:
1360: GOTO Leave_record_as_is;

Line 1357: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

1353:
1354: END IF;
1355:
1356: -- If Model or Standard then do nothing.
1357: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1358: OE_GLOBALS.G_ITEM_MODEL) THEN
1359:
1360: GOTO Leave_record_as_is;
1361:

Line 1364: -- Config item gets copied over as Standard if parent is not

1360: GOTO Leave_record_as_is;
1361:
1362: END IF;
1363:
1364: -- Config item gets copied over as Standard if parent is not
1365: -- passed in. It gets deleted if parent is passed in since
1366: -- auto-create will recreate it as part of normal Order processing.
1367: -- Included item gets copied over as Standard if parent is not
1368: -- passed in. It gets deleted if parent is passed in since

Line 1367: -- Included item gets copied over as Standard if parent is not

1363:
1364: -- Config item gets copied over as Standard if parent is not
1365: -- passed in. It gets deleted if parent is passed in since
1366: -- auto-create will recreate it as part of normal Order processing.
1367: -- Included item gets copied over as Standard if parent is not
1368: -- passed in. It gets deleted if parent is passed in since
1369: -- Process Order will re-exploded based on Freeze date.
1370:
1371: IF l_line_tbl(k).item_type_code IN

Line 1381: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

1377: IF l_line_tbl(k).top_model_line_id IS NOT NULL THEN
1378: l_top_model_index := Find_LineIndex(l_line_tbl,
1379: l_line_tbl(k).top_model_line_id);
1380: IF l_top_model_index = FND_API.G_MISS_NUM THEN
1381: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1382: GOTO Leave_record_as_is;
1383: END IF;
1384: END IF;
1385:

Line 1421: <> -- For Model And standard

1417: END IF;
1418: END IF;
1419:
1420:
1421: <> -- For Model And standard
1422: <> -- For fully cancelled lines
1423: NULL;
1424: END;
1425:

Line 1463: Procedure Handle_NonStandard_Lines

1459:
1460: --For bug 3923574, we added new parameter x_top_model_tbl to mark the
1461: -- has_canceled_flag on the model.
1462:
1463: Procedure Handle_NonStandard_Lines
1464: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1465: ,p_incl_cancelled IN VARCHAR2
1466: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1467: )

Line 1471: l_api_name CONSTANT VARCHAR2(30) := 'Handle_NonStandard_Lines';

1467: )
1468: IS
1469: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1470: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1471: l_api_name CONSTANT VARCHAR2(30) := 'Handle_NonStandard_Lines';
1472: l_top_model_index NUMBER;
1473: l_link_to_index NUMBER;
1474: l_service_index NUMBER;
1475: k NUMBER;

Line 1490: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ' , 1 ) ;

1486: idx NUMBER;
1487: BEGIN
1488:
1489: IF l_debug_level > 0 THEN
1490: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ' , 1 ) ;
1491: END IF;
1492: --ER 2264774
1493: --Load PRG lines in memory, it will used
1494: --for matching during line processing.

Line 1633: -- If Model or Standard or KIT then do nothing.

1629: GOTO Excluded_cancelled_line;
1630:
1631: END IF;
1632:
1633: -- If Model or Standard or KIT then do nothing.
1634: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1635: OE_GLOBALS.G_ITEM_MODEL,
1636: OE_GLOBALS.G_ITEM_KIT) THEN
1637:

Line 1634: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

1630:
1631: END IF;
1632:
1633: -- If Model or Standard or KIT then do nothing.
1634: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1635: OE_GLOBALS.G_ITEM_MODEL,
1636: OE_GLOBALS.G_ITEM_KIT) THEN
1637:
1638: GOTO Leave_record_as_is;

Line 1651: -- Config item gets copied over as Standard if parent is not

1647: GOTO Excluded_model_remnant_line;
1648:
1649: END IF;
1650:
1651: -- Config item gets copied over as Standard if parent is not
1652: -- passed in. It gets deleted if parent is passed in since
1653: -- auto-create will recreate it as part of normal Order processing.
1654: -- Included item gets copied over as Standard if parent is not
1655: -- passed in. It gets deleted if parent is passed in since

Line 1654: -- Included item gets copied over as Standard if parent is not

1650:
1651: -- Config item gets copied over as Standard if parent is not
1652: -- passed in. It gets deleted if parent is passed in since
1653: -- auto-create will recreate it as part of normal Order processing.
1654: -- Included item gets copied over as Standard if parent is not
1655: -- passed in. It gets deleted if parent is passed in since
1656: -- Process Order will re-exploded based on Freeze date.
1657:
1658: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_CONFIG,

Line 1668: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

1664: IF l_line_tbl(k).link_to_line_id IS NOT NULL THEN
1665: l_link_to_index := Find_LineIndex(l_line_tbl,l_line_tbl(k).link_to_line_id);
1666: IF l_link_to_index = FND_API.G_MISS_NUM THEN
1667:
1668: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1669: l_line_tbl(k).option_number := NULL;
1670: l_line_tbl(k).component_number := NULL;
1671: l_line_tbl(k).split_from_line_id := NULL;
1672: l_line_tbl(k).split_by := NULL;

Line 1688: -- else it gets converted to a Standard item.

1684: GOTO Leave_record_as_is;
1685: END IF; -- End Included or Config Item
1686:
1687: -- Option gets copied over as such if parent is passed in
1688: -- else it gets converted to a Standard item.
1689:
1690: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_OPTION) THEN
1691:
1692: IF l_debug_level > 0 THEN

Line 1703: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

1699: l_line_tbl(k).top_model_line_id);
1700:
1701: IF l_top_model_index = FND_API.G_MISS_NUM THEN
1702:
1703: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1704: l_line_tbl(k).option_number := NULL;
1705: l_line_tbl(k).component_number := NULL;
1706: l_line_tbl(k).split_from_line_id := NULL;
1707: l_line_tbl(k).split_by := NULL;

Line 1720: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

1716: l_line_tbl(k).link_to_line_id);
1717:
1718: IF l_link_to_index = FND_API.G_MISS_NUM THEN
1719:
1720: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1721: l_line_tbl(k).option_number := NULL;
1722: l_line_tbl(k).component_number := NULL;
1723: l_line_tbl(k).split_from_line_id := NULL;
1724: l_line_tbl(k).split_by := NULL;

Line 1755: -- else it gets deleted(Classes cannot be conveted to STANDARD)

1751: */
1752: END IF; -- Option
1753:
1754: -- Classes get copied over as such if the parent is passed in
1755: -- else it gets deleted(Classes cannot be conveted to STANDARD)
1756:
1757: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_CLASS) THEN
1758:
1759: IF l_debug_level > 0 THEN

Line 1853: <> -- For Model And standard

1849:
1850: GOTO Leave_record_as_is; -- No Parent for the Customer Product
1851: END IF; -- Service
1852:
1853: <> -- For Model And standard
1854: <> -- For fully cancelled lines
1855: <> -- For model remnant lines.
1856: --bug3441056 contd
1857: << OUT_OF_MACD_LOGIC >>

Line 1913: oe_debug_pub.add('Exiting OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ',1);

1909: --end Bugfix 9004082
1910:
1911:
1912: IF l_debug_level > 0 THEN
1913: oe_debug_pub.add('Exiting OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ',1);
1914: END IF;
1915: p_x_line_tbl := l_line_out_tbl;
1916:
1917: --ER 2264774

Line 1920: END Handle_NonStandard_Lines;

1916:
1917: --ER 2264774
1918: OE_LINE_ADJ_UTIL.RESET_PRG_CACHE;
1919:
1920: END Handle_NonStandard_Lines;
1921:
1922: Procedure Load_Lines
1923: ( p_num_lines IN NUMBER
1924: ,p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl

Line 2045: oe_debug_pub.add( 'CALLING HANDLE_NONSTANDARD_LINES' , 1 ) ;

2041: ELSE -- When the destination is Mixed or Order.
2042:
2043:
2044: IF l_debug_level > 0 THEN
2045: oe_debug_pub.add( 'CALLING HANDLE_NONSTANDARD_LINES' , 1 ) ;
2046: END IF;
2047: /* Start 3923574 */
2048: Handle_NonStandard_Lines(x_line_tbl
2049: ,p_incl_cancelled

Line 2048: Handle_NonStandard_Lines(x_line_tbl

2044: IF l_debug_level > 0 THEN
2045: oe_debug_pub.add( 'CALLING HANDLE_NONSTANDARD_LINES' , 1 ) ;
2046: END IF;
2047: /* Start 3923574 */
2048: Handle_NonStandard_Lines(x_line_tbl
2049: ,p_incl_cancelled
2050: ,x_top_model_tbl);
2051: /* Start 3923574 */
2052:

Line 2968: -- Clear Config related info if item type is STANDARD

2964: IF p_x_line_tbl(k).service_reference_type_code = 'ORDER' THEN
2965: p_x_line_tbl(k).service_reference_line_id := FND_API.G_MISS_NUM;
2966: END IF;
2967:
2968: -- Clear Config related info if item type is STANDARD
2969:
2970: IF l_temp_line_rec.item_type_code = 'STANDARD' THEN
2971: p_x_line_tbl(k).component_sequence_id := FND_API.G_MISS_NUM;
2972: p_x_line_tbl(k).component_code := FND_API.G_MISS_CHAR;

Line 2970: IF l_temp_line_rec.item_type_code = 'STANDARD' THEN

2966: END IF;
2967:
2968: -- Clear Config related info if item type is STANDARD
2969:
2970: IF l_temp_line_rec.item_type_code = 'STANDARD' THEN
2971: p_x_line_tbl(k).component_sequence_id := FND_API.G_MISS_NUM;
2972: p_x_line_tbl(k).component_code := FND_API.G_MISS_CHAR;
2973: -- p_x_line_tbl(k).component_number := FND_API.G_MISS_NUM;
2974: p_x_line_tbl(k).sort_order := FND_API.G_MISS_CHAR;

Line 3819: -- Standard call to check for call compatibility

3815:
3816: G_LINE_PRICE_MODE := p_copy_rec.line_price_mode;
3817: G_ORDER_LEVEL_COPY := 0;
3818:
3819: -- Standard call to check for call compatibility
3820:
3821: IF NOT FND_API.Compatible_API_Call
3822: (l_api_version_number
3823: ,p_copy_rec.api_version_number

Line 4180: -- Will be used in Nonstandard lines procedure.

4176: oe_debug_pub.add('Line Version Number IS '|| G_LN_VER_NUMBER , 1 ) ;
4177: oe_debug_pub.add('Line Phase Change Flag IS '|| G_LN_PHASE_CHANGE_FLAG , 1 ) ;
4178: END IF;
4179: -- Load Lines to be copied into table and handle configurations.
4180: -- Will be used in Nonstandard lines procedure.
4181:
4182: l_hdr_type_id := nvl(p_copy_rec.hdr_type,l_header_rec.order_type_id);
4183: load_lines(p_copy_rec.line_count,
4184: p_line_id_tbl,

Line 6078: AND (p_line_tbl(lindex).item_type_code = 'STANDARD' OR

6074: IF p_line_tbl.Count > 0 THEN
6075: FOR lindex IN 1..p_line_tbl.Count
6076: LOOP
6077: IF p_line_tbl(lindex).source_document_line_id = line_rec.line_id
6078: AND (p_line_tbl(lindex).item_type_code = 'STANDARD' OR
6079: p_line_tbl(lindex).item_type_code = 'MODEL' OR
6080: p_line_tbl(lindex).item_type_code = 'SERVICE' OR
6081: p_line_tbl(lindex).item_type_code = 'KIT')
6082: THEN

Line 6160: AND (p_line_tbl(lindex).item_type_code = 'STANDARD' OR

6156: IF p_line_tbl.Count > 0 THEN
6157: FOR lindex IN 1..p_line_tbl.Count
6158: LOOP
6159: IF p_line_tbl(lindex).source_document_line_id = line_rec.line_id
6160: AND (p_line_tbl(lindex).item_type_code = 'STANDARD' OR
6161: p_line_tbl(lindex).item_type_code = 'MODEL' OR
6162: p_line_tbl(lindex).item_type_code = 'KIT')
6163: THEN
6164: -- Incrementing index and populating table.

Line 6241: AND (p_line_tbl(lindex).item_type_code = 'STANDARD' OR

6237: IF p_line_tbl.Count > 0 THEN
6238: FOR lindex IN 1..p_line_tbl.Count
6239: LOOP
6240: IF p_line_tbl(lindex).source_document_line_id = line_rec.line_id
6241: AND (p_line_tbl(lindex).item_type_code = 'STANDARD' OR
6242: p_line_tbl(lindex).item_type_code = 'MODEL' OR
6243: p_line_tbl(lindex).item_type_code = 'KIT')
6244: THEN
6245: -- Incrementing index and populating table.