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

Line 5: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8656395

1: PACKAGE BODY OE_Process_Options_Pvt AS
2: /* $Header: OEXVOPTB.pls 120.4 2011/05/03 09:47:13 ckasera ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Process_Options_Pvt';
5: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8656395
6:
7:
8: /*-----------------------------------------------------------------------
9: Forward Declarations

Line 130: ( p_entity_code => OE_Globals.G_ENTITY_LINE

126: OE_Msg_Pub.Initialize;
127: END IF;
128:
129: OE_Msg_Pub.Set_Msg_Context
130: ( p_entity_code => OE_Globals.G_ENTITY_LINE
131: ,p_entity_id => p_top_model_line_id
132: ,p_header_id => p_header_id
133: ,p_line_id => p_top_model_line_id);
134:

Line 545: IF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE

541: ( p_x_option_rec => p_options_tbl(I)
542: ,p_top_model_line_id => p_top_model_line_id);
543: END IF;
544:
545: IF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE
546: THEN
547:
548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add('GET OLD QTY FOR '|| p_OPTIONS_TBL(I).LINE_ID,1);

Line 566: l_req_rec.param3 := OE_GLOBALS.G_ITEM_MODEL;

562: l_req_rec.param6 := p_options_tbl(I).change_reason;
563: l_req_rec.param7 := p_options_tbl(I).change_comments;
564:
565: IF p_options_tbl(I).bom_item_type = 1 THEN
566: l_req_rec.param3 := OE_GLOBALS.G_ITEM_MODEL;
567: ELSIF p_options_tbl(I).bom_item_type = 2 THEN
568: l_req_rec.param3 := OE_GLOBALS.G_ITEM_CLASS;
569: ELSE
570: l_req_rec.param3 := OE_GLOBALS.G_ITEM_OPTION;

Line 568: l_req_rec.param3 := OE_GLOBALS.G_ITEM_CLASS;

564:
565: IF p_options_tbl(I).bom_item_type = 1 THEN
566: l_req_rec.param3 := OE_GLOBALS.G_ITEM_MODEL;
567: ELSIF p_options_tbl(I).bom_item_type = 2 THEN
568: l_req_rec.param3 := OE_GLOBALS.G_ITEM_CLASS;
569: ELSE
570: l_req_rec.param3 := OE_GLOBALS.G_ITEM_OPTION;
571: END IF;
572:

Line 570: l_req_rec.param3 := OE_GLOBALS.G_ITEM_OPTION;

566: l_req_rec.param3 := OE_GLOBALS.G_ITEM_MODEL;
567: ELSIF p_options_tbl(I).bom_item_type = 2 THEN
568: l_req_rec.param3 := OE_GLOBALS.G_ITEM_CLASS;
569: ELSE
570: l_req_rec.param3 := OE_GLOBALS.G_ITEM_OPTION;
571: END IF;
572:
573: IF p_options_tbl(I).disabled_flag = 'Y' THEN
574: IF l_debug_level > 0 THEN

Line 595: ELSIF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_DELETE

591: l_req_rec.param10 := p_options_tbl(I).ordered_item ;
592:
593: p_x_updated_options_tbl(l_count) := l_req_rec;
594:
595: ELSIF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_DELETE
596: THEN
597: l_index := l_index + 1;
598: l_req_rec.param1 := p_top_model_line_id;
599: l_req_rec.param2 := p_options_tbl(I).component_code;

Line 602: l_req_rec.param3 := OE_GLOBALS.G_ITEM_MODEL;

598: l_req_rec.param1 := p_top_model_line_id;
599: l_req_rec.param2 := p_options_tbl(I).component_code;
600:
601: IF p_options_tbl(I).bom_item_type = 1 THEN
602: l_req_rec.param3 := OE_GLOBALS.G_ITEM_MODEL;
603: ELSIF p_options_tbl(I).bom_item_type = 2 THEN
604: l_req_rec.param3 := OE_GLOBALS.G_ITEM_CLASS;
605: ELSE
606: l_req_rec.param3 := OE_GLOBALS.G_ITEM_OPTION;

Line 604: l_req_rec.param3 := OE_GLOBALS.G_ITEM_CLASS;

600:
601: IF p_options_tbl(I).bom_item_type = 1 THEN
602: l_req_rec.param3 := OE_GLOBALS.G_ITEM_MODEL;
603: ELSIF p_options_tbl(I).bom_item_type = 2 THEN
604: l_req_rec.param3 := OE_GLOBALS.G_ITEM_CLASS;
605: ELSE
606: l_req_rec.param3 := OE_GLOBALS.G_ITEM_OPTION;
607: END IF;
608: -- 3563690

Line 606: l_req_rec.param3 := OE_GLOBALS.G_ITEM_OPTION;

602: l_req_rec.param3 := OE_GLOBALS.G_ITEM_MODEL;
603: ELSIF p_options_tbl(I).bom_item_type = 2 THEN
604: l_req_rec.param3 := OE_GLOBALS.G_ITEM_CLASS;
605: ELSE
606: l_req_rec.param3 := OE_GLOBALS.G_ITEM_OPTION;
607: END IF;
608: -- 3563690
609: l_req_rec.param10 := p_options_tbl(I).ordered_item ;
610:

Line 663: p_options_tbl(I).operation <> OE_GLOBALS.G_OPR_INSERT

659: || P_OPTIONS_TBL ( I ) .OPERATION , 1 ) ;
660: END IF;
661:
662: IF p_options_tbl(I).component_code = p_comp_code AND
663: p_options_tbl(I).operation <> OE_GLOBALS.G_OPR_INSERT
664: THEN
665: RETURN I;
666: END IF;
667:

Line 718: l_control_rec OE_GLOBALS.Control_Rec_Type;

714: ,p_ui_flag IN VARCHAR2
715: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
716: IS
717: -- process_order in params
718: l_control_rec OE_GLOBALS.Control_Rec_Type;
719: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
720: l_line_upd_rec OE_ORDER_PUB.Line_Rec_Type;
721: l_line_del_rec OE_ORDER_PUB.Line_Rec_Type;
722: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;

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

780: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
781: l_line_upd_rec := l_line_rec;
782: l_line_del_rec := l_line_rec;
783:
784: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
785: l_line_upd_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
786: l_line_del_rec.operation := OE_GLOBALS.G_OPR_DELETE;
787:
788: l_line_rec.header_id := p_model_line_rec.header_id;

Line 785: l_line_upd_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

781: l_line_upd_rec := l_line_rec;
782: l_line_del_rec := l_line_rec;
783:
784: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
785: l_line_upd_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
786: l_line_del_rec.operation := OE_GLOBALS.G_OPR_DELETE;
787:
788: l_line_rec.header_id := p_model_line_rec.header_id;
789: l_line_rec.top_model_line_id := p_model_line_rec.line_id;

Line 786: l_line_del_rec.operation := OE_GLOBALS.G_OPR_DELETE;

782: l_line_del_rec := l_line_rec;
783:
784: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
785: l_line_upd_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
786: l_line_del_rec.operation := OE_GLOBALS.G_OPR_DELETE;
787:
788: l_line_rec.header_id := p_model_line_rec.header_id;
789: l_line_rec.top_model_line_id := p_model_line_rec.line_id;
790: l_line_rec.item_identifier_type := 'INT';

Line 803: IF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_INSERT

799: IF l_debug_level > 0 THEN
800: oe_debug_pub.add(I|| ' OPEARION: '||P_OPTIONS_TBL(I).OPERATION ,1);
801: END IF;
802:
803: IF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_INSERT
804: THEN
805:
806: IF l_debug_level > 0 THEN
807: oe_debug_pub.add('INSERT: '|| P_OPTIONS_TBL(I).COMPONENT_CODE ,1);

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

890: l_line_rec.context := p_options_tbl(I).context;
891: l_line_rec.change_reason := 'SYSTEM';
892:
893: IF p_options_tbl(I).bom_item_type = 2 THEN
894: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;
895: ELSE
896: l_line_rec.item_type_code := null;
897: END IF;
898:

Line 904: ELSIF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE THEN

900: l_line_tbl(l_line_count) := l_line_rec;
901:
902: END IF;
903:
904: ELSIF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE THEN
905:
906: l_line_upd_rec.line_id := p_options_tbl(I).line_id;
907: l_line_upd_rec.component_code := p_options_tbl(I).component_code;
908: l_line_upd_rec.ordered_quantity := p_options_tbl(I).ordered_quantity;

Line 946: ELSIF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_DELETE THEN

942: IF l_debug_level > 0 THEN
943: oe_debug_pub.add('UPDATE LINE_ID: '|| P_OPTIONS_TBL(I).LINE_ID ,1);
944: END IF;
945:
946: ELSIF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_DELETE THEN
947:
948: l_line_del_rec.line_id := p_options_tbl(I).line_id;
949: l_line_del_rec.component_code := p_options_tbl(I).component_code;
950: l_line_count := l_line_count + 1;

Line 1081: p_x_option_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1077: oe_debug_pub.add('do cancellation hence update with 0', 3 );
1078: END IF;
1079:
1080: p_x_option_rec.ordered_quantity := 0;
1081: p_x_option_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1082:
1083: p_x_option_rec.change_reason := 'SYSTEM';
1084: p_x_option_rec.change_comments := 'DISABLED';
1085:

Line 1087: p_x_option_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1083: p_x_option_rec.change_reason := 'SYSTEM';
1084: p_x_option_rec.change_comments := 'DISABLED';
1085:
1086: ELSE
1087: p_x_option_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1088:
1089: IF l_debug_level > 0 THEN
1090: oe_debug_pub.add('no cancellation, delete ok ', 3 ) ;
1091: END IF;

Line 1162: IF nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)

1158: END IF;
1159:
1160: WHILE I is not null
1161: LOOP
1162: IF nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1163: = OE_GLOBALS.G_OPR_INSERT OR
1164: nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1165: = OE_GLOBALS.G_OPR_CREATE
1166: THEN

Line 1163: = OE_GLOBALS.G_OPR_INSERT OR

1159:
1160: WHILE I is not null
1161: LOOP
1162: IF nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1163: = OE_GLOBALS.G_OPR_INSERT OR
1164: nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1165: = OE_GLOBALS.G_OPR_CREATE
1166: THEN
1167: J := 2;

Line 1164: nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)

1160: WHILE I is not null
1161: LOOP
1162: IF nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1163: = OE_GLOBALS.G_OPR_INSERT OR
1164: nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1165: = OE_GLOBALS.G_OPR_CREATE
1166: THEN
1167: J := 2;
1168: l_orig_component := p_x_options_tbl(I).component_code;

Line 1165: = OE_GLOBALS.G_OPR_CREATE

1161: LOOP
1162: IF nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1163: = OE_GLOBALS.G_OPR_INSERT OR
1164: nvl(p_x_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1165: = OE_GLOBALS.G_OPR_CREATE
1166: THEN
1167: J := 2;
1168: l_orig_component := p_x_options_tbl(I).component_code;
1169: l_component :=

Line 1195: p_x_options_tbl(l_options_tbl_index).operation := OE_GLOBALS.G_OPR_INSERT;

1191: END IF;
1192: l_count := l_count + 1;
1193: l_options_tbl_index := l_options_tbl_index + 1;
1194: p_x_options_tbl(l_options_tbl_index).component_code := l_component;
1195: p_x_options_tbl(l_options_tbl_index).operation := OE_GLOBALS.G_OPR_INSERT;
1196: ELSE
1197: IF l_debug_level > 0 THEN
1198: oe_debug_pub.add( 'COMPONENT ALREADY PRESENT' , 1 ) ;
1199: END IF;

Line 1307: nvl(p_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE) <>

1303: || P_OPTIONS_TBL ( I ) .COMPONENT_CODE , 1 ) ;
1304: END IF;
1305:
1306: IF p_options_tbl(I).component_code = p_component AND
1307: nvl(p_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE) <>
1308: OE_GLOBALS.G_OPR_DELETE THEN
1309: IF l_debug_level > 0 THEN
1310: oe_debug_pub.add( 'COMPONENT FOUND' , 1 ) ;
1311: END IF;

Line 1308: OE_GLOBALS.G_OPR_DELETE THEN

1304: END IF;
1305:
1306: IF p_options_tbl(I).component_code = p_component AND
1307: nvl(p_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE) <>
1308: OE_GLOBALS.G_OPR_DELETE THEN
1309: IF l_debug_level > 0 THEN
1310: oe_debug_pub.add( 'COMPONENT FOUND' , 1 ) ;
1311: END IF;
1312: x_result := true;

Line 1365: OE_GLOBALS.G_OPR_CREATE OR

1361: || p_OPTIONS_TBL(l_outer_index).component_code,3);
1362: END IF;
1363:
1364: IF p_options_tbl(l_outer_index).operation =
1365: OE_GLOBALS.G_OPR_CREATE OR
1366: p_options_tbl(l_outer_index).operation =
1367: OE_GLOBALS.G_OPR_INSERT
1368: THEN
1369: IF l_debug_level > 0 THEN

Line 1367: OE_GLOBALS.G_OPR_INSERT

1363:
1364: IF p_options_tbl(l_outer_index).operation =
1365: OE_GLOBALS.G_OPR_CREATE OR
1366: p_options_tbl(l_outer_index).operation =
1367: OE_GLOBALS.G_OPR_INSERT
1368: THEN
1369: IF l_debug_level > 0 THEN
1370: oe_debug_pub.add( L_OUTER_INDEX || ' CHECK DUPL: '
1371: ||P_OPTIONS_TBL ( L_OUTER_INDEX ) .COMPONENT_CODE , 1 ) ;

Line 1467: IF OE_GLOBALS.G_CONFIGURATOR_INSTALLED IS NULL THEN

1463: IF l_debug_level > 0 THEN
1464: oe_debug_pub.add( 'ENTERING USE_CONFIGURATOR' , 1 ) ;
1465: END IF;
1466:
1467: IF OE_GLOBALS.G_CONFIGURATOR_INSTALLED IS NULL THEN
1468: OE_GLOBALS.G_CONFIGURATOR_INSTALLED
1469: := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(l_configurator_product_id);
1470: END IF;
1471:

Line 1468: OE_GLOBALS.G_CONFIGURATOR_INSTALLED

1464: oe_debug_pub.add( 'ENTERING USE_CONFIGURATOR' , 1 ) ;
1465: END IF;
1466:
1467: IF OE_GLOBALS.G_CONFIGURATOR_INSTALLED IS NULL THEN
1468: OE_GLOBALS.G_CONFIGURATOR_INSTALLED
1469: := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(l_configurator_product_id);
1470: END IF;
1471:
1472: l_profile_value := upper(FND_PROFILE.VALUE('ONT_USE_CONFIGURATOR'));

Line 1469: := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(l_configurator_product_id);

1465: END IF;
1466:
1467: IF OE_GLOBALS.G_CONFIGURATOR_INSTALLED IS NULL THEN
1468: OE_GLOBALS.G_CONFIGURATOR_INSTALLED
1469: := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(l_configurator_product_id);
1470: END IF;
1471:
1472: l_profile_value := upper(FND_PROFILE.VALUE('ONT_USE_CONFIGURATOR'));
1473:

Line 1475: IF OE_GLOBALS.G_CONFIGURATOR_INSTALLED = 'Y' THEN

1471:
1472: l_profile_value := upper(FND_PROFILE.VALUE('ONT_USE_CONFIGURATOR'));
1473:
1474: IF nvl(l_profile_value, 'Y') = 'Y' THEN
1475: IF OE_GLOBALS.G_CONFIGURATOR_INSTALLED = 'Y' THEN
1476: IF l_debug_level > 0 THEN
1477: oe_debug_pub.add('CONFIGURATOR IS INSTALLED PROFILE SET TO YES',1);
1478: END IF;
1479: RETURN true;

Line 1562: AND (item_type_code = OE_GLOBALS.G_ITEM_MODEL

1558: FROM oe_order_lines
1559: WHERE top_model_line_id = p_top_model_line_id
1560: AND open_flag = 'Y'
1561: AND nvl(config_header_id, -1) = -1
1562: AND (item_type_code = OE_GLOBALS.G_ITEM_MODEL
1563: OR item_type_code = OE_GLOBALS.G_ITEM_OPTION
1564: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
1565: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);
1566:

Line 1563: OR item_type_code = OE_GLOBALS.G_ITEM_OPTION

1559: WHERE top_model_line_id = p_top_model_line_id
1560: AND open_flag = 'Y'
1561: AND nvl(config_header_id, -1) = -1
1562: AND (item_type_code = OE_GLOBALS.G_ITEM_MODEL
1563: OR item_type_code = OE_GLOBALS.G_ITEM_OPTION
1564: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
1565: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);
1566:
1567: I NUMBER;

Line 1564: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS

1560: AND open_flag = 'Y'
1561: AND nvl(config_header_id, -1) = -1
1562: AND (item_type_code = OE_GLOBALS.G_ITEM_MODEL
1563: OR item_type_code = OE_GLOBALS.G_ITEM_OPTION
1564: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
1565: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);
1566:
1567: I NUMBER;
1568: l_config_effective_date DATE;

Line 1565: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);

1561: AND nvl(config_header_id, -1) = -1
1562: AND (item_type_code = OE_GLOBALS.G_ITEM_MODEL
1563: OR item_type_code = OE_GLOBALS.G_ITEM_OPTION
1564: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
1565: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);
1566:
1567: I NUMBER;
1568: l_config_effective_date DATE;
1569: l_frozen_model_bill VARCHAR2(1) := 'Y';

Line 1752: x_options_tbl(I).operation := OE_GLOBALS.G_OPR_CREATE;

1748: x_options_tbl(I).context := opt_rec.context;
1749:
1750: IF opt_rec.configuration_id is NULL AND opt_rec.config_header_id is NULL
1751: THEN
1752: x_options_tbl(I).operation := OE_GLOBALS.G_OPR_CREATE;
1753: ELSE
1754: x_options_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1755: END IF;
1756:

Line 1754: x_options_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1750: IF opt_rec.configuration_id is NULL AND opt_rec.config_header_id is NULL
1751: THEN
1752: x_options_tbl(I).operation := OE_GLOBALS.G_OPR_CREATE;
1753: ELSE
1754: x_options_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1755: END IF;
1756:
1757: x_options_tbl(I).line_id := opt_rec.line_id;
1758:

Line 1855: IF nvl(p_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)

1851: oe_debug_pub.add(P_OPTIONS_TBL(I).disabled_flag || ' child '
1852: || P_OPTIONS_TBL(I).line_id,1);
1853: END IF;
1854:
1855: IF nvl(p_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1856: <> OE_GLOBALS.G_OPR_DELETE AND
1857: nvl(p_options_tbl(I).disabled_flag, 'N') = 'N' THEN
1858:
1859: IF l_debug_level > 0 THEN

Line 1856: <> OE_GLOBALS.G_OPR_DELETE AND

1852: || P_OPTIONS_TBL(I).line_id,1);
1853: END IF;
1854:
1855: IF nvl(p_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)
1856: <> OE_GLOBALS.G_OPR_DELETE AND
1857: nvl(p_options_tbl(I).disabled_flag, 'N') = 'N' THEN
1858:
1859: IF l_debug_level > 0 THEN
1860: oe_debug_pub.add