APPS.WMS_XDOCK_SRC_ASSIGN_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

procedure INSERT_ROW (
  X_CRITERION_ID in NUMBER,
  X_SOURCE_TYPE in NUMBER,
  X_SOURCE_CODE in NUMBER,
  X_PRIORITY in NUMBER,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  insert into WMS_XDOCK_SOURCE_ASSIGNMENTS (
    CRITERION_ID,
    SOURCE_TYPE,
    SOURCE_CODE,
    PRIORITY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_CRITERION_ID,
    X_SOURCE_TYPE,
    X_SOURCE_CODE,
    X_PRIORITY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 37

end INSERT_ROW;

Line: 45

  cursor c is select
      PRIORITY
    from WMS_XDOCK_SOURCE_ASSIGNMENTS
    where CRITERION_ID = X_CRITERION_ID
    and SOURCE_TYPE = X_SOURCE_TYPE
    and SOURCE_CODE = X_SOURCE_CODE
    for update nowait;

Line: 59

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 73

procedure UPDATE_ROW (
  X_CRITERION_ID in NUMBER,
  X_SOURCE_TYPE in NUMBER,
  X_SOURCE_CODE in NUMBER,
  X_PRIORITY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update WMS_XDOCK_SOURCE_ASSIGNMENTS set
    PRIORITY = X_PRIORITY,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where CRITERION_ID = X_CRITERION_ID
  and SOURCE_TYPE = X_SOURCE_TYPE
  and SOURCE_CODE = X_SOURCE_CODE;

Line: 96

end UPDATE_ROW;

Line: 98

procedure DELETE_ROW (
  X_CRITERION_ID in NUMBER,
  X_SOURCE_TYPE in NUMBER,
  X_SOURCE_CODE in NUMBER
) is
begin
  delete from WMS_XDOCK_SOURCE_ASSIGNMENTS
  where CRITERION_ID = X_CRITERION_ID
  and SOURCE_TYPE = X_SOURCE_TYPE
  and SOURCE_CODE = X_SOURCE_CODE;

Line: 113

end DELETE_ROW;