The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_insert varchar2(2000):= 'The Information Type: ' || v_info_type_name || ' has been inserted into the table: ' || v_table_name;
l_updated_by number := fnd_profile.value('USER_ID');
l_update_login number := fnd_profile.value('USER_ID');
l_update_date date := trunc(sysdate);
INSERT INTO PER_PEOPLE_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO PER_ASSIGNMENT_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
insert into PER_ASSIGNMENT_INFO_TYPES_TL
(INFORMATION_TYPE
,LANGUAGE
,SOURCE_LANG
,DESCRIPTION
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
)
select M.INFORMATION_TYPE
,L.LANGUAGE_CODE
,B.LANGUAGE_CODE
,M.DESCRIPTION
,M.LAST_UPDATE_DATE
,M.LAST_UPDATED_BY
,M.LAST_UPDATE_LOGIN
,M.CREATED_BY
,M.CREATION_DATE
from PER_ASSIGNMENT_INFO_TYPES M
,FND_LANGUAGES L
,FND_LANGUAGES B
where M.INFORMATION_TYPE = v_info_type_name
and L.INSTALLED_FLAG in ('I', 'B')
and B.INSTALLED_FLAG = 'B'
and not exists (select '1'
from per_assignment_info_types_tl pait
where pait.information_type = m.information_type
and pait.language = l.language_code);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO PER_POSITION_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO PQP_VEH_ALLOC_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO PQP_VEH_REPOS_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO HR_LOCATION_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO PER_JOB_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO PER_CONTACT_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
insert into PER_CONTACT_INFO_TYPES_TL
(INFORMATION_TYPE
, LANGUAGE
, SOURCE_LANG
, DESCRIPTION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
select M.INFORMATION_TYPE
, L.LANGUAGE_CODE
, B.LANGUAGE_CODE
, v_desc
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.LAST_UPDATE_LOGIN
, M.CREATED_BY
, M.CREATION_DATE
from PER_CONTACT_INFO_TYPES M
, FND_LANGUAGES L
, FND_LANGUAGES B
where M.INFORMATION_TYPE = v_info_type_name
and L.INSTALLED_FLAG in ('I', 'B')
and B.INSTALLED_FLAG = 'B'
and not exists ( select '1'
from per_contact_info_types_tl pcit
where pcit.information_type = m.information_type
and pcit.language = l.language_code);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO PER_PREV_JOB_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURANCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO PAY_ELEMENT_TYPE_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO BEN_OPT_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO BEN_ABR_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO BEN_PL_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO BEN_ELP_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO BEN_LER_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO BEN_PGM_INFO_TYPES
(INFORMATION_TYPE
,ACTIVE_INACTIVE_FLAG
,MULTIPLE_OCCURENCES_FLAG
,DESCRIPTION
,LEGISLATION_CODE
,OBJECT_VERSION_NUMBER)
VALUES
(v_info_type_name
,v_active_flag
,v_multi_row
,v_desc
,v_leg_code
,1);
fnd_file.put_line(fnd_file.log,l_insert);
hr_org_information_types_pkg.insert_row
(v_info_type_name
,null
,v_leg_code
,l_navig_method
,l_application_id
,v_desc
,v_desc
,l_creation_date
,l_created_by
,l_update_date
,l_updated_by
,l_update_login);
fnd_file.put_line(fnd_file.log,l_insert);
INSERT INTO HR_ORG_INFO_TYPES_BY_CLASS
(ORG_CLASSIFICATION
,ORG_INFORMATION_TYPE
,MANDATORY_FLAG
,ENABLED_FLAG )
SELECT
v_org_class
,v_info_type_name
,'N'
,'Y'
FROM sys.dual
WHERE not exists (SELECT 1
FROM HR_ORG_INFO_TYPES_BY_CLASS
WHERE ORG_INFORMATION_TYPE =v_info_type_name
and ORG_CLASSIFICATION = v_org_class);
l_insert := 'The Information has been inserted into the table HR_ORG_INFO_TYPES_BY_CLASS for Organization Classification ' || v_org_class;
fnd_file.put_line(fnd_file.log,l_insert);
l_insert := 'The Document Type : "' || p_info_type_name || '" has been created';
fnd_file.put_line(fnd_file.log,l_insert);