APPS.HR_NAVIGATION_UNITS_PKG SQL Statements

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

Line: 7

  X_LAST_UPDATE_DATE out nocopy DATE,
  X_LAST_UPDATED_BY out nocopy NUMBER,
  X_LAST_UPDATE_LOGIN out nocopy NUMBER
) is
begin
  if X_OWNER = 'SEED' then
    X_CREATED_BY := 1;

Line: 14

    X_LAST_UPDATED_BY := 1;

Line: 17

    X_LAST_UPDATED_BY := 0;

Line: 20

  X_LAST_UPDATE_DATE := sysdate;

Line: 21

  X_LAST_UPDATE_LOGIN := 0;

Line: 24

PROCEDURE Insert_Row(X_Rowid                               IN OUT nocopy VARCHAR2,
                     X_Nav_Unit_Id                         IN OUT nocopy NUMBER,
                     X_Default_Workflow_Id                 NUMBER,
                     X_Application_Abbrev                  VARCHAR2,
                     X_Default_Label                       VARCHAR2,
                     X_Form_Name                           VARCHAR2,
                     X_Max_Number_Of_Nav_Buttons           NUMBER,
                     X_Block_Name                          VARCHAR2,
                     X_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
 ) IS
   CURSOR C IS SELECT rowid FROM HR_NAVIGATION_UNITS

             WHERE nav_unit_id = X_Nav_Unit_Id;

Line: 38

   CURSOR C2 IS SELECT hr_navigation_units_s.nextval FROM sys.dual;

Line: 70

  INSERT INTO HR_NAVIGATION_UNITS(
          nav_unit_id,
          default_workflow_id,
          application_abbrev,
          default_label,
          form_name,
          max_number_of_nav_buttons,
          block_name
          ) VALUES (
          X_Nav_Unit_Id,
          X_Default_Workflow_Id,
          X_Application_Abbrev,
          X_Default_Label,
          X_Form_Name,
          X_Max_Number_Of_Nav_Buttons,
          X_Block_Name
         );

Line: 103

INSERT INTO HR_NAVIGATION_UNITS_TL(
          nav_unit_id,
          default_label,
          language,
          source_lang)
          select
          X_Nav_Unit_Id,
	      x_default_label,
          l.language_code,
          userenv('LANG')
          from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from HR_NAVIGATION_UNITS_TL T
    where T.NAV_UNIT_ID = X_NAV_UNIT_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 126

    hr_utility.set_message_token('PROCEDURE','INSERT_ROW');

Line: 131

END Insert_Row;

Line: 143

      SELECT *
      FROM   HR_NAVIGATION_UNITS
      WHERE  rowid = X_Rowid
      FOR UPDATE of Nav_Unit_Id NOWAIT;

Line: 150

    select DEFAULT_LABEL,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from HR_NAVIGATION_UNITS_TL TL
    where nav_unit_id = x_nav_unit_id
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of nav_unit_id nowait;

Line: 216

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Nav_Unit_Id                         NUMBER,
                     X_Default_Workflow_Id                 NUMBER,
                     X_Application_Abbrev                  VARCHAR2,
                     X_Default_Label                       VARCHAR2,
                     X_Form_Name                           VARCHAR2,
                     X_Max_Number_Of_Nav_Buttons           NUMBER,
                     X_Block_Name                          VARCHAR2,
                     X_Language_Code varchar2 default hr_api.userenv_lang
                     )
                     IS
l_language_code varchar2(3);

Line: 237

  UPDATE HR_NAVIGATION_UNITS
  SET
    nav_unit_id                               =    X_Nav_Unit_Id,
    default_workflow_id                       =    X_Default_Workflow_Id,
    application_abbrev                        =    X_Application_Abbrev,
    default_label                             =    X_Default_Label,
    form_name                                 =    X_Form_Name,
    max_number_of_nav_buttons                 =    X_Max_Number_Of_Nav_Buttons,
    block_name                                =    X_Block_Name
  WHERE rowid = X_rowid;

Line: 250

   hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');

Line: 255

    update HR_NAVIGATION_UNITS_TL
    set
    DEFAULT_LABEL = X_DEFAULT_LABEL,
    SOURCE_LANG = userenv('LANG')
  where NAV_UNIT_ID = X_NAV_UNIT_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 264

   hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');

Line: 269

END Update_Row;

Line: 274

Procedure UPDATE_ROW (X_NAV_UNIT_ID                      NUMBER,
  		X_DEFAULT_WORKFLOW_ID  	                		 NUMBER,
  		X_APPLICATION_ABBREV  		                	 VARCHAR2,
  		X_DEFAULT_LABEL  		                    	 VARCHAR2,
  		X_FORM_NAME  			                    	 VARCHAR2,
  		X_MAX_NUMBER_OF_NAV_BUTTONS  	            	 NUMBER,
  		X_BLOCK_NAME  				                     VARCHAR2,
        X_LANGUAGE_CODE	 in varchar2 default hr_api.userenv_lang
) is
l_language_code varchar2(3);

Line: 294

  update HR_NAVIGATION_UNITS set
    DEFAULT_WORKFLOW_ID = X_DEFAULT_WORKFLOW_ID,
    APPLICATION_ABBREV = X_APPLICATION_ABBREV,
    DEFAULT_LABEL = X_DEFAULT_LABEL,
    FORM_NAME = X_FORM_NAME,
    MAX_NUMBER_OF_NAV_BUTTONS = X_MAX_NUMBER_OF_NAV_BUTTONS,
    BLOCK_NAME = X_BLOCK_NAME
  where NAV_UNIT_ID = X_NAV_UNIT_ID;

Line: 307

      update HR_NAVIGATION_UNITS_TL
    set
    DEFAULT_LABEL = X_DEFAULT_LABEL,
    SOURCE_LANG = userenv('LANG')
  where NAV_UNIT_ID = X_NAV_UNIT_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 318

end UPDATE_ROW;

Line: 320

PROCEDURE Delete_Row(x_nav_unit_id varchar2, X_Rowid VARCHAR2) IS
BEGIN

  delete from HR_NAVIGATION_UNITS_TL
  where NAV_UNIT_ID = X_NAV_UNIT_ID;

Line: 328

     hr_utility.set_message_token('PROCEDURE','DELETE_ROW');

Line: 356

  DELETE FROM HR_NAVIGATION_UNITS
  WHERE  rowid = X_Rowid;

Line: 361

     hr_utility.set_message_token('PROCEDURE','DELETE_ROW');

Line: 365

END Delete_Row;

Line: 370

  delete from HR_NAVIGATION_UNITS_TL T
  where not exists
    (select NULL
    from HR_NAVIGATION_UNITS B
    where B.NAV_UNIT_ID = T.NAV_UNIT_ID
    );

Line: 377

  update HR_NAVIGATION_UNITS_TL T set (
      DEFAULT_LABEL
    ) = (select
      B.DEFAULT_LABEL
    from HR_NAVIGATION_UNITS_TL B
    where B.NAV_UNIT_ID = T.NAV_UNIT_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.NAV_UNIT_ID,
      T.LANGUAGE
  ) in (select
      SUBT.NAV_UNIT_ID,
      SUBT.LANGUAGE
    from HR_NAVIGATION_UNITS_TL SUBB, HR_NAVIGATION_UNITS_TL SUBT
    where SUBB.NAV_UNIT_ID = SUBT.NAV_UNIT_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.DEFAULT_LABEL <> SUBT.DEFAULT_LABEL
      or (SUBB.DEFAULT_LABEL is null and SUBT.DEFAULT_LABEL is not null)
      or (SUBB.DEFAULT_LABEL is not null and SUBT.DEFAULT_LABEL is null)
  ));

Line: 398

  insert into HR_NAVIGATION_UNITS_TL (
    NAV_UNIT_ID,
    DEFAULT_LABEL,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.NAV_UNIT_ID,
    B.DEFAULT_LABEL,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from HR_NAVIGATION_UNITS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from HR_NAVIGATION_UNITS_TL T
    where T.NAV_UNIT_ID = B.NAV_UNIT_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 441

      select workflow_id
      into X_DEFAULT_WORKFLOW_ID
      from hr_workflows
      where workflow_name = X_WORKFLOW_NAME;

Line: 451

      select NAV_UNIT_ID,DEFAULT_WORKFLOW_ID, APPLICATION_ABBREV, DEFAULT_LABEL,MAX_NUMBER_OF_NAV_BUTTONS
      into X_NAV_UNIT_ID, Y_DEFAULT_WORKFLOW_ID, Y_APPLICATION_ABBREV,
           Y_DEFAULT_LABEL,Y_MAX_NUMBER_OF_NAV_BUTTONS
      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: 468

      UPDATE_ROW(
        X_NAV_UNIT_ID,
        X_DEFAULT_WORKFLOW_ID,
        X_APPLICATION_ABBREV,
        X_DEFAULT_LABEL,
        X_FORM_NAME,
        X_MAX_NUMBER_OF_NAV_BUTTONS,
        X_BLOCK_NAME
      );

Line: 481

          select HR_NAVIGATION_UNITS_S.NEXTVAL
          into X_NAV_UNIT_ID
          from dual;

Line: 485

          INSERT_ROW(
            X_ROWID,
            X_NAV_UNIT_ID,
            X_DEFAULT_WORKFLOW_ID,
            X_APPLICATION_ABBREV,
            X_DEFAULT_LABEL,
            X_FORM_NAME,
            X_MAX_NUMBER_OF_NAV_BUTTONS,
            X_BLOCK_NAME
              );

Line: 513

   SELECT DEFAULT_LABEL, SOURCE_LANG
   FROM   HR_NAVIGATION_UNITS_TL
   WHERE  userenv('LANG') in (LANGUAGE,SOURCE_LANG)
   AND    nav_unit_id = p_nav_unit_id;

Line: 519

select nav_unit_id
into x_nav_unit_id
from hr_navigation_units
where  FORM_NAME = X_FORM_NAME
  and    (  (BLOCK_NAME = X_BLOCK_NAME)
	    or (BLOCK_NAME is null and X_BLOCK_NAME is null));

Line: 535

          update HR_NAVIGATION_UNITS_TL
          set    DEFAULT_LABEL = X_DEFAULT_LABEL,
                 SOURCE_LANG = userenv('LANG')
          where  userenv('LANG') in (LANGUAGE,SOURCE_LANG)
          and    nav_unit_id = x_nav_unit_id;