DBA Data[Home] [Help]

APPS.OE_ORDER_COPY_UTIL dependencies on STANDARD

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

1230: -- issues when destination order type is RETURN.
1231: -- It deletes rows for Included Items, Config items and options when top model
1232: -- record is passed in since Process ORder will re-explode them.
1233: -- It converts rows for Included Items, Class items, Config items and options to
1234: -- Standard line when the model item record is not passed in.
1235: -- Delete Class items always.
1236: -- This functions also deletes fully cancelled lines based on the flag.
1237:
1238: Procedure Handle_Return_Lines

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

1280: GOTO Excluded_cancelled_line;
1281:
1282: END IF;
1283:
1284: -- If Model or Standard then do nothing.
1285: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1286: OE_GLOBALS.G_ITEM_MODEL) THEN
1287:
1288: GOTO Leave_record_as_is;

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

1281:
1282: END IF;
1283:
1284: -- If Model or Standard then do nothing.
1285: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1286: OE_GLOBALS.G_ITEM_MODEL) THEN
1287:
1288: GOTO Leave_record_as_is;
1289:

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

1288: GOTO Leave_record_as_is;
1289:
1290: END IF;
1291:
1292: -- Config item gets copied over as Standard if parent is not
1293: -- passed in. It gets deleted if parent is passed in since
1294: -- auto-create will recreate it as part of normal Order processing.
1295: -- Included item gets copied over as Standard if parent is not
1296: -- passed in. It gets deleted if parent is passed in since

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

1291:
1292: -- Config item gets copied over as Standard if parent is not
1293: -- passed in. It gets deleted if parent is passed in since
1294: -- auto-create will recreate it as part of normal Order processing.
1295: -- Included item gets copied over as Standard if parent is not
1296: -- passed in. It gets deleted if parent is passed in since
1297: -- Process Order will re-exploded based on Freeze date.
1298:
1299: IF l_line_tbl(k).item_type_code IN

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

1305: IF l_line_tbl(k).top_model_line_id IS NOT NULL THEN
1306: l_top_model_index := Find_LineIndex(l_line_tbl,
1307: l_line_tbl(k).top_model_line_id);
1308: IF l_top_model_index = FND_API.G_MISS_NUM THEN
1309: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1310: GOTO Leave_record_as_is;
1311: END IF;
1312: END IF;
1313:

Line 1349: <> -- For Model And standard

1345: END IF;
1346: END IF;
1347:
1348:
1349: <> -- For Model And standard
1350: <> -- For fully cancelled lines
1351: NULL;
1352: END;
1353:

Line 1391: Procedure Handle_NonStandard_Lines

1387:
1388: --For bug 3923574, we added new parameter x_top_model_tbl to mark the
1389: -- has_canceled_flag on the model.
1390:
1391: Procedure Handle_NonStandard_Lines
1392: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1393: ,p_incl_cancelled IN VARCHAR2
1394: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1395: )

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

1395: )
1396: IS
1397: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1398: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1399: l_api_name CONSTANT VARCHAR2(30) := 'Handle_NonStandard_Lines';
1400: l_top_model_index NUMBER;
1401: l_link_to_index NUMBER;
1402: l_service_index NUMBER;
1403: k NUMBER;

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

1414: idx NUMBER;
1415: BEGIN
1416:
1417: IF l_debug_level > 0 THEN
1418: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ' , 1 ) ;
1419: END IF;
1420: --ER 2264774
1421: --Load PRG lines in memory, it will used
1422: --for matching during line processing.

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

1557: GOTO Excluded_cancelled_line;
1558:
1559: END IF;
1560:
1561: -- If Model or Standard or KIT then do nothing.
1562: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1563: OE_GLOBALS.G_ITEM_MODEL,
1564: OE_GLOBALS.G_ITEM_KIT) THEN
1565:

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

1558:
1559: END IF;
1560:
1561: -- If Model or Standard or KIT then do nothing.
1562: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1563: OE_GLOBALS.G_ITEM_MODEL,
1564: OE_GLOBALS.G_ITEM_KIT) THEN
1565:
1566: GOTO Leave_record_as_is;

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

1575: GOTO Excluded_model_remnant_line;
1576:
1577: END IF;
1578:
1579: -- Config item gets copied over as Standard if parent is not
1580: -- passed in. It gets deleted if parent is passed in since
1581: -- auto-create will recreate it as part of normal Order processing.
1582: -- Included item gets copied over as Standard if parent is not
1583: -- passed in. It gets deleted if parent is passed in since

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

1578:
1579: -- Config item gets copied over as Standard if parent is not
1580: -- passed in. It gets deleted if parent is passed in since
1581: -- auto-create will recreate it as part of normal Order processing.
1582: -- Included item gets copied over as Standard if parent is not
1583: -- passed in. It gets deleted if parent is passed in since
1584: -- Process Order will re-exploded based on Freeze date.
1585:
1586: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_CONFIG,

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

1592: IF l_line_tbl(k).link_to_line_id IS NOT NULL THEN
1593: l_link_to_index := Find_LineIndex(l_line_tbl,l_line_tbl(k).link_to_line_id);
1594: IF l_link_to_index = FND_API.G_MISS_NUM THEN
1595:
1596: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1597: l_line_tbl(k).option_number := NULL;
1598: l_line_tbl(k).component_number := NULL;
1599: l_line_tbl(k).split_from_line_id := NULL;
1600: l_line_tbl(k).split_by := NULL;

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

1612: GOTO Leave_record_as_is;
1613: END IF; -- End Included or Config Item
1614:
1615: -- Option gets copied over as such if parent is passed in
1616: -- else it gets converted to a Standard item.
1617:
1618: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_OPTION) THEN
1619:
1620: IF l_debug_level > 0 THEN

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

1627: l_line_tbl(k).top_model_line_id);
1628:
1629: IF l_top_model_index = FND_API.G_MISS_NUM THEN
1630:
1631: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1632: l_line_tbl(k).option_number := NULL;
1633: l_line_tbl(k).component_number := NULL;
1634: l_line_tbl(k).split_from_line_id := NULL;
1635: l_line_tbl(k).split_by := NULL;

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

1644: l_line_tbl(k).link_to_line_id);
1645:
1646: IF l_link_to_index = FND_API.G_MISS_NUM THEN
1647:
1648: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1649: l_line_tbl(k).option_number := NULL;
1650: l_line_tbl(k).component_number := NULL;
1651: l_line_tbl(k).split_from_line_id := NULL;
1652: l_line_tbl(k).split_by := NULL;

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

1679: */
1680: END IF; -- Option
1681:
1682: -- Classes get copied over as such if the parent is passed in
1683: -- else it gets deleted(Classes cannot be conveted to STANDARD)
1684:
1685: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_CLASS) THEN
1686:
1687: IF l_debug_level > 0 THEN

Line 1781: <> -- For Model And standard

1777:
1778: GOTO Leave_record_as_is; -- No Parent for the Customer Product
1779: END IF; -- Service
1780:
1781: <> -- For Model And standard
1782: <> -- For fully cancelled lines
1783: <> -- For model remnant lines.
1784: --bug3441056 contd
1785: << OUT_OF_MACD_LOGIC >>

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

1799: k := l_line_tbl.NEXT(k);
1800: END LOOP;
1801:
1802: IF l_debug_level > 0 THEN
1803: oe_debug_pub.add('Exiting OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ',1);
1804: END IF;
1805: p_x_line_tbl := l_line_out_tbl;
1806:
1807: --ER 2264774

Line 1810: END Handle_NonStandard_Lines;

1806:
1807: --ER 2264774
1808: OE_LINE_ADJ_UTIL.RESET_PRG_CACHE;
1809:
1810: END Handle_NonStandard_Lines;
1811:
1812: Procedure Load_Lines
1813: ( p_num_lines IN NUMBER
1814: ,p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl

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

1922: ELSE -- When the destination is Mixed or Order.
1923:
1924:
1925: IF l_debug_level > 0 THEN
1926: oe_debug_pub.add( 'CALLING HANDLE_NONSTANDARD_LINES' , 1 ) ;
1927: END IF;
1928: /* Start 3923574 */
1929: Handle_NonStandard_Lines(x_line_tbl
1930: ,p_incl_cancelled

Line 1929: Handle_NonStandard_Lines(x_line_tbl

1925: IF l_debug_level > 0 THEN
1926: oe_debug_pub.add( 'CALLING HANDLE_NONSTANDARD_LINES' , 1 ) ;
1927: END IF;
1928: /* Start 3923574 */
1929: Handle_NonStandard_Lines(x_line_tbl
1930: ,p_incl_cancelled
1931: ,x_top_model_tbl);
1932: /* Start 3923574 */
1933:

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

2839: IF p_x_line_tbl(k).service_reference_type_code = 'ORDER' THEN
2840: p_x_line_tbl(k).service_reference_line_id := FND_API.G_MISS_NUM;
2841: END IF;
2842:
2843: -- Clear Config related info if item type is STANDARD
2844:
2845: IF l_temp_line_rec.item_type_code = 'STANDARD' THEN
2846: p_x_line_tbl(k).component_sequence_id := FND_API.G_MISS_NUM;
2847: p_x_line_tbl(k).component_code := FND_API.G_MISS_CHAR;

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

2841: END IF;
2842:
2843: -- Clear Config related info if item type is STANDARD
2844:
2845: IF l_temp_line_rec.item_type_code = 'STANDARD' THEN
2846: p_x_line_tbl(k).component_sequence_id := FND_API.G_MISS_NUM;
2847: p_x_line_tbl(k).component_code := FND_API.G_MISS_CHAR;
2848: -- p_x_line_tbl(k).component_number := FND_API.G_MISS_NUM;
2849: p_x_line_tbl(k).sort_order := FND_API.G_MISS_CHAR;

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

3665:
3666: G_LINE_PRICE_MODE := p_copy_rec.line_price_mode;
3667: G_ORDER_LEVEL_COPY := 0;
3668:
3669: -- Standard call to check for call compatibility
3670:
3671: IF NOT FND_API.Compatible_API_Call
3672: (l_api_version_number
3673: ,p_copy_rec.api_version_number

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

4026: oe_debug_pub.add('Line Version Number IS '|| G_LN_VER_NUMBER , 1 ) ;
4027: oe_debug_pub.add('Line Phase Change Flag IS '|| G_LN_PHASE_CHANGE_FLAG , 1 ) ;
4028: END IF;
4029: -- Load Lines to be copied into table and handle configurations.
4030: -- Will be used in Nonstandard lines procedure.
4031:
4032: l_hdr_type_id := nvl(p_copy_rec.hdr_type,l_header_rec.order_type_id);
4033: load_lines(p_copy_rec.line_count,
4034: p_line_id_tbl,

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

5882: IF p_line_tbl.Count > 0 THEN
5883: FOR lindex IN 1..p_line_tbl.Count
5884: LOOP
5885: IF p_line_tbl(lindex).source_document_line_id = line_rec.line_id
5886: AND (p_line_tbl(lindex).item_type_code = 'STANDARD' OR
5887: p_line_tbl(lindex).item_type_code = 'MODEL' OR
5888: p_line_tbl(lindex).item_type_code = 'SERVICE' OR
5889: p_line_tbl(lindex).item_type_code = 'KIT')
5890: THEN

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

5964: IF p_line_tbl.Count > 0 THEN
5965: FOR lindex IN 1..p_line_tbl.Count
5966: LOOP
5967: IF p_line_tbl(lindex).source_document_line_id = line_rec.line_id
5968: AND (p_line_tbl(lindex).item_type_code = 'STANDARD' OR
5969: p_line_tbl(lindex).item_type_code = 'MODEL' OR
5970: p_line_tbl(lindex).item_type_code = 'KIT')
5971: THEN
5972: -- Incrementing index and populating table.

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

6045: IF p_line_tbl.Count > 0 THEN
6046: FOR lindex IN 1..p_line_tbl.Count
6047: LOOP
6048: IF p_line_tbl(lindex).source_document_line_id = line_rec.line_id
6049: AND (p_line_tbl(lindex).item_type_code = 'STANDARD' OR
6050: p_line_tbl(lindex).item_type_code = 'MODEL' OR
6051: p_line_tbl(lindex).item_type_code = 'KIT')
6052: THEN
6053: -- Incrementing index and populating table.