The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
;
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);
end INSERT_ROW;
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;
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;
end UPDATE_ROW;
procedure DELETE_ROW (
X_NAV_NODE_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_NODES',
p_ref_entity => 'HR_NAVIGATION_NODE_USAGES',
p_ref_column_name => 'NAV_NODE_ID',
p_ref_col_value_number => X_NAV_NODE_ID,
p_ref_col_value_varchar => null,
p_ref_col_value_date => null,
p_ref_type => 'DEL');
delete from HR_NAVIGATION_NODES
where NAV_NODE_ID = X_NAV_NODE_ID;
end DELETE_ROW;
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);
select APPLICATION_ID
into X_APPLICATION_ID
from FND_APPLICATION
where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;
select ORGANIZATION_ID
into X_BUSINESS_GROUP_ID
from HR_ORGANIZATION_UNITS
where NAME = X_ORG_NAME;
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);
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;
UPDATE_ROW(
X_NAV_NODE_ID,
X_NAV_UNIT_ID,
X_NODE_NAME,
X_CUSTOMIZED_RESTRICTION_ID
);
select HR_NAVIGATION_NODES_S.NEXTVAL
into X_NAV_NODE_ID
from DUAL;
INSERT_ROW(
X_ROWID,
X_NAV_NODE_ID,
X_NAV_UNIT_ID,
X_NODE_NAME,
X_CUSTOMIZED_RESTRICTION_ID
);