APPS.HR_WORKFLOWS_PKG SQL Statements

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

Line: 4

procedure CLEANUP_TASKFLOW_UPDATE (
  X_WORKFLOW_ID in NUMBER
) is
l_nav_node_usage_id NUMBER;

Line: 10

  SELECT nav_node_usage_id
  FROM   hr_navigation_node_usages
  WHERE  workflow_id = x_workflow_id;

Line: 15

  SELECT nav_path_id
  FROM   hr_navigation_paths
  WHERE  from_nav_node_usage_id = l_nav_node_usage_id
  OR     to_nav_node_usage_id = l_nav_node_usage_id;

Line: 30

       DELETE FROM hr_navigation_paths_tl
       WHERE       nav_path_id = l_nav_path_id;

Line: 33

       DELETE FROM hr_navigation_paths
       WHERE       from_nav_node_usage_id = l_nav_node_usage_id
       OR          to_nav_node_usage_id = l_nav_node_usage_id;

Line: 39

     DELETE FROM hr_navigation_node_usages
     WHERE       nav_node_usage_id = l_nav_node_usage_id;

Line: 43

end CLEANUP_TASKFLOW_UPDATE;

Line: 45

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_WORKFLOW_ID in NUMBER,
  X_WORKFLOW_NAME in VARCHAR2,
  X_LEGISLATION_CODE in VARCHAR2
) is
  cursor C is select ROWID from HR_WORKFLOWS
    where WORKFLOW_ID = X_WORKFLOW_ID
    ;

Line: 55

  insert into HR_WORKFLOWS (
    WORKFLOW_ID,
    WORKFLOW_NAME,
    LEGISLATION_CODE
  )
  values (X_WORKFLOW_ID,X_WORKFLOW_NAME,X_LEGISLATION_CODE);

Line: 70

end INSERT_ROW;

Line: 77

  cursor c1 is select
      WORKFLOW_NAME,
      LEGISLATION_CODE
    from HR_WORKFLOWS
    where WORKFLOW_ID = X_WORKFLOW_ID
    for update of WORKFLOW_ID nowait;

Line: 97

procedure UPDATE_ROW (
  X_WORKFLOW_ID in NUMBER,
  X_WORKFLOW_NAME in VARCHAR2,
  X_LEGISLATION_CODE in VARCHAR2
) is
begin
  update HR_WORKFLOWS set
    WORKFLOW_NAME = X_WORKFLOW_NAME,
    LEGISLATION_CODE = X_LEGISLATION_CODE
  where WORKFLOW_ID = X_WORKFLOW_ID;

Line: 111

end UPDATE_ROW;

Line: 113

procedure DELETE_ROW (
  X_WORKFLOW_ID in NUMBER
) is
begin
  delete from HR_WORKFLOWS
  where WORKFLOW_ID = X_WORKFLOW_ID;

Line: 124

end DELETE_ROW;

Line: 138

    select TERRITORY_CODE
    into X_LEGISLATION_CODE
    from FND_TERRITORIES_VL
    where TERRITORY_SHORT_NAME=X_LEGISLATION_NAME;

Line: 152

    select STATUS, ACTION
    into   X_STATUS, X_ACTION
    from   HR_LEGISLATION_INSTALLATIONS
    where  LEGISLATION_CODE = X_LEGISLATION_CODE
    and    APPLICATION_SHORT_NAME = 'PER';

Line: 176

      select WORKFLOW_ID
      into   X_WORKFLOW_ID
      from   HR_WORKFLOWS
      where  WORKFLOW_NAME=X_WORKFLOW_NAME;

Line: 183

          select HR_WORKFLOWS_S.NEXTVAL
          into   X_WORKFLOW_ID
          from   DUAL;

Line: 189

      cleanup_taskflow_update(X_WORKFLOW_ID);

Line: 190

      UPDATE_ROW(
        X_WORKFLOW_ID,
        X_WORKFLOW_NAME,
        X_LEGISLATION_CODE
      );

Line: 197

          INSERT_ROW(
              X_ROWID,
              X_WORKFLOW_ID,
              X_WORKFLOW_NAME,
              X_LEGISLATION_CODE);