APPS.POS_ASN_CREATE_PVT dependencies on WMS_LPN_INTERFACE

Line 479: l_parent_lpn wms_lpn_interface.parent_license_plate_number%type;

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

Line 484: from wms_lpn_interface

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

Line 541: update wms_lpn_interface

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