APPS.HR_NAVIGATION_UNITS_LCT_PKG SQL Statements

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

Line: 4

  procedure INSERT_ROW (
  X_NAV_UNIT_ID in out NUMBER,
  X_FORM_NAME in VARCHAR2,
  X_BLOCK_NAME in VARCHAR2,
  X_DEFAULT_WORKFLOW_ID in NUMBER,
  X_APPLICATION_ABBREV in VARCHAR2,
  X_MAX_NUMBER_OF_NAV_BUTTONS in NUMBER,
  X_DEFAULT_LABEL in VARCHAR2
) is
  cursor CSR_SEQUENCE is
    select HR_NAVIGATION_UNITS_S.nextval
    from   dual;

Line: 22

  insert into HR_NAVIGATION_UNITS (
    NAV_UNIT_ID,
    FORM_NAME,
    BLOCK_NAME,
    DEFAULT_WORKFLOW_ID,
    APPLICATION_ABBREV,
    MAX_NUMBER_OF_NAV_BUTTONS,
    DEFAULT_LABEL
  ) values (
    X_NAV_UNIT_ID,
    X_FORM_NAME,
    X_BLOCK_NAME,
    X_DEFAULT_WORKFLOW_ID,
    X_APPLICATION_ABBREV,
    X_MAX_NUMBER_OF_NAV_BUTTONS,
    X_DEFAULT_LABEL
  );

Line: 39

end INSERT_ROW;

Line: 52

    select FORM_NAME,
           BLOCK_NAME,
           DEFAULT_WORKFLOW_ID,
           APPLICATION_ABBREV,
           MAX_NUMBER_OF_NAV_BUTTONS
    from   HR_NAVIGATION_UNITS
    where  NAV_UNIT_ID = X_NAV_UNIT_ID
    for update of NAV_UNIT_ID nowait;

Line: 66

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

Line: 88

procedure UPDATE_ROW (
  X_NAV_UNIT_ID in NUMBER,
  X_FORM_NAME in VARCHAR2,
  X_BLOCK_NAME in VARCHAR2,
  X_DEFAULT_WORKFLOW_ID in NUMBER,
  X_APPLICATION_ABBREV in VARCHAR2,
  X_MAX_NUMBER_OF_NAV_BUTTONS in NUMBER,
  X_DEFAULT_LABEL in VARCHAR2
) is
begin
  update HR_NAVIGATION_UNITS set
    FORM_NAME = X_FORM_NAME,
    BLOCK_NAME = X_BLOCK_NAME,
    DEFAULT_WORKFLOW_ID = X_DEFAULT_WORKFLOW_ID,
    APPLICATION_ABBREV = X_APPLICATION_ABBREV,
    MAX_NUMBER_OF_NAV_BUTTONS = X_MAX_NUMBER_OF_NAV_BUTTONS,
    DEFAULT_LABEL = X_DEFAULT_LABEL
  where NAV_UNIT_ID = X_NAV_UNIT_ID;

Line: 109

end UPDATE_ROW;

Line: 111

procedure DELETE_ROW (
  X_NAV_UNIT_ID in NUMBER
) is
begin
  delete from HR_NAVIGATION_UNITS
  where NAV_UNIT_ID = X_NAV_UNIT_ID;

Line: 120

end DELETE_ROW;

Line: 135

    select NAV_UNIT_ID
    from   HR_NAVIGATION_UNITS
    where FORM_NAME = X_FORM_NAME
    and   (  (BLOCK_NAME = X_BLOCK_NAME)
          or (BLOCK_NAME is null and X_BLOCK_NAME is null));

Line: 143

    select WORKFLOW_ID
    from   HR_WORKFLOWS
    where  WORKFLOW_NAME = X_WORKFLOW_NAME;

Line: 156

    UPDATE_ROW (
      X_NAV_UNIT_ID,
      X_FORM_NAME,
      X_BLOCK_NAME,
      X_DEFAULT_WORKFLOW_ID,
      X_APPLICATION_ABBREV,
      X_MAX_NUMBER_OF_NAV_BUTTONS,
      X_DEFAULT_LABEL
    );

Line: 167

      INSERT_ROW (
        X_NAV_UNIT_ID,
        X_FORM_NAME,
        X_BLOCK_NAME,
        X_DEFAULT_WORKFLOW_ID,
        X_APPLICATION_ABBREV,
        X_MAX_NUMBER_OF_NAV_BUTTONS,
        X_DEFAULT_LABEL
      );

Line: 186

  update HR_NAVIGATION_UNITS set
    DEFAULT_LABEL = X_DEFAULT_LABEL
  where FORM_NAME = X_FORM_NAME
  and   (  (BLOCK_NAME = X_BLOCK_NAME)
        or (BLOCK_NAME is null and X_BLOCK_NAME is null))
  and   userenv('LANG') = (select LANGUAGE_CODE
                           from   FND_LANGUAGES
                           where  INSTALLED_FLAG = 'B');