APPS.FND_WF_SYNCH SQL Statements

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

Line: 29

   old_employeeId in number -- employee_id before the update.
       -- this is important since we need to determine if there
       -- would be a change in orig_system and orig_system_id
)
AS
l_userId number;

Line: 55

procedure propagateUserUpdate
( userId in number,
  userName in varchar2,
  employeeId in number,
  description in varchar2,
  emailAddress in varchar2,
  fax in varchar2,
  startDate in date,
  endDate in date,
  old_employeeId in number)
AS
  l_language varchar2(240);

Line: 81

   select role_name, role_orig_system, role_orig_system_id
  from wf_local_user_roles
  where user_name = c_userName
  and user_orig_system =c_origSystem
  and user_orig_system_id = c_personId;*/

Line: 95

end propagateUserUpdate;

Line: 101

procedure propagateUserInsert
( userId in number,
  userName in varchar2,
  employeeId in number,
  description in varchar2,
  emailAddress in varchar2,
  fax in varchar2,
  startDate in date,
  endDate in date)
 as
  l_language varchar2(240);

Line: 131

end propagateUserInsert;

Line: 155

procedure propagateUserRespInsert(
userId in number,
responsibilityId in number,
respApplId in number, -- RESPONSIBILITY_APPLICATION_ID
startDate in date,
endDate in date)
AS
  l_userOrigSystem varchar2(30);

Line: 175

end propagateUserRespInsert;

Line: 180

procedure propagateUserRespUpdate(
userId in number,
responsibilityId in number,
respApplId in number, -- RESPONSIBILITY_APPLICATION_ID
startDate in date,
endDate in date
)
AS
  l_userOrigSystem varchar2(30);

Line: 201

end propagateUserRespUpdate;

Line: 209

procedure propagateUserRespDelete(
userId in number,
responsibilityId in number,
respApplId in number -- RESPONSIBILITY_APPLICATION_ID
)
AS
  l_userOrigSystem varchar2(30);

Line: 228

end propagateUserRespDelete;

Line: 234

procedure propagateRespInsert(
applicationId in number,
responsibilityId in number,
responsibilityName in varchar2,
description in varchar2,
start_date in date,
end_date in date)
AS
  l_language varchar2(30);

Line: 254

end propagateRespInsert;

Line: 263

procedure propagateRespUpdate(
applicationId in number,
responsibilityId in number,
responsibilityName in varchar2,
description in varchar2,
start_date in date,
end_date in date)
AS
  l_languageCode varchar2(4);

Line: 284

end propagateRespUpdate;

Line: 298

procedure propagateRespUpdate(
applicationId in number,
responsibilityId in number)
AS
  l_languageCode varchar2(4);

Line: 317

end propagateRespUpdate;

Line: 323

procedure propagateRespDelete(
applicationId in number,
responsibilityId in number)
AS
begin

null;

Line: 330

end propagateRespDelete;