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_CONFIG_PVT dependencies on OE_GLOBALS

Line 150: l_control_rec OE_GLOBALS.Control_Rec_Type;

146: l_profile_value VARCHAR2(1) :=
147: upper(FND_PROFILE.VALUE('ONT_CONFIG_QUICK_SAVE'));
148:
149: -- process_order in params
150: l_control_rec OE_GLOBALS.Control_Rec_Type;
151: l_header_rec OE_Order_PUB.Header_Rec_Type;
152: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
153: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
154: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 168: ( p_entity_code => OE_Globals.G_ENTITY_LINE

164:
165: Print_Time('Entering Process Config '|| p_config_hdr_id);
166:
167: OE_Msg_Pub.Set_Msg_Context
168: ( p_entity_code => OE_Globals.G_ENTITY_LINE
169: ,p_entity_id => p_top_model_line_id
170: ,p_header_id => p_header_id
171: ,p_line_id => p_top_model_line_id);
172:

Line 246: l_model_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

242: oe_debug_pub.add('UPDATE MODEL WITH NEW QTY '|| L_MODEL_NEW_QTY,1);
243: END IF;
244:
245: l_model_line_rec.ordered_quantity := l_model_new_qty;
246: l_model_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
247: l_line_tbl(nvl(l_line_tbl.LAST, 0) + 1) := l_model_line_rec;
248:
249: END IF;
250:

Line 589: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

585: l_line_count := nvl(p_x_line_tbl.LAST, 0);
586: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
587:
588: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
589: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
590: l_line_rec.header_id := p_model_line_rec.header_id;
591: l_line_rec.item_identifier_type := 'INT';
592: l_line_rec.config_header_id := p_config_hdr_id;
593: l_line_rec.config_rev_nbr := p_config_rev_nbr;

Line 782: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;

778: l_line_rec.ordered_item := l_concatenated_segments;
779:
780: IF config_rec.bom_item_type = 1 OR
781: config_rec.bom_item_type = 2 THEN
782: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;
783: ELSE
784: l_line_rec.item_type_code := null;
785: END IF;
786:

Line 865: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

861: l_line_count := nvl(p_x_line_tbl.LAST, 0);
862: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
863:
864: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
865: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
866: l_line_rec.header_id := p_model_line_rec.header_id;
867: l_line_rec.item_identifier_type := 'INT';
868:
869:

Line 950: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;

946: l_line_rec.ordered_item := l_concatenated_segments;
947:
948: IF config_rec.bom_item_type = 1 OR
949: config_rec.bom_item_type = 2 THEN
950: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;
951: ELSE
952: l_line_rec.item_type_code := null;
953: END IF;
954:

Line 1052: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1048: l_line_count := nvl(p_x_line_tbl.LAST, 0);
1049: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
1050:
1051: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1052: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1053: l_line_rec.top_model_line_id := p_model_line_rec.line_id;
1054:
1055:
1056: FOR config_rec in config_upd_cursor

Line 1105: IF p_direct_save AND config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS

1101: l_line_rec.change_reason := 'CONFIGURATOR';
1102: l_line_rec.change_comments := 'Changes in Configurator Window';
1103: END IF;
1104:
1105: IF p_direct_save AND config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS
1106: THEN
1107: l_class_line_count := l_class_line_count+1;
1108: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1109: ELSE

Line 1182: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1178: l_line_count := nvl(p_x_line_tbl.LAST, 0);
1179: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
1180:
1181: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1182: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1183: l_line_rec.top_model_line_id := p_model_line_rec.line_id;
1184:
1185:
1186: FOR config_rec in config_upd_cursor

Line 1207: IF p_direct_save AND config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS

1203: l_line_rec.change_reason := 'CONFIGURATOR';
1204: l_line_rec.change_comments := 'Changes in Configurator Window';
1205: END IF;
1206:
1207: IF p_direct_save AND config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS
1208: THEN
1209: l_class_line_count := l_class_line_count+1;
1210: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1211: ELSE

Line 1263: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

1259: SELECT l.line_id, l.item_type_code, l.link_to_line_id,
1260: l.component_code, nvl(l.cancelled_flag, 'N') cancelled_flag
1261: FROM oe_order_lines l
1262: WHERE l.top_model_line_id = p_model_line_rec.line_id
1263: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1264: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1265: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1266: AND l.open_flag = 'Y'
1267: AND

Line 1264: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1260: l.component_code, nvl(l.cancelled_flag, 'N') cancelled_flag
1261: FROM oe_order_lines l
1262: WHERE l.top_model_line_id = p_model_line_rec.line_id
1263: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1264: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1265: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1266: AND l.open_flag = 'Y'
1267: AND
1268: (NOT EXISTS

Line 1265: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)

1261: FROM oe_order_lines l
1262: WHERE l.top_model_line_id = p_model_line_rec.line_id
1263: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1264: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1265: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1266: AND l.open_flag = 'Y'
1267: AND
1268: (NOT EXISTS
1269: ( SELECT 'X'

Line 1365: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1361: oe_debug_pub.add( 'DELETING LINE : ' || CONFIG_REC.LINE_ID ) ;
1362: END IF;
1363:
1364: l_line_rec.line_id := config_rec.line_id;
1365: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1366:
1367: IF l_debug_level > 0 THEN
1368: oe_debug_pub.add('LINE_ID TO BE DELETED: ' || CONFIG_REC.LINE_ID ,1);
1369: END IF;

Line 1372: config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS

1368: oe_debug_pub.add('LINE_ID TO BE DELETED: ' || CONFIG_REC.LINE_ID ,1);
1369: END IF;
1370:
1371: IF p_direct_save AND
1372: config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS
1373: THEN
1374: l_class_line_count := l_class_line_count+1;
1375: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1376: ELSE

Line 1389: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1385:
1386: IF config_rec.cancelled_flag = 'N' THEN
1387:
1388: l_line_rec.line_id := config_rec.line_id;
1389: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1390: l_line_rec.ordered_quantity := 0;
1391:
1392: IF p_direct_save AND
1393: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS

Line 1393: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS

1389: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1390: l_line_rec.ordered_quantity := 0;
1391:
1392: IF p_direct_save AND
1393: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS
1394: THEN
1395: l_class_line_count := l_class_line_count+1;
1396: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1397: ELSE

Line 1452: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

1448: SELECT l.line_id, l.item_type_code, l.link_to_line_id,
1449: l.component_code
1450: FROM oe_order_lines l
1451: WHERE l.top_model_line_id = p_model_line_rec.line_id
1452: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1453: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1454: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1455: AND l.open_flag = 'Y'
1456: AND

Line 1453: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1449: l.component_code
1450: FROM oe_order_lines l
1451: WHERE l.top_model_line_id = p_model_line_rec.line_id
1452: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1453: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1454: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1455: AND l.open_flag = 'Y'
1456: AND
1457: (NOT EXISTS

Line 1454: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)

1450: FROM oe_order_lines l
1451: WHERE l.top_model_line_id = p_model_line_rec.line_id
1452: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1453: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1454: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1455: AND l.open_flag = 'Y'
1456: AND
1457: (NOT EXISTS
1458: ( SELECT 'X'

Line 1529: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1525: oe_debug_pub.add( 'DELETING LINE : ' || CONFIG_REC.LINE_ID ) ;
1526: END IF;
1527:
1528: l_line_rec.line_id := config_rec.line_id;
1529: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1530:
1531: IF l_debug_level > 0 THEN
1532: oe_debug_pub.add('LINE_ID TO BE DELETED: '||CONFIG_REC.LINE_ID,1);
1533: END IF;

Line 1536: config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS

1532: oe_debug_pub.add('LINE_ID TO BE DELETED: '||CONFIG_REC.LINE_ID,1);
1533: END IF;
1534:
1535: IF p_direct_save AND
1536: config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS
1537: THEN
1538: l_class_line_count := l_class_line_count+1;
1539: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1540: ELSE

Line 1553: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1549:
1550: IF l_qty <> 0 OR
1551: p_ui_flag = 'Y' THEN
1552: l_line_rec.line_id := config_rec.line_id;
1553: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1554: l_line_rec.ordered_quantity := 0;
1555: l_line_rec.change_reason := 'SYSTEM';
1556: l_line_rec.change_comments := 'Change Cascaded';
1557:

Line 1559: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS

1555: l_line_rec.change_reason := 'SYSTEM';
1556: l_line_rec.change_comments := 'Change Cascaded';
1557:
1558: IF p_direct_save AND
1559: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS
1560: THEN
1561: l_class_line_count := l_class_line_count+1;
1562: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1563: ELSE

Line 1709: IF p_item_type_code = OE_GLOBALS.G_ITEM_CLASS AND

1705: END IF;
1706:
1707: END LOOP;
1708:
1709: IF p_item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
1710: l_open_flag = 'Y'
1711: THEN
1712:
1713: IF l_debug_level > 0 THEN

Line 1848: ,p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type

1844: PROCEDURE Call_Process_Order
1845: ( p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1846: ,p_class_line_tbl IN OE_Order_Pub.Line_Tbl_Type
1847: := OE_ORDER_PUB.G_MISS_LINE_TBL
1848: ,p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type
1849: ,p_ui_flag IN VARCHAR2 := 'N'
1850: ,p_top_model_line_id IN NUMBER := null
1851: ,p_config_hdr_id IN NUMBER := null
1852: ,p_config_rev_nbr IN NUMBER := null

Line 1897: p_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;

1893: p_control_rec.controlled_operation := TRUE;
1894: p_control_rec.change_attributes := TRUE;
1895: p_control_rec.validate_entity := TRUE;
1896: p_control_rec.write_to_DB := TRUE;
1897: p_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
1898:
1899: -- change made for bug 2350478
1900: IF p_ui_flag = 'Y' THEN
1901: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'Y';

Line 1922: -- OE_GLOBALS.G_RECURSION_MODE := 'N';

1918: , p_x_old_line_tbl => l_old_line_tbl
1919: , x_return_status => l_return_status);
1920: Print_Time('call to lines end time');
1921:
1922: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
1923: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'N';
1924: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y';
1925: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'N';
1926: OE_CONFIG_UTIL.G_CONFIG_UI_USED := 'N';

Line 1962: IF l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1958: oe_debug_pub.add('I: '|| P_CLASS_LINE_TBL ( I ) .LINE_ID , 1 ) ;
1959: END IF;
1960: l_line_rec := p_class_line_tbl(I);
1961:
1962: IF l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1963:
1964: /* Bug 4165102 : Call to Globalization hook is included for class lines
1965: * if the profile option 'OM: Configuration Quick Save' is set to Yes.
1966: * Note: JG API defaults global_attributes ,only if they are passed as

Line 2028: ELSIF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2024: IF ( Nvl(l_line_rec.transaction_phase_code, 'F') <> 'N' ) THEN
2025: OE_Order_WF_Util.CreateStart_LineProcess(l_line_rec);
2026: END IF;
2027:
2028: ELSIF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2029: IF l_debug_level > 0 THEN
2030: oe_debug_pub.add('UPDATE: ' || L_LINE_REC.LINE_ID , 1 ) ;
2031: END IF;
2032:

Line 2037: ELSIF l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

2033: UPDATE oe_order_lines
2034: SET ordered_quantity = l_line_rec.ordered_quantity
2035: WHERE line_id = l_line_rec.line_id;
2036:
2037: ELSIF l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2038: IF l_debug_level > 0 THEN
2039: oe_debug_pub.add('DELETE: ' || L_LINE_REC.LINE_ID , 1 ) ;
2040: END IF;
2041:

Line 2093: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER

2089: p_line_tbl.COUNT > 0 THEN
2090:
2091: IF (p_line_tbl(1).booked_flag = 'Y') THEN
2092: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2093: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
2094: ,p_delete => FND_API.G_TRUE
2095: ,x_return_status => l_return_status
2096: );
2097: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2218: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED

2214: FROM oe_order_lines
2215: WHERE top_model_line_id = p_top_model_line_id
2216: AND line_id <> p_top_model_line_id
2217: AND service_reference_line_id is null
2218: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED
2219: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
2220: order by sort_order;
2221:
2222: --

Line 2219: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG

2215: WHERE top_model_line_id = p_top_model_line_id
2216: AND line_id <> p_top_model_line_id
2217: AND service_reference_line_id is null
2218: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED
2219: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
2220: order by sort_order;
2221:
2222: --
2223: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2280: l_model_item_type_code = OE_GLOBALS.G_ITEM_MODEL AND

2276:
2277: --/*** update ato line_id and related attributes for subconfig **/
2278:
2279: IF (p_operation = 'C' OR p_operation = 'A') AND
2280: l_model_item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
2281: l_model_ato_line_id is NULL
2282: THEN
2283: IF l_debug_level > 0 THEN
2284: oe_debug_pub.add('UPDATE ATO ATTRIBS FOR SUBASSEMBLIES' , 1 ) ;

Line 2295: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG

2291: UPDATE oe_order_lines
2292: SET shippable_flag = 'N'
2293: WHERE top_model_line_id = p_top_model_line_id
2294: AND ato_line_id is NOT NULL
2295: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
2296: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2297: ato_line_id = line_id)
2298: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND --9775352
2299: ato_line_id = line_id);

Line 2296: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND

2292: SET shippable_flag = 'N'
2293: WHERE top_model_line_id = p_top_model_line_id
2294: AND ato_line_id is NOT NULL
2295: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
2296: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2297: ato_line_id = line_id)
2298: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND --9775352
2299: ato_line_id = line_id);
2300: END IF;

Line 2298: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND --9775352

2294: AND ato_line_id is NOT NULL
2295: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
2296: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2297: ato_line_id = line_id)
2298: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND --9775352
2299: ato_line_id = line_id);
2300: END IF;
2301:
2302:

Line 2470: (l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

2466: -- fix for 3082485 ends
2467:
2468:
2469: IF l_model_ato_line_id is NULL AND
2470: (l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2471: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
2472: THEN
2473: BEGIN
2474: UPDATE oe_order_lines

Line 2471: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)

2467:
2468:
2469: IF l_model_ato_line_id is NULL AND
2470: (l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2471: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
2472: THEN
2473: BEGIN
2474: UPDATE oe_order_lines
2475: SET option_number = l_option_nbr,

Line 2517: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG

2513: (SELECT ordered_quantity
2514: FROM oe_order_lines
2515: WHERE line_id = o.link_to_line_id)
2516: WHERE top_model_line_id = p_top_model_line_id
2517: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG
2518: AND nvl(model_remnant_flag, 'N') = 'N';
2519:
2520: UPDATE oe_order_lines
2521: SET cancelled_flag = 'Y'

Line 2739: OEOPT.item_type_code = OE_GLOBALS.G_ITEM_MODEL))

2735: OELNK.top_model_line_id = OEOPT.top_model_line_id ))
2736: AND (OELNK.component_code = SUBSTR( OEOPT.component_code,1,
2737: LENGTH( RTRIM( OEOPT.component_code,'0123456789' )) - 1)
2738: OR (OELNK.component_code = OEOPT.component_code AND
2739: OEOPT.item_type_code = OE_GLOBALS.G_ITEM_MODEL))
2740: AND open_flag = 'Y'
2741: )
2742: WHERE OEOPT.top_model_line_id = p_top_model_line_id
2743: AND OEOPT.line_id <> p_top_model_line_id

Line 2745: AND OEOPT.item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;

2741: )
2742: WHERE OEOPT.top_model_line_id = p_top_model_line_id
2743: AND OEOPT.line_id <> p_top_model_line_id
2744: AND OEOPT.link_to_line_id IS NULL
2745: AND OEOPT.item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;
2746:
2747: IF SQL%FOUND THEN
2748: IF l_debug_level > 0 THEN
2749: oe_debug_pub.add('3 LLID UPDATED ' || SQL%ROWCOUNT ) ;

Line 2768: OEOPT.item_type_code = OE_GLOBALS.G_ITEM_MODEL))

2764: OELNK.top_model_line_id = OEOPT.top_model_line_id ))
2765: AND (OELNK.component_code = SUBSTR( OEOPT.component_code,1,
2766: LENGTH( RTRIM( OEOPT.component_code,'0123456789' )) - 1)
2767: OR (OELNK.component_code = OEOPT.component_code AND
2768: OEOPT.item_type_code = OE_GLOBALS.G_ITEM_MODEL))
2769: AND open_flag = 'Y'
2770: AND OELNK.shipped_quantity IS NULL
2771: )
2772: WHERE OEOPT.top_model_line_id = p_top_model_line_id

Line 2776: AND OEOPT.item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;

2772: WHERE OEOPT.top_model_line_id = p_top_model_line_id
2773: AND OEOPT.line_id <> p_top_model_line_id
2774: AND OEOPT.link_to_line_id IS NULL
2775: AND OEOPT.shipped_quantity IS NULL
2776: AND OEOPT.item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;
2777:
2778: IF SQL%FOUND THEN
2779: IF l_debug_level > 0 THEN
2780: oe_debug_pub.add('3 update_link_to_line_id2 UPDATED ' || SQL%ROWCOUNT ) ;

Line 2798: OEOPT.item_type_code = OE_GLOBALS.G_ITEM_MODEL))

2794: OELNK.top_model_line_id = OEOPT.top_model_line_id ))
2795: AND (OELNK.component_code = SUBSTR( OEOPT.component_code,1,
2796: LENGTH( RTRIM( OEOPT.component_code,'0123456789' )) - 1)
2797: OR (OELNK.component_code = OEOPT.component_code AND
2798: OEOPT.item_type_code = OE_GLOBALS.G_ITEM_MODEL))
2799: AND open_flag = 'Y'
2800: AND OELNK.shipped_quantity IS NOT NULL
2801: )
2802: WHERE OEOPT.top_model_line_id = p_top_model_line_id

Line 2806: AND OEOPT.item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;

2802: WHERE OEOPT.top_model_line_id = p_top_model_line_id
2803: AND OEOPT.line_id <> p_top_model_line_id
2804: AND OEOPT.link_to_line_id IS NULL
2805: AND OEOPT.shipped_quantity IS NOT NULL
2806: AND OEOPT.item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;
2807:
2808: IF SQL%FOUND THEN
2809: IF l_debug_level > 0 THEN
2810: oe_debug_pub.add('3b update_link_to_line_id2 UPDATED ' || SQL%ROWCOUNT ) ;

Line 2828: OEOPT.item_type_code = OE_GLOBALS.G_ITEM_MODEL))

2824: OELNK.top_model_line_id = OEOPT.top_model_line_id ))
2825: AND (OELNK.component_code = SUBSTR( OEOPT.component_code,1,
2826: LENGTH( RTRIM( OEOPT.component_code,'0123456789' )) - 1)
2827: OR (OELNK.component_code = OEOPT.component_code AND
2828: OEOPT.item_type_code = OE_GLOBALS.G_ITEM_MODEL))
2829: AND open_flag = 'Y'
2830: AND OELNK.shipped_quantity IS NULL
2831: )
2832: WHERE OEOPT.top_model_line_id = p_top_model_line_id

Line 2836: AND OEOPT.item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;

2832: WHERE OEOPT.top_model_line_id = p_top_model_line_id
2833: AND OEOPT.line_id <> p_top_model_line_id
2834: AND OEOPT.link_to_line_id IS NULL
2835: AND OEOPT.shipped_quantity IS NOT NULL
2836: AND OEOPT.item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;
2837:
2838: IF SQL%FOUND THEN
2839: IF l_debug_level > 0 THEN
2840: oe_debug_pub.add('3c update_link_to_line_id2 UPDATED ' || SQL%ROWCOUNT ) ;

Line 2863: AND OEOPT.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

2859: AND oe1.top_model_line_id = p_top_model_line_id
2860: AND oe1.open_flag = 'Y' )
2861: WHERE OEOPT.top_model_line_id = p_top_model_line_id
2862: AND OEOPT.line_id <> p_top_model_line_id
2863: AND OEOPT.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
2864: AND OEOPT.link_to_line_id is NULL
2865: AND OEOPT.split_from_line_id is NOT NULL
2866: AND OEOPT.open_flag = 'Y';
2867:

Line 2925: l_control_rec OE_GLOBALS.Control_Rec_Type;

2921: l_ato_line_rec OE_ORDER_PUB.Line_Rec_Type;
2922: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
2923: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2924: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2925: l_control_rec OE_GLOBALS.Control_Rec_Type;
2926: l_line_count NUMBER := 0;
2927: l_return_status VARCHAR2(1);
2928: l_sql_found NUMBER := 0; -- bug 12758138
2929:

Line 2937: AND item_type_code = OE_GLOBALS.G_ITEM_CLASS

2933: SELECT unique(ato_line_id)
2934: FROM oe_order_lines_all
2935: WHERE top_model_line_id = p_top_model_line_id
2936: AND ato_line_id is not null
2937: AND item_type_code = OE_GLOBALS.G_ITEM_CLASS
2938: AND open_flag = 'Y'; -- ato subconfigs
2939:
2940: CURSOR ATO_OPTIONS(p_ato_line_id IN NUMBER)
2941: IS

Line 3331: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

3327: IF l_debug_level > 0 THEN
3328: oe_debug_pub.add('UPDATING LINE: ' || L_OPTION_LINE_ID , 1 ) ;
3329: END IF;
3330:
3331: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
3332: l_line_rec.line_id := l_option_line_id;
3333: l_line_rec.project_id := l_ato_line_rec.project_id;
3334: l_line_rec.task_id := l_ato_line_rec.task_id;
3335: l_line_rec.ship_from_org_id := l_ato_line_rec.ship_from_org_id;

Line 3665: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND

3661:
3662: UPDATE oe_order_lines
3663: SET ato_line_id = NULL
3664: WHERE top_model_line_id = p_top_model_line_id
3665: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
3666: ato_line_id = line_id)
3667: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND --9775352
3668: ato_line_id = line_id);
3669: END IF;

Line 3667: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND --9775352

3663: SET ato_line_id = NULL
3664: WHERE top_model_line_id = p_top_model_line_id
3665: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
3666: ato_line_id = line_id)
3667: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND --9775352
3668: ato_line_id = line_id);
3669: END IF;
3670:
3671: IF p_remnant_flag is NULL THEN

Line 4115: l_control_rec OE_GLOBALS.Control_Rec_Type;

4111: l_index NUMBER;
4112: l_line_rec OE_Order_Pub.Line_Rec_Type
4113: := OE_Order_Pub.G_Miss_Line_Rec;
4114: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4115: l_control_rec OE_GLOBALS.Control_Rec_Type;
4116: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4117:
4118:
4119: CURSOR inc_items(p_link_to_line_id NUMBER,

Line 4126: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED;

4122: SELECT line_id, ordered_quantity
4123: FROM oe_order_lines
4124: WHERE top_model_line_id = p_top_model_line_id
4125: AND link_to_line_id = p_link_to_line_id
4126: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED;
4127:
4128: --
4129: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4130: --

Line 4206: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND

4202: l_line_rec.request_date := OE_MODIFY_INC_ITEMS_TBL(I).date_param1;
4203: END IF; -- request_date.
4204:
4205:
4206: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
4207: l_line_rec.ordered_quantity = 0 AND
4208: OE_MODIFY_INC_ITEMS_TBL(I).param11 = 'N'
4209: THEN
4210: IF l_debug_level > 0 THEN

Line 4213: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

4209: THEN
4210: IF l_debug_level > 0 THEN
4211: oe_debug_pub.add('DELETE SINCE NOT FULL CANCEL' , 3 ) ;
4212: END IF;
4213: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4214: END IF;
4215:
4216: IF l_debug_level > 0 THEN
4217: oe_debug_pub.add('QTY - OP '|| L_LINE_REC.ORDERED_QUANTITY

Line 4237: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

4233: ( p_line_tbl => l_line_tbl
4234: ,p_control_rec => l_control_rec
4235: ,x_return_status => l_return_status);
4236:
4237: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
4238:
4239: x_return_status := l_return_status;
4240: IF l_debug_level > 0 THEN
4241: oe_debug_pub.add('EXITING MODIFY_INCLUDED_ITEMS'|| L_RETURN_STATUS , 1 ) ;

Line 4360: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

4356: WHERE top_model_line_id = p_top_model_line_id
4357: AND line_id = l_rec.link_to_line_id;
4358:
4359: l_line_rec := OE_Order_Pub.G_Miss_Line_Rec;
4360: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4361: l_line_rec.line_id := l_rec.line_id;
4362: l_line_rec.ordered_quantity := l_ordered_qty; -- ratio??***
4363: l_line_rec.change_reason := 'SYSTEM';
4364: l_line_rec.change_comments := 'Included Items updation';

Line 4374: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

4370: END IF;
4371:
4372: EXCEPTION
4373: WHEN NO_DATA_FOUND THEN
4374: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4375: l_line_rec.line_id := l_rec.line_id;
4376: l_index := l_index + 1;
4377: p_x_line_tbl(l_index) := l_line_rec;
4378:

Line 4518: x_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

4514: ,x_line_rec => x_line_rec);
4515:
4516:
4517:
4518: x_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4519:
4520: OE_Line_Security.Entity
4521: ( p_line_rec => x_line_rec
4522: ,x_result => l_sec_result

Line 4561: x_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

4557: oe_debug_pub.add('do cancellation hence update with 0', 3 );
4558: END IF;
4559:
4560: x_line_rec.ordered_quantity := 0;
4561: x_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4562:
4563: IF p_change_reason is NOT NULL THEN
4564: x_line_rec.change_reason := p_change_reason;
4565: END IF;