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 577: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

573: l_line_count := nvl(p_x_line_tbl.LAST, 0);
574: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
575:
576: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
577: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
578: l_line_rec.header_id := p_model_line_rec.header_id;
579: l_line_rec.item_identifier_type := 'INT';
580: l_line_rec.config_header_id := p_config_hdr_id;
581: l_line_rec.config_rev_nbr := p_config_rev_nbr;

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

766: l_line_rec.ordered_item := l_concatenated_segments;
767:
768: IF config_rec.bom_item_type = 1 OR
769: config_rec.bom_item_type = 2 THEN
770: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;
771: ELSE
772: l_line_rec.item_type_code := null;
773: END IF;
774:

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

849: l_line_count := nvl(p_x_line_tbl.LAST, 0);
850: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
851:
852: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
853: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
854: l_line_rec.header_id := p_model_line_rec.header_id;
855: l_line_rec.item_identifier_type := 'INT';
856:
857:

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

934: l_line_rec.ordered_item := l_concatenated_segments;
935:
936: IF config_rec.bom_item_type = 1 OR
937: config_rec.bom_item_type = 2 THEN
938: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;
939: ELSE
940: l_line_rec.item_type_code := null;
941: END IF;
942:

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

1035: l_line_count := nvl(p_x_line_tbl.LAST, 0);
1036: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
1037:
1038: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1039: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1040: l_line_rec.top_model_line_id := p_model_line_rec.line_id;
1041:
1042:
1043: FOR config_rec in config_upd_cursor

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

1073: l_line_rec.change_reason := 'CONFIGURATOR';
1074: l_line_rec.change_comments := 'Changes in Configurator Window';
1075: END IF;
1076:
1077: IF p_direct_save AND config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS
1078: THEN
1079: l_class_line_count := l_class_line_count+1;
1080: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1081: ELSE

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

1143: l_line_count := nvl(p_x_line_tbl.LAST, 0);
1144: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
1145:
1146: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1147: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1148: l_line_rec.top_model_line_id := p_model_line_rec.line_id;
1149:
1150:
1151: FOR config_rec in config_upd_cursor

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

1168: l_line_rec.change_reason := 'CONFIGURATOR';
1169: l_line_rec.change_comments := 'Changes in Configurator Window';
1170: END IF;
1171:
1172: IF p_direct_save AND config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS
1173: THEN
1174: l_class_line_count := l_class_line_count+1;
1175: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1176: ELSE

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

1224: SELECT l.line_id, l.item_type_code, l.link_to_line_id,
1225: l.component_code, nvl(l.cancelled_flag, 'N') cancelled_flag
1226: FROM oe_order_lines l
1227: WHERE l.top_model_line_id = p_model_line_rec.line_id
1228: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1229: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1230: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1231: AND l.open_flag = 'Y'
1232: AND

Line 1229: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1225: l.component_code, nvl(l.cancelled_flag, 'N') cancelled_flag
1226: FROM oe_order_lines l
1227: WHERE l.top_model_line_id = p_model_line_rec.line_id
1228: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1229: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1230: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1231: AND l.open_flag = 'Y'
1232: AND
1233: (NOT EXISTS

Line 1230: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)

1226: FROM oe_order_lines l
1227: WHERE l.top_model_line_id = p_model_line_rec.line_id
1228: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1229: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1230: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1231: AND l.open_flag = 'Y'
1232: AND
1233: (NOT EXISTS
1234: ( SELECT 'X'

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

1326: oe_debug_pub.add( 'DELETING LINE : ' || CONFIG_REC.LINE_ID ) ;
1327: END IF;
1328:
1329: l_line_rec.line_id := config_rec.line_id;
1330: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1331:
1332: IF l_debug_level > 0 THEN
1333: oe_debug_pub.add('LINE_ID TO BE DELETED: ' || CONFIG_REC.LINE_ID ,1);
1334: END IF;

Line 1337: config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS

1333: oe_debug_pub.add('LINE_ID TO BE DELETED: ' || CONFIG_REC.LINE_ID ,1);
1334: END IF;
1335:
1336: IF p_direct_save AND
1337: config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS
1338: THEN
1339: l_class_line_count := l_class_line_count+1;
1340: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1341: ELSE

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

1350:
1351: IF config_rec.cancelled_flag = 'N' THEN
1352:
1353: l_line_rec.line_id := config_rec.line_id;
1354: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1355: l_line_rec.ordered_quantity := 0;
1356:
1357: IF p_direct_save AND
1358: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS

Line 1358: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS

1354: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1355: l_line_rec.ordered_quantity := 0;
1356:
1357: IF p_direct_save AND
1358: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS
1359: THEN
1360: l_class_line_count := l_class_line_count+1;
1361: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1362: ELSE

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

1413: SELECT l.line_id, l.item_type_code, l.link_to_line_id,
1414: l.component_code
1415: FROM oe_order_lines l
1416: WHERE l.top_model_line_id = p_model_line_rec.line_id
1417: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1418: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1419: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1420: AND l.open_flag = 'Y'
1421: AND

Line 1418: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1414: l.component_code
1415: FROM oe_order_lines l
1416: WHERE l.top_model_line_id = p_model_line_rec.line_id
1417: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1418: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1419: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1420: AND l.open_flag = 'Y'
1421: AND
1422: (NOT EXISTS

Line 1419: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)

1415: FROM oe_order_lines l
1416: WHERE l.top_model_line_id = p_model_line_rec.line_id
1417: AND (l.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1418: l.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1419: l.item_type_code = OE_GLOBALS.G_ITEM_KIT)
1420: AND l.open_flag = 'Y'
1421: AND
1422: (NOT EXISTS
1423: ( SELECT 'X'

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

1490: oe_debug_pub.add( 'DELETING LINE : ' || CONFIG_REC.LINE_ID ) ;
1491: END IF;
1492:
1493: l_line_rec.line_id := config_rec.line_id;
1494: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1495:
1496: IF l_debug_level > 0 THEN
1497: oe_debug_pub.add('LINE_ID TO BE DELETED: '||CONFIG_REC.LINE_ID,1);
1498: END IF;

Line 1501: config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS

1497: oe_debug_pub.add('LINE_ID TO BE DELETED: '||CONFIG_REC.LINE_ID,1);
1498: END IF;
1499:
1500: IF p_direct_save AND
1501: config_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS
1502: THEN
1503: l_class_line_count := l_class_line_count+1;
1504: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1505: ELSE

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

1514:
1515: IF l_qty <> 0 OR
1516: p_ui_flag = 'Y' THEN
1517: l_line_rec.line_id := config_rec.line_id;
1518: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1519: l_line_rec.ordered_quantity := 0;
1520: l_line_rec.change_reason := 'SYSTEM';
1521: l_line_rec.change_comments := 'Change Cascaded';
1522:

Line 1524: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS

1520: l_line_rec.change_reason := 'SYSTEM';
1521: l_line_rec.change_comments := 'Change Cascaded';
1522:
1523: IF p_direct_save AND
1524: config_rec.item_type_code =OE_GLOBALS.G_ITEM_CLASS
1525: THEN
1526: l_class_line_count := l_class_line_count+1;
1527: p_x_class_line_tbl(l_class_line_count) := l_line_rec;
1528: ELSE

Line 1674: IF p_item_type_code = OE_GLOBALS.G_ITEM_CLASS AND

1670: END IF;
1671:
1672: END LOOP;
1673:
1674: IF p_item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
1675: l_open_flag = 'Y'
1676: THEN
1677:
1678: IF l_debug_level > 0 THEN

Line 1813: ,p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type

1809: PROCEDURE Call_Process_Order
1810: ( p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1811: ,p_class_line_tbl IN OE_Order_Pub.Line_Tbl_Type
1812: := OE_ORDER_PUB.G_MISS_LINE_TBL
1813: ,p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type
1814: ,p_ui_flag IN VARCHAR2 := 'N'
1815: ,p_top_model_line_id IN NUMBER := null
1816: ,p_config_hdr_id IN NUMBER := null
1817: ,p_config_rev_nbr IN NUMBER := null

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

1858: p_control_rec.controlled_operation := TRUE;
1859: p_control_rec.change_attributes := TRUE;
1860: p_control_rec.validate_entity := TRUE;
1861: p_control_rec.write_to_DB := TRUE;
1862: p_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
1863:
1864: -- change made for bug 2350478
1865: IF p_ui_flag = 'Y' THEN
1866: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'Y';

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

1883: , p_x_old_line_tbl => l_old_line_tbl
1884: , x_return_status => l_return_status);
1885: Print_Time('call to lines end time');
1886:
1887: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
1888: --OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'N';
1889: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y';
1890: OE_CONFIG_PVT.OECFG_CONFIGURATION_PRICING := 'N';
1891: OE_CONFIG_UTIL.G_CONFIG_UI_USED := 'N';

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

1923: oe_debug_pub.add('I: '|| P_CLASS_LINE_TBL ( I ) .LINE_ID , 1 ) ;
1924: END IF;
1925: l_line_rec := p_class_line_tbl(I);
1926:
1927: IF l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1928:
1929: /* Bug 4165102 : Call to Globalization hook is included for class lines
1930: * if the profile option 'OM: Configuration Quick Save' is set to Yes.
1931: * Note: JG API defaults global_attributes ,only if they are passed as

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

1989: IF ( Nvl(l_line_rec.transaction_phase_code, 'F') <> 'N' ) THEN
1990: OE_Order_WF_Util.CreateStart_LineProcess(l_line_rec);
1991: END IF;
1992:
1993: ELSIF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1994: IF l_debug_level > 0 THEN
1995: oe_debug_pub.add('UPDATE: ' || L_LINE_REC.LINE_ID , 1 ) ;
1996: END IF;
1997:

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

1998: UPDATE oe_order_lines
1999: SET ordered_quantity = l_line_rec.ordered_quantity
2000: WHERE line_id = l_line_rec.line_id;
2001:
2002: ELSIF l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2003: IF l_debug_level > 0 THEN
2004: oe_debug_pub.add('DELETE: ' || L_LINE_REC.LINE_ID , 1 ) ;
2005: END IF;
2006:

Line 2058: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER

2054: p_line_tbl.COUNT > 0 THEN
2055:
2056: IF (p_line_tbl(1).booked_flag = 'Y') THEN
2057: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2058: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
2059: ,p_delete => FND_API.G_TRUE
2060: ,x_return_status => l_return_status
2061: );
2062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2178: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED

2174: FROM oe_order_lines
2175: WHERE top_model_line_id = p_top_model_line_id
2176: AND line_id <> p_top_model_line_id
2177: AND service_reference_line_id is null
2178: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED
2179: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
2180: order by sort_order;
2181:
2182: --

Line 2179: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG

2175: WHERE top_model_line_id = p_top_model_line_id
2176: AND line_id <> p_top_model_line_id
2177: AND service_reference_line_id is null
2178: AND item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED
2179: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
2180: order by sort_order;
2181:
2182: --
2183: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2240: l_model_item_type_code = OE_GLOBALS.G_ITEM_MODEL AND

2236:
2237: --/*** update ato line_id and related attributes for subconfig **/
2238:
2239: IF (p_operation = 'C' OR p_operation = 'A') AND
2240: l_model_item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
2241: l_model_ato_line_id is NULL
2242: THEN
2243: IF l_debug_level > 0 THEN
2244: oe_debug_pub.add('UPDATE ATO ATTRIBS FOR SUBASSEMBLIES' , 1 ) ;

Line 2255: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG

2251: UPDATE oe_order_lines
2252: SET shippable_flag = 'N'
2253: WHERE top_model_line_id = p_top_model_line_id
2254: AND ato_line_id is NOT NULL
2255: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
2256: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2257: ato_line_id = line_id);
2258: END IF;
2259:

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

2252: SET shippable_flag = 'N'
2253: WHERE top_model_line_id = p_top_model_line_id
2254: AND ato_line_id is NOT NULL
2255: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
2256: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2257: ato_line_id = line_id);
2258: END IF;
2259:
2260:

Line 2368: (l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

2364: -- fix for 3082485 ends
2365:
2366:
2367: IF l_model_ato_line_id is NULL AND
2368: (l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2369: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
2370: THEN
2371: BEGIN
2372: UPDATE oe_order_lines

Line 2369: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)

2365:
2366:
2367: IF l_model_ato_line_id is NULL AND
2368: (l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2369: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
2370: THEN
2371: BEGIN
2372: UPDATE oe_order_lines
2373: SET option_number = l_option_nbr,

Line 2414: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG

2410: (SELECT ordered_quantity
2411: FROM oe_order_lines
2412: WHERE line_id = o.link_to_line_id)
2413: WHERE top_model_line_id = p_top_model_line_id
2414: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG
2415: AND nvl(model_remnant_flag, 'N') = 'N';
2416:
2417: UPDATE oe_order_lines
2418: SET cancelled_flag = 'Y'

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

2536: OELNK.top_model_line_id = OEOPT.top_model_line_id ))
2537: AND (OELNK.component_code = SUBSTR( OEOPT.component_code,1,
2538: LENGTH( RTRIM( OEOPT.component_code,'0123456789' )) - 1)
2539: OR (OELNK.component_code = OEOPT.component_code AND
2540: OEOPT.item_type_code = OE_GLOBALS.G_ITEM_MODEL))
2541: AND open_flag = 'Y'
2542: )
2543: WHERE OEOPT.top_model_line_id = p_top_model_line_id
2544: AND OEOPT.line_id <> p_top_model_line_id

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

2542: )
2543: WHERE OEOPT.top_model_line_id = p_top_model_line_id
2544: AND OEOPT.line_id <> p_top_model_line_id
2545: AND OEOPT.link_to_line_id IS NULL
2546: AND OEOPT.item_type_code <> OE_GLOBALS.G_ITEM_INCLUDED;
2547:
2548: IF SQL%FOUND THEN
2549: IF l_debug_level > 0 THEN
2550: oe_debug_pub.add('3 LLID UPDATED ' || SQL%ROWCOUNT ) ;

Line 2569: AND OEOPT.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

2565: AND oe1.top_model_line_id = p_top_model_line_id
2566: AND oe1.open_flag = 'Y' )
2567: WHERE OEOPT.top_model_line_id = p_top_model_line_id
2568: AND OEOPT.line_id <> p_top_model_line_id
2569: AND OEOPT.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
2570: AND OEOPT.link_to_line_id is NULL
2571: AND OEOPT.split_from_line_id is NOT NULL
2572: AND OEOPT.open_flag = 'Y';
2573:

Line 2631: l_control_rec OE_GLOBALS.Control_Rec_Type;

2627: l_ato_line_rec OE_ORDER_PUB.Line_Rec_Type;
2628: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
2629: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2630: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2631: l_control_rec OE_GLOBALS.Control_Rec_Type;
2632: l_line_count NUMBER := 0;
2633: l_return_status VARCHAR2(1);
2634:
2635: -- cursor modified, ## 1820608

Line 2642: AND item_type_code = OE_GLOBALS.G_ITEM_CLASS

2638: SELECT unique(ato_line_id)
2639: FROM oe_order_lines_all
2640: WHERE top_model_line_id = p_top_model_line_id
2641: AND ato_line_id is not null
2642: AND item_type_code = OE_GLOBALS.G_ITEM_CLASS
2643: AND open_flag = 'Y'; -- ato subconfigs
2644:
2645: CURSOR ATO_OPTIONS(p_ato_line_id IN NUMBER)
2646: IS

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

2897: IF l_debug_level > 0 THEN
2898: oe_debug_pub.add('UPDATING LINE: ' || L_OPTION_LINE_ID , 1 ) ;
2899: END IF;
2900:
2901: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2902: l_line_rec.line_id := l_option_line_id;
2903: l_line_rec.project_id := l_ato_line_rec.project_id;
2904: l_line_rec.task_id := l_ato_line_rec.task_id;
2905: l_line_rec.ship_from_org_id := l_ato_line_rec.ship_from_org_id;

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

3231:
3232: UPDATE oe_order_lines
3233: SET ato_line_id = NULL
3234: WHERE top_model_line_id = p_top_model_line_id
3235: AND NOT (item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
3236: ato_line_id = line_id);
3237: END IF;
3238:
3239: IF p_remnant_flag is NULL THEN

Line 3683: l_control_rec OE_GLOBALS.Control_Rec_Type;

3679: l_index NUMBER;
3680: l_line_rec OE_Order_Pub.Line_Rec_Type
3681: := OE_Order_Pub.G_Miss_Line_Rec;
3682: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3683: l_control_rec OE_GLOBALS.Control_Rec_Type;
3684: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3685:
3686:
3687: CURSOR inc_items(p_link_to_line_id NUMBER,

Line 3694: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED;

3690: SELECT line_id, ordered_quantity
3691: FROM oe_order_lines
3692: WHERE top_model_line_id = p_top_model_line_id
3693: AND link_to_line_id = p_link_to_line_id
3694: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED;
3695:
3696: --
3697: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3698: --

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

3770: l_line_rec.request_date := OE_MODIFY_INC_ITEMS_TBL(I).date_param1;
3771: END IF; -- request_date.
3772:
3773:
3774: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
3775: l_line_rec.ordered_quantity = 0 AND
3776: OE_MODIFY_INC_ITEMS_TBL(I).param11 = 'N'
3777: THEN
3778: IF l_debug_level > 0 THEN

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

3777: THEN
3778: IF l_debug_level > 0 THEN
3779: oe_debug_pub.add('DELETE SINCE NOT FULL CANCEL' , 3 ) ;
3780: END IF;
3781: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3782: END IF;
3783:
3784: IF l_debug_level > 0 THEN
3785: oe_debug_pub.add('QTY - OP '|| L_LINE_REC.ORDERED_QUANTITY

Line 3805: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

3801: ( p_line_tbl => l_line_tbl
3802: ,p_control_rec => l_control_rec
3803: ,x_return_status => l_return_status);
3804:
3805: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
3806:
3807: x_return_status := l_return_status;
3808: IF l_debug_level > 0 THEN
3809: oe_debug_pub.add('EXITING MODIFY_INCLUDED_ITEMS'|| L_RETURN_STATUS , 1 ) ;

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

3924: WHERE top_model_line_id = p_top_model_line_id
3925: AND line_id = l_rec.link_to_line_id;
3926:
3927: l_line_rec := OE_Order_Pub.G_Miss_Line_Rec;
3928: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
3929: l_line_rec.line_id := l_rec.line_id;
3930: l_line_rec.ordered_quantity := l_ordered_qty; -- ratio??***
3931: l_line_rec.change_reason := 'SYSTEM';
3932: l_line_rec.change_comments := 'Included Items updation';

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

3938: END IF;
3939:
3940: EXCEPTION
3941: WHEN NO_DATA_FOUND THEN
3942: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3943: l_line_rec.line_id := l_rec.line_id;
3944: l_index := l_index + 1;
3945: p_x_line_tbl(l_index) := l_line_rec;
3946:

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

4082: ,x_line_rec => x_line_rec);
4083:
4084:
4085:
4086: x_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4087:
4088: OE_Line_Security.Entity
4089: ( p_line_rec => x_line_rec
4090: ,x_result => l_sec_result

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

4125: oe_debug_pub.add('do cancellation hence update with 0', 3 );
4126: END IF;
4127:
4128: x_line_rec.ordered_quantity := 0;
4129: x_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4130:
4131: IF p_change_reason is NOT NULL THEN
4132: x_line_rec.change_reason := p_change_reason;
4133: END IF;