APPS.AMW_OBJECT_RULES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_OBJECT_RULE_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_SECURITY_GROUP_ID in NUMBER,
  X_APPROVAL_TYPE in VARCHAR2,
  X_RULE_USED_BY in VARCHAR2,
  X_OBJECT_TYPE in VARCHAR2,
  X_RULE_TYPE in VARCHAR2,
  X_API_TYPE in VARCHAR2,
  X_PACKAGE_NAME in VARCHAR2,
  X_PROCEDURE_NAME in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_APPLICATION_ID 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

  cursor C is select ROWID from AMW_OBJECT_RULES
    where OBJECT_RULE_ID = X_OBJECT_RULE_ID
    ;

Line: 28

  insert into AMW_OBJECT_RULES (
      OBJECT_RULE_ID,
    OBJECT_VERSION_NUMBER,
    APPROVAL_TYPE,
    RULE_USED_BY,
    OBJECT_TYPE,
    RULE_TYPE,
    API_TYPE,
    PACKAGE_NAME,
    PROCEDURE_NAME,
    SEEDED_FLAG,
    APPLICATION_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_OBJECT_RULE_ID,
    X_OBJECT_VERSION_NUMBER,
    X_APPROVAL_TYPE,
    X_RULE_USED_BY,
    X_OBJECT_TYPE,
    X_RULE_TYPE,
    X_API_TYPE,
    X_PACKAGE_NAME,
    X_PROCEDURE_NAME,
    X_SEEDED_FLAG,
    X_APPLICATION_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 72

end INSERT_ROW;

Line: 88

  cursor c is select
      OBJECT_VERSION_NUMBER,
      SECURITY_GROUP_ID,
      APPROVAL_TYPE,
      RULE_USED_BY,
      OBJECT_TYPE,
      RULE_TYPE,
      API_TYPE,
      PACKAGE_NAME,
      PROCEDURE_NAME,
      SEEDED_FLAG,
      APPLICATION_ID
    from AMW_OBJECT_RULES
    where OBJECT_RULE_ID = X_OBJECT_RULE_ID
    for update of OBJECT_RULE_ID nowait;

Line: 110

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

Line: 144

procedure UPDATE_ROW (
  X_OBJECT_RULE_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_SECURITY_GROUP_ID in NUMBER,
  X_APPROVAL_TYPE in VARCHAR2,
  X_RULE_USED_BY in VARCHAR2,
  X_OBJECT_TYPE in VARCHAR2,
  X_RULE_TYPE in VARCHAR2,
  X_API_TYPE in VARCHAR2,
  X_PACKAGE_NAME in VARCHAR2,
  X_PROCEDURE_NAME in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMW_OBJECT_RULES set
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    APPROVAL_TYPE = X_APPROVAL_TYPE,
    RULE_USED_BY = X_RULE_USED_BY,
    OBJECT_TYPE = X_OBJECT_TYPE,
    RULE_TYPE = X_RULE_TYPE,
    API_TYPE = X_API_TYPE,
    PACKAGE_NAME = X_PACKAGE_NAME,
    PROCEDURE_NAME = X_PROCEDURE_NAME,
    SEEDED_FLAG = X_SEEDED_FLAG,
    APPLICATION_ID = X_APPLICATION_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where OBJECT_RULE_ID = X_OBJECT_RULE_ID;

Line: 186

end UPDATE_ROW;

Line: 188

procedure DELETE_ROW (
  X_OBJECT_RULE_ID in NUMBER
) is
begin

  if (sql%notfound) then
    raise no_data_found;

Line: 197

  delete from AMW_OBJECT_RULES
  where OBJECT_RULE_ID = X_OBJECT_RULE_ID;

Line: 203

end DELETE_ROW;

Line: 228

 select object_version_number
from    AMW_OBJECT_RULES
  where  OBJECT_RULE_ID =  X_OBJECT_RULE_ID;

Line: 233

  select 'x'
  from    AMW_OBJECT_RULES
  where  OBJECT_RULE_ID =  X_OBJECT_RULE_ID;

Line: 238

  select AMW_OBJECT_RULES_S.nextval
  from dual;

Line: 260

      AMW_OBJECT_RULES_PKG.INSERT_ROW (
         X_ROWID => l_row_id,
         X_OBJECT_RULE_ID => l_objrule_id,
         X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
         X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID,
         X_APPROVAL_TYPE => X_APPROVAL_TYPE,
         X_RULE_USED_BY => X_RULE_USED_BY,
         X_OBJECT_TYPE => X_OBJECT_TYPE,
         X_RULE_TYPE => X_RULE_TYPE,
         X_API_TYPE => X_API_TYPE,
         X_PACKAGE_NAME => X_PACKAGE_NAME,
         X_PROCEDURE_NAME => X_PROCEDURE_NAME,
         X_SEEDED_FLAG => X_SEEDED_FLAG,
         X_APPLICATION_ID => X_APPLICATION_ID ,
         X_CREATION_DATE => sysdate,
         X_CREATED_BY => l_user_id,
         X_LAST_UPDATE_DATE => sysdate,
         X_LAST_UPDATED_BY => l_user_id,
         X_LAST_UPDATE_LOGIN => 0
         );

Line: 288

      AMW_OBJECT_RULES_PKG.UPDATE_ROW(
         X_OBJECT_RULE_ID => X_OBJECT_RULE_ID,
         X_OBJECT_VERSION_NUMBER => l_obj_verno,
         X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID,
         X_APPROVAL_TYPE => X_APPROVAL_TYPE,
         X_RULE_USED_BY => X_RULE_USED_BY,
         X_OBJECT_TYPE => X_OBJECT_TYPE,
         X_RULE_TYPE => X_RULE_TYPE,
         X_API_TYPE => X_API_TYPE,
         X_PACKAGE_NAME => X_PACKAGE_NAME,
         X_PROCEDURE_NAME => X_PROCEDURE_NAME,
         X_SEEDED_FLAG => X_SEEDED_FLAG,
         X_APPLICATION_ID => X_APPLICATION_ID,
         X_LAST_UPDATE_DATE => SYSDATE,
         X_LAST_UPDATED_BY => l_user_id,
         X_LAST_UPDATE_LOGIN => 0
         );