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: 9

    SELECT nav_node_usage_id
    FROM   hr_navigation_node_usages
    WHERE  workflow_id = x_workflow_id;

Line: 13

    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: 29

          DELETE FROM hr_navigation_paths_tl
          WHERE  nav_path_id = l_nav_path_id;

Line: 50

          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: 75

      DELETE FROM hr_navigation_node_usages
      WHERE  nav_node_usage_id = l_nav_node_usage_id;

Line: 79

END cleanup_taskflow_update;

Line: 82

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: 93

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

Line: 108

end INSERT_ROW;

Line: 115

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

Line: 135

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: 149

end UPDATE_ROW;

Line: 151

procedure DELETE_ROW (
  X_WORKFLOW_ID in NUMBER
) is
begin

--
-- Added the following code as a part of Zero Downtime Patching Project.
-- Code Starts Here.
--

BEGIN

   PER_RIC_PKG.chk_integrity (
		p_entity_name		=> 	'HR_WORKFLOWS',
		p_ref_entity_info	=>	PER_RIC_PKG.ref_entity_tbl(
									PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(
											PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
									PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
											PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL)))),
		p_ref_type			=>	'DEL');

Line: 178

  delete from HR_WORKFLOWS
  where WORKFLOW_ID = X_WORKFLOW_ID;

Line: 185

end DELETE_ROW;

Line: 199

    select TERRITORY_CODE
    into X_LEGISLATION_CODE
    from FND_TERRITORIES_VL
    where TERRITORY_SHORT_NAME=X_LEGISLATION_NAME;

Line: 213

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

Line: 237

      select WORKFLOW_ID
      into   X_WORKFLOW_ID
      from   HR_WORKFLOWS
      where  WORKFLOW_NAME=X_WORKFLOW_NAME;

Line: 244

          select HR_WORKFLOWS_S.NEXTVAL
          into   X_WORKFLOW_ID
          from   DUAL;

Line: 250

      cleanup_taskflow_update(X_WORKFLOW_ID);

Line: 251

      UPDATE_ROW(
        X_WORKFLOW_ID,
        X_WORKFLOW_NAME,
        X_LEGISLATION_CODE
      );

Line: 258

          INSERT_ROW(
              X_ROWID,
              X_WORKFLOW_ID,
              X_WORKFLOW_NAME,
              X_LEGISLATION_CODE);