APPS.IRC_PENDING_DATA_BK1 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 54

,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;

Line: 115

,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
);

Line: 175

,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);