APPS.POS_ASN_CREATE_PVT dependencies on WMS_LPN_INTERFACE

Line 480: l_parent_lpn wms_lpn_interface.parent_license_plate_number%type;

476: l_api_name varchar2(50) := 'insert_wlpni';
477: l_progress varchar2(20) := '000';
478: l_org_id number;
479: l_exist number;
480: l_parent_lpn wms_lpn_interface.parent_license_plate_number%type;
481:
482: cursor l_lpn_exist_csr(p_lpn varchar2, p_grp_id number)
483: is
484: select 1, parent_license_plate_number

Line 485: from wms_lpn_interface

481:
482: cursor l_lpn_exist_csr(p_lpn varchar2, p_grp_id number)
483: is
484: select 1, parent_license_plate_number
485: from wms_lpn_interface
486: where license_plate_number = p_lpn
487: and source_group_id = p_grp_id;
488:
489: BEGIN

Line 542: update wms_lpn_interface

538: x_return_status := 'E';
539: x_msg_data := 'This LPN Child Parent relationship error should have been caught in the UI. A-->X, A-->Y exist';
540: else
541: --Existing LPN has NO Parent LPN
542: update wms_lpn_interface
543: set parent_license_plate_number = p_parent_license_plate_number
544: where source_group_id = p_lpn_group_id
545: and license_plate_number = p_license_plate_number;
546: end if;