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_GLOBALS

Line 20: p_x_line_tbl(I).operation = oe_globals.g_opr_update THEN

16: oe_debug_pub.add( 'ENTER CREATE LINE SET FOR OPTIONS:' ) ;
17: END IF;
18: FOR I in 1..p_x_line_tbl.count LOOP
19: IF p_x_line_tbl(I).line_set_id is null AND
20: p_x_line_tbl(I).operation = oe_globals.g_opr_update THEN
21: IF l_debug_level > 0 THEN
22: oe_debug_pub.add( 'BEFORE CREATING SET : ' ||P_X_LINE_TBL ( I ) .LINE_ID ) ;
23: END IF;
24: IF l_debug_level > 0 THEN

Line 31: p_x_line_tbl(J).operation = oe_globals.g_opr_create THEN

27: Oe_Set_Util.Create_Line_Set(p_x_line_rec => p_x_line_tbl(I));
28: END IF;
29: FOR J in 1..p_x_line_tbl.count LOOP
30: IF p_x_line_tbl(J).split_from_line_id = p_x_line_tbl(I).line_id AND
31: p_x_line_tbl(J).operation = oe_globals.g_opr_create THEN
32: IF l_debug_level > 0 THEN
33: oe_debug_pub.add( 'ADDING INTO SET:' ) ;
34: END IF;
35: p_x_line_tbl(J).line_Set_id := p_x_line_tbl(I).line_set_id;

Line 56: IF (p_line_tbl(I).operation = oe_globals.g_opr_create AND

52: BEGIN
53:
54: FOR I in 1..p_line_tbl.count LOOP
55: BEGIN
56: IF (p_line_tbl(I).operation = oe_globals.g_opr_create AND
57: p_line_tbl(I).split_from_line_id IS NOT NULL AND
58: p_line_tbl(I).source_type_code = 'EXTERNAL' ) THEN
59: UPDATE oe_drop_ship_sources
60: SET line_id = p_line_tbl(I).line_id

Line 98: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE THEN

94: OE_DEBUG_PUB.add('#5112495, select service reference type code ORDER only',1);
95: END IF;
96: x_line_tbl := p_line_tbl;
97: FOR I in 1 .. p_line_tbl.count LOOP
98: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE THEN
99: l_line_id := p_line_tbl(I).line_id;
100: ELSE
101: l_line_id := p_line_tbl(I).split_from_line_id;
102: END IF;

Line 108: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN

104: l_service_count := l_service_count + 1;
105: l_ser_line_tbl(l_service_count).line_id := ser_rec.line_id;
106: oe_line_util.query_row(ser_rec.line_id,x_line_rec => l_ser_line_rec);
107: l_ser_line_tbl(l_service_count) := l_ser_line_rec;
108: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN
109: l_ser_line_tbl(l_service_count).line_id := fnd_api.g_miss_num;
110: l_ser_line_tbl(l_service_count).split_from_line_id := l_ser_line_rec.split_from_line_id;
111: END IF;
112: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 112: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE THEN

108: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN
109: l_ser_line_tbl(l_service_count).line_id := fnd_api.g_miss_num;
110: l_ser_line_tbl(l_service_count).split_from_line_id := l_ser_line_rec.split_from_line_id;
111: END IF;
112: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE THEN
113: l_ser_line_tbl(l_service_count).split_action_code := 'SPLIT';
114: /* Start Audit Trail */
115: l_ser_line_tbl(l_service_count).change_reason := 'SYSTEM';
116: /* End Audit Trail */

Line 289: l_ser_line_tbl(l_service_count).operation := oe_globals.g_opr_update;

285: /* End Audit Trail */
286: l_ser_line_tbl(l_service_count).line_id := ser_rec.line_id;
287: l_ser_line_tbl(l_service_count).header_id := ser_rec.header_id;
288: l_ser_line_tbl(l_service_count).ordered_quantity := g_split_line_tbl(1).quantity;
289: l_ser_line_tbl(l_service_count).operation := oe_globals.g_opr_update;
290: l_ser_line_tbl(l_service_count).split_action_code := 'SPLIT';
291: l_service_count := l_service_count + 1;
292: FOR I in 2..g_split_line_tbl.count LOOP
293: l_ser_line_tbl(l_service_count) := l_ser_rec;

Line 296: l_ser_line_tbl(l_service_count).operation := oe_globals.g_opr_create;

292: FOR I in 2..g_split_line_tbl.count LOOP
293: l_ser_line_tbl(l_service_count) := l_ser_rec;
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)

Line 306: l_ser_line_tbl(l_service_count).operation := oe_globals.g_opr_create;

302: l_ser_line_tbl(l_service_count) := g_qry_out_rec;
303: l_ser_line_tbl(l_service_count).header_id := ser_rec.header_id;
304: l_ser_line_tbl(l_service_count).service_reference_line_id := g_split_line_tbl(I).line_id;
305: l_ser_line_tbl(l_service_count).ordered_quantity := g_split_line_tbl(I).quantity;
306: l_ser_line_tbl(l_service_count).operation := oe_globals.g_opr_create;
307: l_ser_line_tbl(l_service_count).item_type_code:='SERVICE';
308: l_service_count := l_service_count + 1;
309: END LOOP;
310: END LOOP;

Line 415: l_parent_line.operation := oe_globals.g_opr_update;

411: IF g_max_model > 0 THEN
412: l_parent_line := l_line_rec;
413: l_parent_line.ordered_quantity := g_max_model;
414: l_parent_line.shipped_quantity := g_max_model;
415: l_parent_line.operation := oe_globals.g_opr_update;
416: l_parent_line.split_action_code := 'SPLIT';
417: l_parent_line.split_by := 'SYSTEM';
418: --l_option_count := l_option_count + 1;
419: IF l_parent_line.line_set_id IS NULL THEN

Line 435: x_line_tbl(I).operation := oe_globals.g_opr_update;

431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( X_LINE_TBL ( I ) .ORDERED_QUANTITY ) ;
433: END IF;
434: x_line_tbl(I).ordered_quantity := g_max_model * l_model_ratio;
435: x_line_tbl(I).operation := oe_globals.g_opr_update;
436: x_line_tbl(I).shipped_quantity := x_line_tbl(I).ordered_quantity;
437: option_updated := TRUE;
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add( 'ORD QTY' ||X_LINE_TBL ( I ) .ORDERED_QUANTITY ) ;

Line 451: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;

447: l_option_line_tbl(l_option_count).ordered_quantity := g_max_model * l_model_ratio;
448: /* Start Audit Trail */
449: l_option_line_tbl(l_option_count).change_reason := 'SYSTEM';
450: /* End Audit Trail */
451: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;
452: l_option_line_tbl(l_option_count).split_action_code := 'SPLIT';
453: l_option_line_tbl(l_option_count).split_by := 'SYSTEM' ;
454: l_option_line_tbl(l_option_count).shipped_quantity := l_option_line_tbl(l_option_count).ordered_quantity;
455: END IF; -- Option not updated

Line 477: l_parent_line.operation := oe_globals.g_opr_create;

473: END IF;
474: IF g_min_Model > 0 THEN
475: l_parent_line := l_line_rec;
476: l_parent_line.ordered_quantity := g_min_model;
477: l_parent_line.operation := oe_globals.g_opr_create;
478: l_parent_line.split_by := 'SYSTEM';
479: l_parent_line.split_from_line_id := l_parent_line.line_id;
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add('Line set id is : '||l_set_id,5) ;

Line 504: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;

500: l_option_line_tbl(l_option_count) := l_option_line;
501: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
502: l_option_line_tbl(l_option_count).split_by:='SYSTEM';
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

Line 550: l_parent_line.operation := oe_globals.g_opr_update;

546: ELSIF l_set_id is not null then
547: l_parent_line.line_set_id := l_set_id;
548: END IF;
549: l_rem_top_model_line_id := l_parent_line.line_id;
550: l_parent_line.operation := oe_globals.g_opr_update;
551: l_parent_line.split_action_code := 'SPLIT';
552: l_parent_line.split_by := 'SYSTEM';
553: ELSE -- g_max_model
554: l_parent_line.operation := oe_globals.g_opr_create;

Line 554: l_parent_line.operation := oe_globals.g_opr_create;

550: l_parent_line.operation := oe_globals.g_opr_update;
551: l_parent_line.split_action_code := 'SPLIT';
552: l_parent_line.split_by := 'SYSTEM';
553: ELSE -- g_max_model
554: l_parent_line.operation := oe_globals.g_opr_create;
555: l_parent_line.split_by := 'SYSTEM';
556: l_parent_line.split_from_line_id := l_parent_line.line_id;
557: l_parent_line.line_id := fnd_api.g_miss_num;
558: l_parent_line.config_header_id := NULL;

Line 602: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;

598: l_option_count := l_option_count + 1;
599: l_option_line_tbl(l_option_count) := l_option_line;
600: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
601: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
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

Line 648: l_parent_line.operation := oe_globals.g_opr_create;

644: oe_debug_pub.add('This line ordered quantity ' || l_line_rec.ordered_quantity);
645: oe_debug_pub.add('Ordered quantity on the table ' || x_line_tbl(1).ordered_quantity);
646: END IF;
647: IF l_parent_line.ordered_quantity <> 0 THEN
648: l_parent_line.operation := oe_globals.g_opr_create;
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

Line 689: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;

685: IF l_update_quantity > 0 THEN
686: l_option_count := l_option_count + 1;
687: IF NOT option_updated AND g_max_model = 0 THEN
688: l_option_line_tbl(l_option_count) := l_option_line;
689: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;
690: l_option_line_tbl(l_option_count).split_action_code := 'SPLIT';
691: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
692: l_option_line_tbl(l_option_count).ship_set_id := null;
693: l_option_line_tbl(l_option_count).arrival_Set_id := null;

Line 699: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;

695: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
696: l_option_line_tbl(l_option_count) := l_option_line;
697: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
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

Line 822: l_parent_line.operation := oe_globals.g_opr_update;

818: IF g_max_model > 0 THEN
819: l_parent_line := l_line_rec;
820: l_parent_line.ordered_quantity := g_max_model;
821: l_parent_line.shipped_quantity := g_max_model;
822: l_parent_line.operation := oe_globals.g_opr_update;
823: l_parent_line.split_action_code := 'SPLIT';
824: l_parent_line.split_by := 'SYSTEM';
825: --l_option_count := l_option_count + 1;
826: IF l_parent_line.line_set_id IS NULL THEN

Line 840: x_line_tbl(I).operation := OE_GLOBALS.g_opr_update;

836: option_updated := FALSE;
837: FOR I in 1..P_line_tbl.count LOOP
838: IF p_line_tbl(I).line_id = optionrec.line_id THEN
839: x_line_tbl(I).ordered_quantity := g_max_model * l_model_ratio;
840: x_line_tbl(I).operation := OE_GLOBALS.g_opr_update;
841: x_line_tbl(I).shipped_quantity := x_line_tbl(I).ordered_quantity;
842: option_updated := TRUE;
843: EXIT;
844: END IF;

Line 853: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;

849: l_option_line_tbl(l_option_count).ordered_quantity := g_max_model * l_model_ratio;
850: /* Start Audit Trail */
851: l_option_line_tbl(l_option_count).change_reason := 'SYSTEM';
852: /* End Audit Trail */
853: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;
854: l_option_line_tbl(l_option_count).split_action_code := 'SPLIT';
855: l_option_line_tbl(l_option_count).split_by := 'SYSTEM' ;
856: l_option_line_tbl(l_option_count).shipped_quantity :=l_option_line_tbl(l_option_count).ordered_quantity;
857: END IF; -- Option not updated

Line 876: l_parent_line.operation := oe_globals.g_opr_create;

872: -- Get Complete shippable Model if any
873: IF g_min_Model > 0 THEN
874: l_parent_line := l_line_rec;
875: l_parent_line.ordered_quantity := g_min_model;
876: l_parent_line.operation := oe_globals.g_opr_create;
877: l_parent_line.split_by := 'SYSTEM';
878: l_parent_line.split_from_line_id := l_parent_line.line_id;
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( 'LINE SET IS-'||L_SET_ID ) ;

Line 903: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;

899: l_option_count := l_option_count + 1;
900: l_option_line_tbl(l_option_count) := l_option_line;
901: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
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

Line 955: l_parent_line.operation := oe_globals.g_opr_create;

951: IF l_debug_level > 0 THEN
952: oe_debug_pub.add( 'PARENT ORDERED QUANTITY : ' || L_PARENT_LINE.ORDERED_QUANTITY ) ;
953: END IF;
954: IF l_parent_line.ordered_quantity > 0 THEN
955: l_parent_line.operation := oe_globals.g_opr_create;
956: l_parent_line.split_by := 'SYSTEM';
957: l_parent_line.split_from_line_id := l_parent_line.line_id;
958: l_parent_line.line_id := fnd_api.g_miss_num;
959: l_parent_line.config_header_id := NULL;

Line 989: l_parent_line.operation := oe_globals.g_opr_create;

985: oe_debug_pub.add('This line unshipped qty 2 : ' || L_LINE_REC.ORDERED_QUANTITY ) ;
986: oe_debug_pub.add('unshipped qty 3 : ' || X_LINE_TBL ( 1 ) .ORDERED_QUANTITY ) ;
987: END IF;
988: IF l_parent_line.ordered_quantity > 0 THEN
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

Line 1035: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;

1031: l_option_count := l_option_count + 1;
1032: l_option_line_tbl(l_option_count) := l_option_line;
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));

Line 1096: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;

1092: IF l_update_quantity > 0 THEN
1093: l_option_count := l_option_count + 1;
1094: IF NOT option_updated AND g_max_model = 0 THEN
1095: l_option_line_tbl(l_option_count) := l_option_line;
1096: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;
1097: l_option_line_tbl(l_option_count).split_action_code := 'SPLIT';
1098: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
1099: l_option_line_tbl(l_option_count).ship_set_id := null;
1100: l_option_line_tbl(l_option_count).arrival_Set_id := null;

Line 1106: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;

1102: ELSE
1103: l_option_line_tbl(l_option_count) := l_option_line;
1104: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
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

Line 1245: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;

1241: l_option_line_tbl(l_option_count).ordered_quantity := p_line_tbl(p_index).ordered_quantity * l_model_ratio;
1242: IF l_debug_level > 0 THEN
1243: oe_debug_pub.add( 'RATIO : ' || P_LINE_TBL ( P_INDEX ) .ORDERED_QUANTITY ) ;
1244: END IF;
1245: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_update;
1246: l_option_line_tbl(l_option_count).split_action_code := 'SPLIT';
1247: l_option_line_tbl(l_option_count).split_by := p_line_tbl(p_index).split_by;
1248:
1249: /* Populate Line set id if set id is not already populated bug - 2103004 */

Line 1269: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;

1265: l_option_line_tbl(l_option_count).ordered_quantity := g_split_line_tbl(I).quantity * l_model_ratio;
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'RATIO 3 : ' || G_SPLIT_LINE_TBL ( I ) .QUANTITY , 1 ) ;
1268: END IF;
1269: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
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

Line 1301: l_line_scredit_temp_tbl(l_scredit_count).Operation := OE_GLOBALS.G_OPR_CREATE;

1297: FOR SCRD_REC IN 1..l_line_Scredit_tbl.count LOOP
1298: l_scredit_count := l_scredit_count + 1;
1299: l_line_scredit_temp_tbl(l_scredit_count) := l_line_scredit_tbl(SCRD_REC);
1300: l_line_scredit_temp_tbl(l_scredit_count).sales_credit_id := FND_API.G_MISS_NUM;
1301: l_line_scredit_temp_tbl(l_scredit_count).Operation := OE_GLOBALS.G_OPR_CREATE;
1302: l_line_scredit_temp_tbl(l_scredit_count).line_id := l_option_line_tbl(l_option_count).line_id;
1303: END LOOP;
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add( 'DONE COPYING SALES CREDITS TO NEW OPTION ' , 1 ) ;

Line 1407: IF (p_x_line_rec.operation = oe_globals.g_opr_create and

1403: END IF;
1404: IF l_debug_level > 0 THEN
1405: oe_debug_pub.add( 'SPLITLINEID:'||P_X_LINE_REC.SPLIT_FROM_LINE_ID ) ;
1406: END IF;
1407: IF (p_x_line_rec.operation = oe_globals.g_opr_create and
1408: (p_x_line_rec.split_from_line_id IS NOT NULL AND
1409: p_x_line_rec.split_from_line_id <> FND_API.G_MISS_NUM) AND
1410: (p_x_line_rec.line_id IS NULL OR
1411: p_x_line_rec.line_id = FND_API.G_MISS_NUM)) THEN

Line 1513: l_line_rec.operation := oe_globals.g_opr_create;

1509: l_line_rec.schedule_action_code := OE_ORDER_SCH_UTIL.OESCH_ACT_DEMAND;
1510: l_line_rec.schedule_status_code := NULL;
1511: END IF;*/
1512: oe_line_util.convert_miss_to_null(p_x_line_rec => l_line_rec);
1513: l_line_rec.operation := oe_globals.g_opr_create;
1514: p_x_line_rec := l_line_rec;
1515: ELSIF (l_line_rec.line_id IS NOT NULL AND
1516: l_line_rec.line_id <> FND_API.G_MISS_NUM AND
1517: l_line_rec.operation = oe_globals.g_opr_create) THEN

Line 1517: l_line_rec.operation = oe_globals.g_opr_create) THEN

1513: l_line_rec.operation := oe_globals.g_opr_create;
1514: p_x_line_rec := l_line_rec;
1515: ELSIF (l_line_rec.line_id IS NOT NULL AND
1516: l_line_rec.line_id <> FND_API.G_MISS_NUM AND
1517: l_line_rec.operation = oe_globals.g_opr_create) THEN
1518: IF l_debug_level > 0 THEN
1519: oe_debug_pub.add( 'LINE ID :'||P_X_LINE_REC.LINE_ID ) ;
1520: END IF;
1521: IF l_debug_level > 0 THEN

Line 1648: l_line_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE

1644: oe_debug_pub.add('OUT side the LOOP ORD QTY IS :'|| l_line_tbl(I).ordered_quantity || ' Count : '
1645: ||I ||' Operation : '||l_line_tbl(I).operation);
1646: end if;
1647: IF l_line_tbl(I).split_action_code = 'SPLIT' AND
1648: l_line_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE
1649: THEN
1650: /* Added this condition to spuress the spliting of the line with zero quantiy.
1651: Bug: 3318920
1652: By: Srini

Line 1730: l_line_tbl(J).operation = OE_GLOBALS.G_OPR_CREATE )

1726: oe_debug_pub.add('OUT side the LOOP ORD QTY IS :'|| l_line_tbl(J).ordered_quantity || ' Count : '
1727: ||J ||' Operation : '||l_line_tbl(J).operation);
1728: END if;
1729: IF (l_Line_Tbl(J).split_from_line_id = l_line_tbl(I).Line_Id AND
1730: l_line_tbl(J).operation = OE_GLOBALS.G_OPR_CREATE )
1731: THEN
1732: /* Added this condition to spuress the spliting of the line with zero quantiy.
1733: Bug: 3318920
1734: By: Srini

Line 1770: l_line_scredit_temp_tbl(l_scredit_count).Operation := OE_GLOBALS.G_OPR_CREATE;

1766: FOR SCRD_REC IN 1..L_line_Scredit_tbl.count LOOP
1767: l_scredit_count := l_scredit_count + 1;
1768: l_line_scredit_temp_tbl(l_scredit_count):= L_line_scredit_tbl(SCRD_REC);
1769: l_line_scredit_temp_tbl(l_scredit_count).sales_credit_id:= FND_API.G_MISS_NUM;
1770: l_line_scredit_temp_tbl(l_scredit_count).Operation := OE_GLOBALS.G_OPR_CREATE;
1771: l_line_scredit_temp_tbl(l_scredit_count).line_id := l_line_tbl(J).line_id;
1772: END LOOP;
1773: END IF; -- IF split from line id and operation create
1774: --j:= l_line_tbl.next(j);

Line 1917: l_control_rec OE_GLOBALS.Control_Rec_Type;

1913:
1914: Procedure Cascade_non_proportional_Split(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
1915: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
1916: l_line_id NUMBER;
1917: l_control_rec OE_GLOBALS.Control_Rec_Type;
1918: l_api_name CONSTANT VARCHAR2(30) := 'Cascade Non Proportonal splits';
1919: l_return_status VARCHAR2(30);
1920: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1921: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2076: IF l_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN

2072: END IF;
2073: END LOOP;
2074: -- Get Sales Credits
2075: FOR I in 1 .. l_line_tbl.count LOOP
2076: IF l_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN
2077: oe_line_scredit_util.query_rows( p_line_id => l_line_tbl(I).split_from_line_id,
2078: x_line_scredit_tbl => l_line_scredit_temp_tbl);
2079: l_scredit_count := l_line_scredit_tbl.count + 1;
2080: FOR Scr IN 1 .. l_line_scredit_temp_tbl.count LOOP

Line 2082: l_line_scredit_tbl(l_scredit_count).operation := OE_GLOBALS.G_OPR_CREATE;

2078: x_line_scredit_tbl => l_line_scredit_temp_tbl);
2079: l_scredit_count := l_line_scredit_tbl.count + 1;
2080: FOR Scr IN 1 .. l_line_scredit_temp_tbl.count LOOP
2081: l_line_scredit_tbl(l_scredit_count) := l_line_scredit_temp_tbl(Scr);
2082: l_line_scredit_tbl(l_scredit_count).operation := OE_GLOBALS.G_OPR_CREATE;
2083: l_line_scredit_tbl(l_scredit_count).line_id := l_line_tbl(I).line_id;
2084: l_line_scredit_tbl(l_scredit_count).sales_credit_id := fnd_api.g_miss_num;
2085: END LOOP;
2086: END IF;

Line 2260: l_control_rec OE_GLOBALS.Control_Rec_Type;

2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2257: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_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;

Line 2297: OE_GLOBALS.Set_Context();

2293: from oe_order_lines_all
2294: where line_id=l_init_line_id;
2295:
2296: MO_GLOBAL.set_policy_context('S',l_org_id);
2297: OE_GLOBALS.Set_Context();
2298:
2299:
2300: Retcode := 0;
2301: Errbuf := NULL;

Line 2392: l_x_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;

2388: ELSE
2389: l_x_line_tbl(i).split_by := 'USER';
2390: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2391: END IF;
2392: l_x_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
2393: IF l_debug_level > 0 THEN
2394: OE_DEBUG_PUB.add('Audit Trail Reason Code being passed as '||
2395: l_line_conc_tbl(i).change_reason_code,1);
2396: END IF;

Line 2403: l_x_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;

2399: ELSE
2400: IF l_line_id is not null then
2401: l_x_line_tbl(i).split_from_line_id := l_line_id;
2402: END IF;
2403: l_x_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
2404: IF l_line_conc_tbl(i).split_by = 'SCHEDULER' THEN
2405: l_x_line_tbl(i).split_by := 'SYSTEM';
2406: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2407: ELSE

Line 2474: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;

2470: l_process_add_attributes := TRUE;
2471: END IF;
2472: END IF;
2473:
2474: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
2475: oe_debug_pub.add('Reason code being passed : '||l_line_tbl(i).change_reason,1);
2476:
2477: l_line_tbl(i).change_reason := l_line_conc_tbl(i).change_reason_code;
2478: l_line_tbl(i).change_comments := l_line_conc_tbl(i).change_reason_comment;

Line 2556: l_line_tbl(l_rec_count).operation := OE_GLOBALS.G_OPR_UPDATE;

2552: l_process_add_attributes := TRUE;
2553: END IF;
2554: END IF;
2555:
2556: l_line_tbl(l_rec_count).operation := OE_GLOBALS.G_OPR_UPDATE;
2557: oe_debug_pub.add('Reason code being passed : '||
2558: l_line_tbl(l_rec_count).change_reason,1);
2559: l_line_tbl(l_rec_count).change_reason :=
2560: l_line_conc_tbl(k).change_reason_code;