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 129: ( p_entity_code => OE_Globals.G_ENTITY_LINE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 717: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1162: = OE_GLOBALS.G_OPR_INSERT OR

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

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

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

Line 1164: = OE_GLOBALS.G_OPR_CREATE

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

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

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

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

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

Line 1307: OE_GLOBALS.G_OPR_DELETE THEN

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

Line 1364: OE_GLOBALS.G_OPR_CREATE OR

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

Line 1366: OE_GLOBALS.G_OPR_INSERT

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

Line 1466: IF OE_GLOBALS.G_CONFIGURATOR_INSTALLED IS NULL THEN

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

Line 1467: OE_GLOBALS.G_CONFIGURATOR_INSTALLED

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

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

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

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

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

Line 1561: AND (item_type_code = OE_GLOBALS.G_ITEM_MODEL

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

Line 1562: OR item_type_code = OE_GLOBALS.G_ITEM_OPTION

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

Line 1563: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS

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

Line 1564: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);

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

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

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

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

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

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

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

Line 1855: <> OE_GLOBALS.G_OPR_DELETE AND

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