APPS.HR_NAV_UNIT_GLOBAL_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_GLOBAL_USAGE_ID in NUMBER,
  X_NAV_UNIT_ID in NUMBER,
  X_GLOBAL_NAME in VARCHAR2,
  X_IN_OR_OUT in VARCHAR2,
  X_MANDATORY_FLAG in VARCHAR2
) is
  cursor C is select ROWID from HR_NAV_UNIT_GLOBAL_USAGES
    where GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID
    ;

Line: 35

  insert into HR_NAV_UNIT_GLOBAL_USAGES (
    GLOBAL_USAGE_ID,
    NAV_UNIT_ID,
    GLOBAL_NAME,
    IN_OR_OUT,
    MANDATORY_FLAG
  ) values (
    X_GLOBAL_USAGE_ID,
    X_NAV_UNIT_ID,
    X_GLOBAL_NAME,
    X_IN_OR_OUT,
    X_MANDATORY_FLAG);

Line: 56

end INSERT_ROW;

Line: 65

  cursor c1 is select
      NAV_UNIT_ID,
      GLOBAL_NAME,
      IN_OR_OUT,
      MANDATORY_FLAG
    from HR_NAV_UNIT_GLOBAL_USAGES
    where GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID
    for update of GLOBAL_USAGE_ID nowait;

Line: 89

procedure UPDATE_ROW (
  X_GLOBAL_USAGE_ID in NUMBER,
  X_NAV_UNIT_ID in NUMBER,
  X_GLOBAL_NAME in VARCHAR2,
  X_IN_OR_OUT in VARCHAR2,
  X_MANDATORY_FLAG in VARCHAR2
) is
begin
  update HR_NAV_UNIT_GLOBAL_USAGES set
    NAV_UNIT_ID = X_NAV_UNIT_ID,
    GLOBAL_NAME = X_GLOBAL_NAME,
    IN_OR_OUT = X_IN_OR_OUT,
    MANDATORY_FLAG = X_MANDATORY_FLAG
  where GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID;

Line: 107

end UPDATE_ROW;

Line: 109

procedure DELETE_ROW (
  X_GLOBAL_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_NAV_UNIT_GLOBAL_USAGES',
    p_ref_entity         	=>	'HR_NAVIGATION_CONTEXT_RULES',
    p_ref_column_name    	=>	'GLOBAL_USAGE_ID',
    p_ref_col_value_number  =>	X_GLOBAL_USAGE_ID,
    p_ref_col_value_varchar =>	NULL,
    p_ref_col_value_date    =>	NULL,
    p_ref_type        		=>	'DEL');

Line: 132

  delete from HR_NAV_UNIT_GLOBAL_USAGES
  where GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID;

Line: 139

end DELETE_ROW;

Line: 157

      select NAV_UNIT_ID
      into X_NAV_UNIT_ID
      from HR_NAVIGATION_UNITS
      where FORM_NAME = X_FORM_NAME
      and nvl(BLOCK_NAME,hr_api.g_varchar2) = nvl(X_BLOCK_NAME,hr_api.g_varchar2);

Line: 165

      select GLOBAL_USAGE_ID,  MANDATORY_FLAG
      into X_GLOBAL_USAGE_ID, Y_MANDATORY_FLAG
      from HR_NAV_UNIT_GLOBAL_USAGES
      where GLOBAL_NAME = X_GLOBAL_NAME
      and IN_OR_OUT = X_IN_OR_OUT
      and NAV_UNIT_ID = X_NAV_UNIT_ID;

Line: 178

      UPDATE_ROW(
        X_GLOBAL_USAGE_ID,
        X_NAV_UNIT_ID,
        X_GLOBAL_NAME,
        X_IN_OR_OUT,
        X_MANDATORY_FLAG
      );

Line: 189

          select HR_NAV_UNIT_GLOBAL_USAGES_S.NEXTVAL
          into X_GLOBAL_USAGE_ID
          from DUAL;

Line: 193

          INSERT_ROW(
          X_ROWID,
          X_GLOBAL_USAGE_ID,
          X_NAV_UNIT_ID,
          X_GLOBAL_NAME,
          X_IN_OR_OUT,
          X_MANDATORY_FLAG
          );