APPS.WMS_WIP_INTEGRATION dependencies on WMS_WIP_INTEGRATION

Line 1: PACKAGE BODY WMS_WIP_Integration AS

1: PACKAGE BODY WMS_WIP_Integration AS
2: /* $Header: WMSWIPIB.pls 120.3.12010000.4 2008/10/10 18:12:38 bvanjaku ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_WIP_Integration';

2: /* $Header: WMSWIPIB.pls 120.3.12010000.4 2008/10/10 18:12:38 bvanjaku ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_WIP_Integration';
7:
8:
9: PROCEDURE Update_MO_Line
10: (p_lpn_id IN NUMBER,

Line 421: wms_wip_integration.update_serial

417: mydebug('Backflush: serial item');
418: mydebug('Backflush: ' || l_temp_header_id || ' ' || l_fm_serial_number);
419: END IF;
420:
421: wms_wip_integration.update_serial
422: (p_header_id => l_temp_header_id,
423: p_serial_number => l_fm_serial_number,
424: x_return_status => l_return_status,
425: x_msg_count => x_msg_count,

Line 612: wms_wip_integration.insert_lot for each lot in wip_lpn_completions_lots table,

608: mydebug('Backflush: Loop thru wip_lpn_comp_lots_rec ');
609: END IF;
610:
611: /* Bug: 2976160 : replaced Select INTO with cursor loop to call
612: wms_wip_integration.insert_lot for each lot in wip_lpn_completions_lots table,
613: for the given header_id. there can be more than one lot . */
614: FOR wip_lpn_comp_lots_rec in wip_lpn_comp_lots_csr
615: LOOP
616: IF (l_debug = 1) THEN

Line 617: mydebug('Backflush: Loop wip_lpn_comp_lots_rec : call wms_wip_integration.insert_lot');

613: for the given header_id. there can be more than one lot . */
614: FOR wip_lpn_comp_lots_rec in wip_lpn_comp_lots_csr
615: LOOP
616: IF (l_debug = 1) THEN
617: mydebug('Backflush: Loop wip_lpn_comp_lots_rec : call wms_wip_integration.insert_lot');
618: END IF;
619: wms_wip_integration.insert_lot
620: (p_header_id => l_temp_header_id,
621: p_lot_number => wip_lpn_comp_lots_rec.lot_number,

Line 619: wms_wip_integration.insert_lot

615: LOOP
616: IF (l_debug = 1) THEN
617: mydebug('Backflush: Loop wip_lpn_comp_lots_rec : call wms_wip_integration.insert_lot');
618: END IF;
619: wms_wip_integration.insert_lot
620: (p_header_id => l_temp_header_id,
621: p_lot_number => wip_lpn_comp_lots_rec.lot_number,
622: x_return_status => l_return_status,
623: x_msg_count => x_msg_count,

Line 647: wms_wip_integration.update_serial

643: mydebug('Backflush: lot and serial item');
644: mydebug('Backflush: ' || l_temp2_header_id || ' ' || l_lot_number || ' ' || l_fm_serial_number);
645: END IF;
646:
647: wms_wip_integration.update_serial
648: (p_header_id => l_temp2_header_id,
649: p_serial_number => l_fm_serial_number,
650: x_return_status => l_return_status,
651: x_msg_count => x_msg_count,

Line 1616: WMS_WIP_Integration.perform_lot_validations

1612: INTO l_item_id,l_org_id
1613: FROM wip_lpn_completions
1614: WHERE header_id = p_header_id;
1615:
1616: WMS_WIP_Integration.perform_lot_validations
1617: (p_item_id => l_item_id,
1618: p_org_id => l_org_id,
1619: p_lot_number => l_lot_number,
1620: x_return_status => l_return_status,

Line 2712: --dbms_output.put_line('WMS_WIP_Integration' || l_msg);

2708: inv_mobile_helper_functions.tracelog
2709: (p_err_msg => l_msg,
2710: p_module => 'WMSWIPIB',
2711: p_level => 4);
2712: --dbms_output.put_line('WMS_WIP_Integration' || l_msg);
2713:
2714: null;
2715: END;
2716:

Line 2994: END WMS_WIP_Integration ;

2990:
2991: END wip_processor;
2992:
2993:
2994: END WMS_WIP_Integration ;