APPS.HR_NAV_CONTEXT_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_NAV_CONTEXT_RULE_ID in NUMBER,
  X_GLOBAL_USAGE_ID in NUMBER,
  X_EVALUATION_TYPE_CODE in VARCHAR2,
  X_VALUE in VARCHAR2
) is
  cursor C is select ROWID from HR_NAVIGATION_CONTEXT_RULES
    where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID
    ;

Line: 14

  insert into HR_NAVIGATION_CONTEXT_RULES (
    NAV_CONTEXT_RULE_ID,
    GLOBAL_USAGE_ID,
    EVALUATION_TYPE_CODE,
    VALUE
  ) values (
    X_NAV_CONTEXT_RULE_ID,
    X_GLOBAL_USAGE_ID,
    X_EVALUATION_TYPE_CODE,
    X_VALUE);

Line: 33

end INSERT_ROW;

Line: 41

  cursor c1 is select
      GLOBAL_USAGE_ID,
      EVALUATION_TYPE_CODE,
      VALUE
    from HR_NAVIGATION_CONTEXT_RULES
    where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID
    for update of NAV_CONTEXT_RULE_ID nowait;

Line: 64

procedure UPDATE_ROW (
  X_NAV_CONTEXT_RULE_ID in NUMBER,
  X_GLOBAL_USAGE_ID in NUMBER,
  X_EVALUATION_TYPE_CODE in VARCHAR2,
  X_VALUE in VARCHAR2
) is
begin
  update HR_NAVIGATION_CONTEXT_RULES set
    GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID,
    EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE,
    VALUE = X_VALUE
  where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID;

Line: 80

end UPDATE_ROW;

Line: 82

procedure DELETE_ROW (
  X_NAV_CONTEXT_RULE_ID in NUMBER
) is
begin
  delete from HR_NAVIGATION_CONTEXT_RULES
  where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID;

Line: 93

end DELETE_ROW;

Line: 112

      select NAV_UNIT_ID
      into X_NAV_UNIT_ID
      from HR_NAVIGATION_UNITS
      where FORM_NAME = X_FORM_NAME
      and nvl(BLOCK_NAME,hr_api.g_varchar2) = nvl(X_BLOCK_NAME,hr_api.g_varchar2);

Line: 119

    select GLOBAL_USAGE_ID
    into X_GLOBAL_USAGE_ID
    from HR_NAV_UNIT_GLOBAL_USAGES
    where GLOBAL_NAME = X_GLOBAL_NAME
    and IN_OR_OUT = X_IN_OR_OUT
    and NAV_UNIT_ID = X_NAV_UNIT_ID;

Line: 133

      select NCR.NAV_CONTEXT_RULE_ID
      into X_NAV_CONTEXT_RULE_ID
      from HR_NAVIGATION_CONTEXT_RULES NCR
      where NCR.EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE
      and nvl(NCR.VALUE,hr_api.g_varchar2) = nvl(X_VALUE,hr_api.g_varchar2)
      and NCR.GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID;

Line: 141

          select HR_NAVIGATION_CONTEXT_RULES_S.NEXTVAL
          into X_NAV_CONTEXT_RULE_ID
          from DUAL;

Line: 145

           INSERT_ROW(
            X_ROWID,
            X_NAV_CONTEXT_RULE_ID,
            X_GLOBAL_USAGE_ID,
            X_EVALUATION_TYPE_CODE,
            X_VALUE
          );

Line: 158

      UPDATE_ROW(
        X_NAV_CONTEXT_RULE_ID,
        X_GLOBAL_USAGE_ID,
        X_EVALUATION_TYPE_CODE,
        X_VALUE
      );

Line: 166

          INSERT_ROW(
            X_ROWID,
            X_NAV_CONTEXT_RULE_ID,
            X_GLOBAL_USAGE_ID,
            X_EVALUATION_TYPE_CODE,
            X_VALUE
          );