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

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

end INSERT_ROW;

Line: 62

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

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

end UPDATE_ROW;

Line: 102

procedure DELETE_ROW (
  X_NAV_NODE_USAGE_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_NAVIGATION_NODE_USAGES',
    p_ref_entity		=>	'HR_NAVIGATION_PATHS',
    p_ref_column_info	=>	PER_RIC_PKG.column_info_tbl(
								PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,
								PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL)
							),
    p_ref_type			=>	'DEL');

Line: 126

  delete from HR_NAVIGATION_NODE_USAGES
  where NAV_NODE_USAGE_ID = X_NAV_NODE_USAGE_ID;

Line: 133

end DELETE_ROW;

Line: 149

      select WORKFLOW_ID
      into X_WORKFLOW_ID
      from HR_WORKFLOWS
      where WORKFLOW_NAME = X_WORKFLOW_NAME;

Line: 158

      select NAV_NODE_ID
      into X_NAV_NODE_ID
      from HR_NAVIGATION_NODES
      where NAME = X_NODE_NAME;

Line: 167

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

          select HR_NAVIGATION_NODE_USAGES_S.NEXTVAL
          into X_NAV_NODE_USAGE_ID
          from dual;

Line: 187

      UPDATE_ROW(
        X_NAV_NODE_USAGE_ID,
        X_WORKFLOW_ID,
        X_NAV_NODE_ID,
        X_TOP_NODE
      );

Line: 199

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