APPS.HR_NAVIGATION_NODE_USAGES_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_NODE_USAGE_ID in NUMBER,
  X_WORKFLOW_ID in NUMBER,
  X_NAV_NODE_ID in NUMBER,
  X_TOP_NODE in VARCHAR2
) is
  cursor C is select ROWID from HR_NAVIGATION_NODE_USAGES
    where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID
    ;

Line: 14

  insert into HR_NAVIGATION_NODE_USAGES (
    NAV_NODE_USAGE_ID,
    WORKFLOW_ID,
    NAV_NODE_ID,
    TOP_NODE
  ) values (
    X_NAV_NODE_USAGE_ID,
    X_WORKFLOW_ID,
    X_NAV_NODE_ID,
    X_TOP_NODE);

Line: 33

end INSERT_ROW;

Line: 41

  cursor c1 is select
      WORKFLOW_ID,
      NAV_NODE_ID,
      TOP_NODE
    from HR_NAVIGATION_NODE_USAGES
    where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID
    for update of NAV_NODE_USAGE_ID nowait;

Line: 63

procedure UPDATE_ROW (
  X_NAV_NODE_USAGE_ID in NUMBER,
  X_WORKFLOW_ID in NUMBER,
  X_NAV_NODE_ID in NUMBER,
  X_TOP_NODE in VARCHAR2
) is
begin
  update HR_NAVIGATION_NODE_USAGES set
    WORKFLOW_ID = X_WORKFLOW_ID,
    NAV_NODE_ID = X_NAV_NODE_ID,
    TOP_NODE = X_TOP_NODE
  where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID;

Line: 79

end UPDATE_ROW;

Line: 81

procedure DELETE_ROW (
  X_NAV_NODE_USAGE_ID in NUMBER
) is
begin
  delete from HR_NAVIGATION_NODE_USAGES
  where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID;

Line: 92

end DELETE_ROW;

Line: 108

      select WORKFLOW_ID
      into X_WORKFLOW_ID
      from HR_WORKFLOWS
      where WORKFLOW_NAME = X_WORKFLOW_NAME;

Line: 117

      select NAV_NODE_ID
      into X_NAV_NODE_ID
      from HR_NAVIGATION_NODES
      where NAME = X_NODE_NAME;

Line: 126

      select NAV_NODE_USAGE_ID
      into X_NAV_NODE_USAGE_ID
      from HR_NAVIGATION_NODE_USAGES
      where WORKFLOW_ID = X_WORKFLOW_ID
      and NAV_NODE_ID = X_NAV_NODE_ID
      and TOP_NODE = X_TOP_NODE;

Line: 134

          select HR_NAVIGATION_NODE_USAGES_S.NEXTVAL
          into X_NAV_NODE_USAGE_ID
          from dual;

Line: 146

      UPDATE_ROW(
        X_NAV_NODE_USAGE_ID,
        X_WORKFLOW_ID,
        X_NAV_NODE_ID,
        X_TOP_NODE
      );

Line: 158

          INSERT_ROW(
            X_ROWID,
            X_NAV_NODE_USAGE_ID,
            X_WORKFLOW_ID,
            X_NAV_NODE_ID,
            X_TOP_NODE
          );