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_SPLIT_UTIL dependencies on OE_SPLIT_UTIL

Line 1: PACKAGE BODY OE_split_util AS

1: PACKAGE BODY OE_split_util AS
2: /* $Header: OEXUSPLB.pls 120.13.12010000.3 2008/11/10 07:47:38 snimmaga ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Split_Util';
4: G_min_model NUMBER;
5: G_max_model NUMBER;

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Split_Util';

1: PACKAGE BODY OE_split_util AS
2: /* $Header: OEXUSPLB.pls 120.13.12010000.3 2008/11/10 07:47:38 snimmaga ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Split_Util';
4: G_min_model NUMBER;
5: G_max_model NUMBER;
6: g_over_shipment boolean := false;
7: g_remnant_only Boolean := FALSE;

Line 248: g_split_line_tbl oe_split_util.split_line_tbl) IS

244: END Check_Complete_Shipment;
245:
246: Procedure Get_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
247: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type,
248: g_split_line_tbl oe_split_util.split_line_tbl) IS
249: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
250: l_line_id NUMBER;
251: l_service_count NUMBER := 1;
252: l_ser_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;

Line 298: OE_Split_Util.Default_Attributes(

294: l_ser_line_tbl(l_service_count).line_id := fnd_api.g_miss_num;
295: l_ser_line_tbl(l_service_count).split_from_line_id := l_ser_rec.line_id;
296: l_ser_line_tbl(l_service_count).operation := oe_globals.g_opr_create;
297: g_qry_out_rec := l_ser_line_tbl(l_service_count) ;
298: OE_Split_Util.Default_Attributes(
299: p_x_line_rec =>g_qry_out_rec
300: , p_old_line_rec => l_ser_line_tbl(l_service_count)
301: );
302: l_ser_line_tbl(l_service_count) := g_qry_out_rec;

Line 485: OE_Split_Util.Default_Attributes

481: oe_debug_pub.add('Line set id is : '||l_set_id,5) ;
482: END IF;
483: l_parent_line.line_id := fnd_api.g_miss_num;
484: l_parent_line.orig_sys_line_ref :=fnd_api.g_miss_char; -- Bug5207907
485: OE_Split_Util.Default_Attributes
486: (p_x_line_rec => l_parent_line,
487: p_old_line_rec => l_parent_line );
488: IF l_parent_line.line_set_id is null AND l_set_id IS NULL THEN
489: Oe_Set_Util.Create_Line_Set(p_x_line_rec => l_parent_line);

Line 507: OE_Split_Util.Default_Attributes

503: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
504: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
505: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
506: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
507: OE_Split_Util.Default_Attributes
508: ( p_x_line_rec => g_qry_out_rec
509: ,p_old_line_rec => l_option_line_tbl(l_option_count)
510: );
511: l_option_line_tbl(l_option_count) := g_qry_out_rec;

Line 561: OE_Split_Util.Default_Attributes

557: l_parent_line.line_id := fnd_api.g_miss_num;
558: l_parent_line.config_header_id := NULL;
559: l_parent_line.config_rev_nbr := NULL;
560: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
561: OE_Split_Util.Default_Attributes
562: (p_x_line_rec => l_parent_line
563: ,p_old_line_rec => l_parent_line
564: );
565: l_rem_top_model_line_id := l_parent_line.line_id;

Line 606: OE_Split_Util.Default_Attributes

602: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
603: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
604: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
605: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
606: OE_Split_Util.Default_Attributes
607: ( p_x_line_rec => g_qry_out_rec
608: ,p_old_line_rec => l_option_line_tbl(l_option_count)
609: );
610: l_option_line_tbl(l_option_count) := g_qry_out_rec;

Line 653: OE_Split_Util.Default_Attributes

649: l_parent_line.split_by := 'SYSTEM';
650: l_parent_line.split_from_line_id := l_parent_line.line_id;
651: l_parent_line.line_id := fnd_api.g_miss_num;
652: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
653: OE_Split_Util.Default_Attributes
654: ( p_x_line_rec => l_parent_line
655: , p_old_line_rec => l_parent_line
656: );
657: l_parent_line.line_set_id := l_set_id;

Line 702: OE_Split_Util.Default_Attributes

698: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
699: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
700: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
701: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
702: OE_Split_Util.Default_Attributes
703: ( p_x_line_rec => g_qry_out_rec
704: ,p_old_line_rec => l_option_line_tbl(l_option_count)
705: );
706: l_option_line_tbl(l_option_count) := g_qry_out_rec;

Line 884: OE_Split_Util.Default_Attributes

880: oe_debug_pub.add( 'LINE SET IS-'||L_SET_ID ) ;
881: END IF;
882: l_parent_line.line_id := fnd_api.g_miss_num;
883: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
884: OE_Split_Util.Default_Attributes
885: (p_x_line_rec => l_parent_line
886: ,p_old_line_rec => l_parent_line );
887: IF l_parent_line.line_set_id is null AND l_set_id IS NULL THEN
888: Oe_Set_Util.Create_Line_Set(p_x_line_rec => l_parent_line);

Line 906: OE_Split_Util.Default_Attributes

902: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
903: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
904: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
905: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
906: OE_Split_Util.Default_Attributes
907: (p_x_line_rec => g_qry_out_rec
908: ,p_old_line_rec => l_option_line_tbl(l_option_count)
909: );
910: l_option_line_tbl(l_option_count) := g_qry_out_rec;

Line 962: OE_Split_Util.Default_Attributes

958: l_parent_line.line_id := fnd_api.g_miss_num;
959: l_parent_line.config_header_id := NULL;
960: l_parent_line.config_rev_nbr := NULL;
961: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
962: OE_Split_Util.Default_Attributes
963: ( p_x_line_rec => l_parent_line
964: ,p_old_line_rec => l_parent_line );
965: l_rem_shp_top_model_line_id := l_parent_line.line_id;
966: IF l_parent_line.line_set_id is null AND l_set_id IS NULL THEN

Line 993: OE_Split_Util.Default_Attributes

989: l_parent_line.operation := oe_globals.g_opr_create;
990: l_parent_line.split_by := 'SYSTEM';
991: l_parent_line.split_from_line_id := l_parent_line.line_id;
992: l_parent_line.line_id := fnd_api.g_miss_num;
993: OE_Split_Util.Default_Attributes
994: ( p_x_line_rec => l_parent_line
995: ,p_old_line_rec => l_parent_line
996: );
997: l_parent_line.line_set_id := l_set_id;

Line 1037: OE_Split_Util.Default_Attributes

1033: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1034: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1035: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1036: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1037: OE_Split_Util.Default_Attributes
1038: (p_x_line_rec => g_qry_out_rec
1039: , p_old_line_rec => l_option_line_tbl(l_option_count));
1040: l_option_line_tbl(l_option_count) := g_qry_out_rec;
1041: l_option_line_tbl(l_option_count).ordered_quantity :=

Line 1109: OE_Split_Util.Default_Attributes

1105: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1106: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1107: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1108: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1109: OE_Split_Util.Default_Attributes
1110: ( p_x_line_rec => g_qry_out_rec
1111: , p_old_line_rec => l_option_line_tbl(l_option_count)
1112: );
1113: l_option_line_tbl(l_option_count) := g_qry_out_rec;

Line 1189: l_split_line_tbl oe_split_util.split_line_tbl;

1185: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1186: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1187: l_adjustment_count NUMBER := 0;
1188: l_scredit_count NUMBER := 0;
1189: l_split_line_tbl oe_split_util.split_line_tbl;
1190: l_split_count NUMBER := 0;
1191: l_model_map_tbl oe_split_util.model_map_tbl;
1192: l_map_count NUMBER := 0;
1193: Type Optioncur IS REF CURSOR;

Line 1191: l_model_map_tbl oe_split_util.model_map_tbl;

1187: l_adjustment_count NUMBER := 0;
1188: l_scredit_count NUMBER := 0;
1189: l_split_line_tbl oe_split_util.split_line_tbl;
1190: l_split_count NUMBER := 0;
1191: l_model_map_tbl oe_split_util.model_map_tbl;
1192: l_map_count NUMBER := 0;
1193: Type Optioncur IS REF CURSOR;
1194: Optrec Optioncur;
1195: --

Line 1274: OE_Split_Util.Default_Attributes ( p_x_line_rec => g_qry_out_rec

1270: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1271: l_option_line_tbl(l_option_count).split_by := p_line_tbl(p_index).split_by;
1272: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1273: g_qry_out_rec.orig_sys_line_ref :=fnd_api.g_miss_char; --bug5207907
1274: OE_Split_Util.Default_Attributes ( p_x_line_rec => g_qry_out_rec
1275: ,p_old_line_rec => l_option_line_tbl(l_option_count));
1276: l_option_line_tbl(l_option_count) := g_qry_out_rec;
1277: l_option_line_tbl(l_option_count).top_model_line_id := g_split_line_tbl(I).line_id;
1278: IF l_option_line_tbl(l_option_count).ato_line_id is not null AND

Line 1397: IF oe_split_util.g_sch_recursion = 'FALSE' THEN

1393: l_code_level := OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL;
1394: IF l_debug_level > 0 THEN
1395: oe_debug_pub.add( 'L_CODE_LEVEL = '||L_CODE_LEVEL , 5 ) ;
1396: END IF;
1397: IF oe_split_util.g_sch_recursion = 'FALSE' THEN
1398: IF l_debug_level > 0 THEN
1399: oe_debug_pub.add( 'ENTER DEFAULT ATTRIBUTES FOR SPLIT' ) ;
1400: END IF;
1401: IF l_debug_level > 0 THEN

Line 1609: l_Split_line_Tbl OE_SPLIT_UTIL.Split_line_Tbl;

1605: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1606: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1607: l_adjustment_count NUMBER := 0;
1608: l_scredit_count NUMBER := 0;
1609: l_Split_line_Tbl OE_SPLIT_UTIL.Split_line_Tbl;
1610: l_split_count NUMBER := 0;
1611: l_miss_rec OE_Order_Pub.Line_rec_type := oe_order_pub.g_miss_line_rec;
1612: l_sch_tbl OE_Order_Pub.Line_tbl_type;
1613: l_sch_count NUMBER := 0;

Line 1625: IF oe_split_util.g_sch_recursion = 'FALSE' AND NOT g_non_prop_split THEN

1621: IF l_debug_level > 0 THEN
1622: oe_debug_pub.add( 'ENTER CHECK SPLIT COURSE' ) ;
1623: END IF;
1624: l_line_tbl := p_x_line_tbl;
1625: IF oe_split_util.g_sch_recursion = 'FALSE' AND NOT g_non_prop_split THEN
1626: -- Loop Through Lines Table to find Split Action
1627: -- i := l_line_tbl.First;
1628: -- This Check is to make sure Split will not process any table
1629: -- that is not in sesequence. It will fail if there is a gap in the

Line 1751: OE_Split_Util.Default_Attributes (p_x_line_rec => g_qry_out_rec

1747: END IF;
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750: g_qry_out_rec := l_line_tbl(J);
1751: OE_Split_Util.Default_Attributes (p_x_line_rec => g_qry_out_rec
1752: ,p_old_line_rec => l_line_tbl(J));
1753: l_line_tbl(J) := g_qry_out_rec;
1754: l_split_count := l_split_count + 1;
1755: g_split_line_tbl(l_split_count).split_from_line_id := l_line_tbl(J).split_from_line_id;

Line 1842: OE_SPLIT_UTIL.G_SPLIT_ACTION := TRUE;

1838: END IF;
1839: -- Call scheduling
1840: -- This call to scheduling is commented to fix splitting of reservations
1841: -- issue. The call is moved to post line loop and is in control of scheduling
1842: OE_SPLIT_UTIL.G_SPLIT_ACTION := TRUE;
1843: /* OE_ORDER_SCH_UTIL.Split_Scheduling(p_line_tbl => l_sch_tbl,
1844: x_line_tbl => l_sch_tbl,
1845: x_return_status => l_return_status);
1846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2103: OE_SPLIT_UTIL.G_SPLIT_ACTION := TRUE;

2099: l_control_rec.controlled_operation := TRUE;
2100: l_control_rec.check_security := FALSE;
2101: l_control_rec.change_attributes := TRUE;
2102: l_control_rec.default_attributes := TRUE;
2103: OE_SPLIT_UTIL.G_SPLIT_ACTION := TRUE;
2104: IF l_debug_level > 0 THEN
2105: oe_debug_pub.add('Before calling process order in splits',1) ;
2106: END IF;
2107: oe_order_pvt.Lines

Line 2149: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;

2145: , p_old_line_scredit_tbl => l_old_line_Scredit_tbl
2146: );
2147: g_non_prop_split := FALSE;
2148: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y' ;
2149: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;
2150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2153: RAISE FND_API.G_EXC_ERROR;

Line 2262: l_line_conc_rec OE_Split_Util.Split_Line_Rec_Type;

2258: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2259: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2260: l_control_rec OE_GLOBALS.Control_Rec_Type;
2261: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2262: l_line_conc_rec OE_Split_Util.Split_Line_Rec_Type;
2263: l_line_conc_tbl OE_Split_Util.Split_Line_Tbl_Type;
2264: l_rec_count number;
2265: l_return_status VARCHAR2(1);
2266: l_msg_data VARCHAR2(2000);

Line 2263: l_line_conc_tbl OE_Split_Util.Split_Line_Tbl_Type;

2259: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2260: l_control_rec OE_GLOBALS.Control_Rec_Type;
2261: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2262: l_line_conc_rec OE_Split_Util.Split_Line_Rec_Type;
2263: l_line_conc_tbl OE_Split_Util.Split_Line_Tbl_Type;
2264: l_rec_count number;
2265: l_return_status VARCHAR2(1);
2266: l_msg_data VARCHAR2(2000);
2267: l_msg_count NUMBER;

Line 2288: oe_debug_pub.add('Entering Procedure OE_Split_Util.Defer_Split', 1);

2284: FOR UPDATE NOWAIT;
2285:
2286:
2287: BEGIN
2288: oe_debug_pub.add('Entering Procedure OE_Split_Util.Defer_Split', 1);
2289: l_init_line_id :=to_number(p_line_id);
2290:
2291: select org_id
2292: into l_org_id

Line 2312: oe_debug_pub.add('record_lock exception in Oe_Split_Util.Defer_Split',1);

2308: INTO l_line_conc_tbl;
2309: CLOSE c_split_details;
2310: EXCEPTION
2311: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2312: oe_debug_pub.add('record_lock exception in Oe_Split_Util.Defer_Split',1);
2313: Retcode := 2;
2314: errbuf := sqlerrm;
2315: raise;
2316: END;

Line 2589: oe_debug_pub.add('calling process_order for service lines from oe_split_util.defer_split',5);

2585: l_x_Line_Scredit_tbl.DELETE;
2586: l_x_lot_serial_tbl.DELETE;
2587:
2588: IF l_process_add_attributes THEN
2589: oe_debug_pub.add('calling process_order for service lines from oe_split_util.defer_split',5);
2590: Oe_Order_Pvt.Process_order
2591: ( p_api_version_number => 1.0
2592: , p_init_msg_list => FND_API.G_TRUE
2593: , x_return_status => l_return_status

Line 2664: oe_debug_pub.add('Exiting Procedure OE_Split_Util.Defer_Split', 1);

2660: FND_FILE.put_line(FND_FILE.output,' << No Errors or Warnings reported >>');
2661: END IF;
2662: END IF;
2663: COMMIT;
2664: oe_debug_pub.add('Exiting Procedure OE_Split_Util.Defer_Split', 1);
2665:
2666: EXCEPTION
2667: WHEN OTHERS THEN
2668: retcode := 2;

Line 2669: oe_debug_pub.add('Inside the exception block of oe_split_util.defer_split',5);

2665:
2666: EXCEPTION
2667: WHEN OTHERS THEN
2668: retcode := 2;
2669: oe_debug_pub.add('Inside the exception block of oe_split_util.defer_split',5);
2670: IF NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'), 0) <> 0 THEN
2671: -- Called from concurrent request */
2672: IF l_msg_total > 0 THEN
2673: FOR I IN 1 .. l_msg_total LOOP

Line 2699: oe_debug_pub.add('entering oe_split_util.bulk_insert');

2695:
2696: PROCEDURE Bulk_Insert (p_line_conc_tbl IN Split_Line_Tbl_Type) is
2697:
2698: begin
2699: oe_debug_pub.add('entering oe_split_util.bulk_insert');
2700:
2701: FORALL j IN p_line_conc_tbl.FIRST .. p_line_conc_tbl.LAST
2702: INSERT INTO OE_LINE_SPLIT_DETAILS
2703: VALUES p_line_conc_tbl(j);

Line 2713: END OE_Split_Util;

2709: end Bulk_Insert;
2710:
2711: /* Defer Split ER Changes END */
2712:
2713: END OE_Split_Util;