The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
P_ROWID in out nocopy VARCHAR2,
P_INFORMATION_TYPE in VARCHAR2,
P_ACTIVE_INACTIVE_FLAG in VARCHAR2,
P_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
P_LEGISLATION_CODE in VARCHAR2,
P_OBJECT_VERSION_NUMBER in NUMBER,
P_DESCRIPTION in VARCHAR2
) is
cursor C is select ROWID from PAY_ELEMENT_TYPE_INFO_TYPES
where INFORMATION_TYPE = P_INFORMATION_TYPE;
insert into PAY_ELEMENT_TYPE_INFO_TYPES
(
INFORMATION_TYPE,
ACTIVE_INACTIVE_FLAG,
MULTIPLE_OCCURENCES_FLAG,
LEGISLATION_CODE,
OBJECT_VERSION_NUMBER,
DESCRIPTION
)
values
(
P_INFORMATION_TYPE,
P_ACTIVE_INACTIVE_FLAG,
P_MULTIPLE_OCCURENCES_FLAG,
P_LEGISLATION_CODE,
P_OBJECT_VERSION_NUMBER,
P_DESCRIPTION
);
end INSERT_ROW;
procedure UPDATE_ROW (
P_INFORMATION_TYPE in VARCHAR2,
P_ACTIVE_INACTIVE_FLAG in VARCHAR2,
P_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
P_LEGISLATION_CODE in VARCHAR2,
P_OBJECT_VERSION_NUMBER in NUMBER,
P_DESCRIPTION in VARCHAR2
) is
begin
--
update PAY_ELEMENT_TYPE_INFO_TYPES set
ACTIVE_INACTIVE_FLAG = P_ACTIVE_INACTIVE_FLAG,
MULTIPLE_OCCURENCES_FLAG = P_MULTIPLE_OCCURENCES_FLAG,
LEGISLATION_CODE = P_LEGISLATION_CODE,
OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
DESCRIPTION = P_DESCRIPTION
where INFORMATION_TYPE = P_INFORMATION_TYPE;
end UPDATE_ROW;
UPDATE_ROW
(P_INFORMATION_TYPE => P_INFORMATION_TYPE
,P_ACTIVE_INACTIVE_FLAG => P_ACTIVE_INACTIVE_FLAG
,P_MULTIPLE_OCCURENCES_FLAG => P_MULTIPLE_OCCURENCES_FLAG
,P_DESCRIPTION => P_DESCRIPTION
,P_LEGISLATION_CODE => P_LEGISLATION_CODE
,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
);
INSERT_ROW
(P_ROWID => l_rowid
,P_INFORMATION_TYPE => P_INFORMATION_TYPE
,P_ACTIVE_INACTIVE_FLAG => P_ACTIVE_INACTIVE_FLAG
,P_MULTIPLE_OCCURENCES_FLAG => P_MULTIPLE_OCCURENCES_FLAG
,P_DESCRIPTION => P_DESCRIPTION
,P_LEGISLATION_CODE => P_LEGISLATION_CODE
,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
);
update pay_element_type_info_types
set description = p_description
where userenv('LANG') = (select language_code from fnd_languages
where installed_flag = 'B')
AND information_type = p_information_type;