[Home] [Help]
1162:
1163: WHILE l_loop_index IS NOT NULL LOOP
1164:
1165: -- call notification framework to get this line's index position
1166: OE_ORDER_UTIL.Update_Global_Picture
1167: (p_Upd_New_Rec_If_Exists =>FALSE
1168: , p_header_id => l_line_tbl(l_loop_index).header_id
1169: , p_line_rec => l_line_tbl(l_loop_index)
1170: , p_old_line_rec => l_old_line_tbl(l_loop_index)
1185:
1186: IF l_notify_index is not null then
1187: -- modify Global Picture
1188: -- uncommented for bug 2934535
1189: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_loop_index);
1190:
1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1188: -- uncommented for bug 2934535
1189: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_loop_index);
1190:
1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1189: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_loop_index);
1190:
1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1190:
1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1191: -- Commented for bug 2818553 hashraf
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1192: -- OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1193: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_tbl(l_loop_index).line_id;
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1194: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_tbl(l_loop_index).header_id;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1195: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := l_line_tbl(l_loop_index).last_update_date;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1196: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity:= l_line_tbl(l_loop_index).shipping_quantity;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1197: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity2:= l_line_tbl(l_loop_index).shipping_quantity2;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1198: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity:= l_line_tbl(l_loop_index).shipped_quantity;
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489
1199: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipped_quantity2:= l_line_tbl(l_loop_index).shipped_quantity2;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1200: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom:= l_line_tbl(l_loop_index).shipping_quantity_uom;
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:
1201: OE_ORDER_UTIL.g_line_tbl(l_notify_index).shipping_quantity_uom2:= l_line_tbl(l_loop_index).shipping_quantity_uom2; -- INVCONV
1202: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_shipment_date:= l_line_tbl(l_loop_index).actual_shipment_date;
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:
1209: IF l_debug_level > 0 THEN
1203: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ship_tolerance_below:= l_line_tbl(l_loop_index).ship_tolerance_below;
1204: OE_ORDER_UTIL.g_line_tbl(l_notify_index).over_ship_reason_code:= l_line_tbl(l_loop_index).over_ship_reason_code;
1205: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(l_loop_index).calculate_price_flag;
1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1206: -- bug 3272489
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1207: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_category_code := l_line_tbl(l_loop_index).line_category_code;
1208:
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1208:
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1209: IF l_debug_level > 0 THEN
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1210: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1211: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY2 , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1212: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY , 1 ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1213: oe_debug_pub.add( 'GLOBAL LINE SHIPPED_QUANTITY2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY2 , 1 ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1214: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM , 1 ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1215: oe_debug_pub.add( 'GLOBAL LINE SHIPPING_QUANTITY_UOM2: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPING_QUANTITY_UOM2 , 1 ) ; -- INVCONV
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;
1216: oe_debug_pub.add( 'GLOBAL LINE ACTUAL_SHIPMENT_DATE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .ACTUAL_SHIPMENT_DATE , 1 ) ;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;
1224: END IF;
1217: oe_debug_pub.add( 'GLOBAL LINE SHIP_TOLERANCE_BELOW: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .SHIP_TOLERANCE_BELOW , 1 ) ;
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;
1224: END IF;
1225:
1218: oe_debug_pub.add( 'GLOBAL LINE OVER_SHIP_REASON_CODE: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OVER_SHIP_REASON_CODE , 1 ) ;
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;
1224: END IF;
1225:
1226: END IF ; /* global entity index null check */
1219: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
1220: oe_debug_pub.add( 'OLD GLOBAL LINE SHIPPED QTY IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .SHIPPED_QUANTITY ) ;
1221: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1222: oe_debug_pub.add( 'OLD GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE ) ;
1223: oe_debug_pub.add( 'OLD GLOBAL LINE Category Code is ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .LINE_CATEGORY_CODE ) ;
1224: END IF;
1225:
1226: END IF ; /* global entity index null check */
1227:
5025: oe_debug_pub.add
5026: ('update GLOBAL FLOW_STATUS is: '||l_line_rec.flow_status_code,3);
5027: END IF;
5028:
5029: OE_ORDER_UTIL.Update_Global_Picture
5030: (p_Upd_New_Rec_If_Exists => False,
5031: --p_header_id => l_line_rec.header_id,
5032: p_old_line_rec => l_old_line_rec,
5033: p_line_rec => l_line_rec,
5048: END IF;
5049:
5050: IF J IS NOT NULL THEN
5051:
5052: OE_ORDER_UTIL.g_line_tbl(J)
5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5049:
5050: IF J IS NOT NULL THEN
5051:
5052: OE_ORDER_UTIL.g_line_tbl(J)
5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5051:
5052: OE_ORDER_UTIL.g_line_tbl(J)
5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5052: OE_ORDER_UTIL.g_line_tbl(J)
5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:
5053: := OE_ORDER_UTIL.g_old_line_tbl(J);
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:
5061:
5054:
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:
5061:
5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity
5055: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_rec.line_id;
5056: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_rec.header_id;
5057: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:
5061:
5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity
5063: := l_line_rec.shipping_quantity;
5058: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5059: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5060:
5061:
5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity
5063: := l_line_rec.shipping_quantity;
5064: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity2
5065: := l_line_rec.shipping_quantity2;
5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2
5060:
5061:
5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity
5063: := l_line_rec.shipping_quantity;
5064: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity2
5065: := l_line_rec.shipping_quantity2;
5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2
5067: := l_line_rec.shipped_quantity2;
5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5062: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity
5063: := l_line_rec.shipping_quantity;
5064: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity2
5065: := l_line_rec.shipping_quantity2;
5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2
5067: := l_line_rec.shipped_quantity2;
5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5069: := l_line_rec.shipped_quantity;
5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom
5064: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity2
5065: := l_line_rec.shipping_quantity2;
5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2
5067: := l_line_rec.shipped_quantity2;
5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5069: := l_line_rec.shipped_quantity;
5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom
5071: := l_line_rec.shipping_quantity_uom;
5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2
5066: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2
5067: := l_line_rec.shipped_quantity2;
5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5069: := l_line_rec.shipped_quantity;
5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom
5071: := l_line_rec.shipping_quantity_uom;
5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2
5073: := l_line_rec.shipping_quantity_uom2;
5074: OE_ORDER_UTIL.g_line_tbl(J).actual_shipment_date
5068: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5069: := l_line_rec.shipped_quantity;
5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom
5071: := l_line_rec.shipping_quantity_uom;
5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2
5073: := l_line_rec.shipping_quantity_uom2;
5074: OE_ORDER_UTIL.g_line_tbl(J).actual_shipment_date
5075: := l_line_rec.actual_shipment_date;
5076: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5070: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom
5071: := l_line_rec.shipping_quantity_uom;
5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2
5073: := l_line_rec.shipping_quantity_uom2;
5074: OE_ORDER_UTIL.g_line_tbl(J).actual_shipment_date
5075: := l_line_rec.actual_shipment_date;
5076: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5077: := l_line_rec.flow_status_code;
5078:
5072: OE_ORDER_UTIL.g_line_tbl(J).shipping_quantity_uom2
5073: := l_line_rec.shipping_quantity_uom2;
5074: OE_ORDER_UTIL.g_line_tbl(J).actual_shipment_date
5075: := l_line_rec.actual_shipment_date;
5076: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5077: := l_line_rec.flow_status_code;
5078:
5079: IF l_debug_level > 0 THEN
5080: oe_debug_pub.add
5078:
5079: IF l_debug_level > 0 THEN
5080: oe_debug_pub.add
5081: ('AFTER UPDATE GLOBAL FLOW_STATUS_CODE IS: '
5082: || OE_ORDER_UTIL.G_LINE_TBL( J ).FLOW_STATUS_CODE ,1);
5083: END IF;
5084:
5085: END IF; -- if index is not null
5086: