APPS.HR_NAVIGATION_NODES_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_ID in NUMBER,
  X_NAV_UNIT_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_CUSTOMIZED_RESTRICTION_ID in NUMBER
) is
  cursor C is select ROWID from HR_NAVIGATION_NODES
    where NAV_NODE_ID = X_NAV_NODE_ID
    ;

Line: 14

  insert into HR_NAVIGATION_NODES (
    NAV_NODE_ID,
    NAV_UNIT_ID,
    NAME,
    CUSTOMIZED_RESTRICTION_ID
  ) values (
    X_NAV_NODE_ID,
    X_NAV_UNIT_ID,
    X_NAME,
    X_CUSTOMIZED_RESTRICTION_ID);

Line: 33

end INSERT_ROW;

Line: 41

  cursor c1 is select
      NAV_UNIT_ID,
      CUSTOMIZED_RESTRICTION_ID,
      NAME
    from HR_NAVIGATION_NODES
    where NAV_NODE_ID = X_NAV_NODE_ID
    for update of NAV_NODE_ID nowait;

Line: 64

procedure UPDATE_ROW (
  X_NAV_NODE_ID in NUMBER,
  X_NAV_UNIT_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_CUSTOMIZED_RESTRICTION_ID in NUMBER
) is
begin
  update HR_NAVIGATION_NODES set
    NAV_UNIT_ID = X_NAV_UNIT_ID,
    NAME = X_NAME,
    CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID
  where NAV_NODE_ID = X_NAV_NODE_ID;

Line: 80

end UPDATE_ROW;

Line: 82

procedure DELETE_ROW (
  X_NAV_NODE_ID in NUMBER
) is
begin
  delete from HR_NAVIGATION_NODES
  where NAV_NODE_ID = X_NAV_NODE_ID;

Line: 93

end DELETE_ROW;

Line: 119

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

Line: 129

      select APPLICATION_ID
      into X_APPLICATION_ID
      from FND_APPLICATION
      where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;

Line: 138

      select ORGANIZATION_ID
      into X_BUSINESS_GROUP_ID
      from HR_ORGANIZATION_UNITS
      where NAME = X_ORG_NAME;

Line: 150

	select CUSTOMIZED_RESTRICTION_ID
	into X_CUSTOMIZED_RESTRICTION_ID
	from PAY_CUSTOMIZED_RESTRICTIONS
	where NAME = X_CUSTOMIZATION_NAME
	and APPLICATION_ID = X_APPLICATION_ID
	and FORM_NAME = X_CUSTOMIZED_FORM_NAME
	and nvl(BUSINESS_GROUP_ID,hr_api.g_number) =
            nvl(X_BUSINESS_GROUP_ID,hr_api.g_number)
	and nvl(LEGISLATION_CODE,hr_api.g_varchar2) =
            nvl(X_LEGISLATION_CODE,hr_api.g_varchar2);

Line: 171

      select NAV_NODE_ID, NAV_UNIT_ID, NAME, CUSTOMIZED_RESTRICTION_ID
      into X_NAV_NODE_ID, Y_NAV_UNIT_ID, Y_NODE_NAME, Y_CUSTOMIZED_RESTRICTION_ID
      from HR_NAVIGATION_NODES
      where NAME = X_NODE_NAME;

Line: 188

        UPDATE_ROW(
        X_NAV_NODE_ID,
        X_NAV_UNIT_ID,
        X_NODE_NAME,
        X_CUSTOMIZED_RESTRICTION_ID
        );

Line: 197

          select HR_NAVIGATION_NODES_S.NEXTVAL
          into X_NAV_NODE_ID
          from DUAL;

Line: 201

          INSERT_ROW(
            X_ROWID,
            X_NAV_NODE_ID,
            X_NAV_UNIT_ID,
            X_NODE_NAME,
            X_CUSTOMIZED_RESTRICTION_ID
          );