104:
105: -- construct attribute list --
106:
107: l_username := 'ENG_LIST:'||to_char(X_Approval_List_Id);
108: wf_event.AddParameterToList('DISPLAYNAME', X_Approval_List_Name, mylist);
109: wf_event.AddParameterToList('DESCRIPTION', X_Description, mylist);
110: wf_event.AddParameterToList('USER_NAME', l_username, mylist);
111:
112:
105: -- construct attribute list --
106:
107: l_username := 'ENG_LIST:'||to_char(X_Approval_List_Id);
108: wf_event.AddParameterToList('DISPLAYNAME', X_Approval_List_Name, mylist);
109: wf_event.AddParameterToList('DESCRIPTION', X_Description, mylist);
110: wf_event.AddParameterToList('USER_NAME', l_username, mylist);
111:
112:
113: -- added for synchronize the work flow
106:
107: l_username := 'ENG_LIST:'||to_char(X_Approval_List_Id);
108: wf_event.AddParameterToList('DISPLAYNAME', X_Approval_List_Name, mylist);
109: wf_event.AddParameterToList('DESCRIPTION', X_Description, mylist);
110: wf_event.AddParameterToList('USER_NAME', l_username, mylist);
111:
112:
113: -- added for synchronize the work flow
114: wf_local_synch.propagate_role(p_orig_system=>'ENG_LIST' ,
302: ORIG_SYSTEM_ID = X_Approval_List_Id;
303:
304:
305: -- construct attribute list --
306: wf_event.AddParameterToList('DISPLAYNAME', X_Approval_List_Name, mylist);
307: wf_event.AddParameterToList('DESCRIPTION', X_Description, mylist);
308: wf_event.AddParameterToList('USER_NAME', l_username, mylist);
309: wf_event.AddParameterToList('MAIL', lemail, mylist);
310: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', lfax, mylist);
303:
304:
305: -- construct attribute list --
306: wf_event.AddParameterToList('DISPLAYNAME', X_Approval_List_Name, mylist);
307: wf_event.AddParameterToList('DESCRIPTION', X_Description, mylist);
308: wf_event.AddParameterToList('USER_NAME', l_username, mylist);
309: wf_event.AddParameterToList('MAIL', lemail, mylist);
310: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', lfax, mylist);
311: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE', mylist);
304:
305: -- construct attribute list --
306: wf_event.AddParameterToList('DISPLAYNAME', X_Approval_List_Name, mylist);
307: wf_event.AddParameterToList('DESCRIPTION', X_Description, mylist);
308: wf_event.AddParameterToList('USER_NAME', l_username, mylist);
309: wf_event.AddParameterToList('MAIL', lemail, mylist);
310: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', lfax, mylist);
311: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE', mylist);
312:
305: -- construct attribute list --
306: wf_event.AddParameterToList('DISPLAYNAME', X_Approval_List_Name, mylist);
307: wf_event.AddParameterToList('DESCRIPTION', X_Description, mylist);
308: wf_event.AddParameterToList('USER_NAME', l_username, mylist);
309: wf_event.AddParameterToList('MAIL', lemail, mylist);
310: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', lfax, mylist);
311: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE', mylist);
312:
313:
306: wf_event.AddParameterToList('DISPLAYNAME', X_Approval_List_Name, mylist);
307: wf_event.AddParameterToList('DESCRIPTION', X_Description, mylist);
308: wf_event.AddParameterToList('USER_NAME', l_username, mylist);
309: wf_event.AddParameterToList('MAIL', lemail, mylist);
310: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', lfax, mylist);
311: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE', mylist);
312:
313:
314: -- added for synchronize the work flow
307: wf_event.AddParameterToList('DESCRIPTION', X_Description, mylist);
308: wf_event.AddParameterToList('USER_NAME', l_username, mylist);
309: wf_event.AddParameterToList('MAIL', lemail, mylist);
310: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', lfax, mylist);
311: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE', mylist);
312:
313:
314: -- added for synchronize the work flow
315: wf_local_synch.propagate_role(p_orig_system=>'ENG_LIST' ,
356: RAISE NO_DATA_FOUND;
357: end if;
358:
359: -- construct attribute list --
360: wf_event.AddParameterToList('DELETE','TRUE', mylist);
361:
362: -- added for synchronize the work flow
363: wf_local_synch.propagate_role(p_orig_system=> 'ENG_LIST' ,
364: p_orig_system_id => X_Approval_List_Id,