APPS.AME_CONDITION_USAGES_API2 SQL Statements

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

Line: 7

  X_LAST_UPDATED_BY out nocopy NUMBER,
  X_LAST_UPDATE_LOGIN out nocopy NUMBER
) is
begin
  X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

Line: 12

  X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

Line: 13

  X_LAST_UPDATE_LOGIN := 0;

Line: 27

  select CONDITION_ID
    from AME_CONDITIONS
   where CONDITION_KEY = X_CONDITION_KEY;

Line: 34

  select RULE_ID
    from AME_RULES
   where RULE_KEY = X_RULE_KEY;

Line: 42

  select 'FOUND'
    from AME_CONDITION_USAGES
   where CONDITION_ID = X_CONDITION_ID
     and RULE_ID = X_RULE_ID;

Line: 90

  select COUNT(*)
    from AME_CONDITION_USAGES
   where CONDITION_ID = X_CONDITION_ID
     and RULE_ID = X_RULE_ID;

Line: 122

  select COUNT(*)
    from AME_CONDITION_USAGES
   where CONDITION_ID = X_CONDITION_ID
     and RULE_ID = X_RULE_ID;

Line: 130

  select RULE_ID
    from AME_RULES
   where RULE_KEY = X_RULE_KEY;

Line: 154

procedure INSERT_ROW (
 X_RULE_ID                         in NUMBER,
 X_CONDITION_ID                    in NUMBER,
 X_CREATED_BY                      in NUMBER,
 X_CREATION_DATE                   in DATE,
 X_LAST_UPDATED_BY                 in NUMBER,
 X_LAST_UPDATE_DATE                in DATE,
 X_LAST_UPDATE_LOGIN               in NUMBER,
 X_START_DATE                      in DATE,
 X_OBJECT_VERSION_NUMBER           in NUMBER)
 is

begin

  insert into AME_CONDITION_USAGES
  (
   RULE_ID,
   CONDITION_ID,
   CREATED_BY,
   CREATION_DATE,
   LAST_UPDATED_BY,
   LAST_UPDATE_DATE,
   LAST_UPDATE_LOGIN,
   START_DATE,
   END_DATE,
   OBJECT_VERSION_NUMBER
  ) values (
   X_RULE_ID,
   X_CONDITION_ID,
   X_CREATED_BY,
   X_CREATION_DATE,
   X_LAST_UPDATED_BY,
   X_LAST_UPDATE_DATE,
   X_LAST_UPDATE_LOGIN,
   X_START_DATE,
   AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
   X_OBJECT_VERSION_NUMBER);

Line: 192

end INSERT_ROW;

Line: 194

procedure DELETE_ROW (
  X_RULE_ID in NUMBER,
  X_CONDITION_ID in NUMBER)
is
begin
  delete from AME_CONDITION_USAGES
  where RULE_ID      = X_RULE_ID
    and CONDITION_ID = X_CONDITION_ID;

Line: 205

end DELETE_ROW;

Line: 213

          X_LAST_UPDATE_DATE in VARCHAR2,
          X_CUSTOM_MODE      in VARCHAR2
)
is
  X_CONDITION_ID_LOAD NUMBER;

Line: 221

  X_LAST_UPDATED_BY NUMBER;

Line: 222

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 228

    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 245

     INSERT_ROW (
       X_RULE_ID_LOAD,
       X_CONDITION_ID_LOAD,
       X_CREATED_BY,
       to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
       X_LAST_UPDATED_BY,
       to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
       X_LAST_UPDATE_LOGIN,
       to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
       1);

Line: 268

      INSERT_ROW (
        X_RULE_ID,
        X_CONDITION_ID,
        X_CREATED_BY,
        to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
        X_LAST_UPDATED_BY,
        to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
        X_LAST_UPDATE_LOGIN,
        to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
        1);

Line: 290

      INSERT_ROW (
        X_RULE_ID_LOAD,
        X_CONDITION_ID,
        X_CREATED_BY,
        to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
        X_LAST_UPDATED_BY,
        to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
        X_LAST_UPDATE_LOGIN,
        to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
        1);