The following lines contain the word 'select', 'insert', 'update' or 'delete':
,P_LAST_UPDATE_DATE in DATE
,P_ALLOW_ACCESS in VARCHAR2
,P_VISITOR_RESP_KEY in VARCHAR2
,P_VISITOR_RESP_APPL_ID in NUMBER
,P_SECURITY_GROUP_KEY in VARCHAR2
)is
l_commit_unit_number number;
,P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE
,P_ALLOW_ACCESS => P_ALLOW_ACCESS
,P_VISITOR_RESP_KEY => P_VISITOR_RESP_KEY
,P_VISITOR_RESP_APPL_ID => P_VISITOR_RESP_APPL_ID
,P_SECURITY_GROUP_KEY => P_SECURITY_GROUP_KEY
);
,P_LAST_UPDATE_DATE in DATE
,P_ALLOW_ACCESS in VARCHAR2
,P_VISITOR_RESP_KEY in VARCHAR2
,P_VISITOR_RESP_APPL_ID in NUMBER
,P_SECURITY_GROUP_KEY in VARCHAR2
)is
begin
hr_utility.set_location('Entering: IRC_PENDING_DATA_BK1.CREATE_PENDING_DATA_B', 10);