152: select count(*) into cnt from hr_all_positions_f where position_id = l_position_id and availability_status_id = 1;
153: if cnt = 0 then
154: select hr_general.effective_date into l_expiration_date from dual;
155:
156: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
157: wf_event.AddParameterToList( 'DISPLAYNAME', '-', l_plist);
158: wf_event.AddParameterToList( 'DESCRIPTION', '-', l_plist);
159: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
153: if cnt = 0 then
154: select hr_general.effective_date into l_expiration_date from dual;
155:
156: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
157: wf_event.AddParameterToList( 'DISPLAYNAME', '-', l_plist);
158: wf_event.AddParameterToList( 'DESCRIPTION', '-', l_plist);
159: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
154: select hr_general.effective_date into l_expiration_date from dual;
155:
156: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
157: wf_event.AddParameterToList( 'DISPLAYNAME', '-', l_plist);
158: wf_event.AddParameterToList( 'DESCRIPTION', '-', l_plist);
159: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
162: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
155:
156: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
157: wf_event.AddParameterToList( 'DISPLAYNAME', '-', l_plist);
158: wf_event.AddParameterToList( 'DESCRIPTION', '-', l_plist);
159: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
162: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
163: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
156: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
157: wf_event.AddParameterToList( 'DISPLAYNAME', '-', l_plist);
158: wf_event.AddParameterToList( 'DESCRIPTION', '-', l_plist);
159: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
162: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
163: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
164: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
157: wf_event.AddParameterToList( 'DISPLAYNAME', '-', l_plist);
158: wf_event.AddParameterToList( 'DESCRIPTION', '-', l_plist);
159: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
162: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
163: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
164: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
165: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
158: wf_event.AddParameterToList( 'DESCRIPTION', '-', l_plist);
159: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
162: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
163: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
164: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
165: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
166:
159: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
162: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
163: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
164: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
165: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
166:
167: WF_LOCAL_SYNCH.propagate_role(
160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
162: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
163: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
164: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
165: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
166:
167: WF_LOCAL_SYNCH.propagate_role(
168: p_orig_system => 'POS',
161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
162: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
163: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
164: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
165: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
166:
167: WF_LOCAL_SYNCH.propagate_role(
168: p_orig_system => 'POS',
169: p_orig_system_id => l_position_id,
179: exception when others then
180: null;
181: end;
182:
183: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
184: wf_event.AddParameterToList( 'DISPLAYNAME', l_name, l_plist);
185: wf_event.AddParameterToList( 'DESCRIPTION', l_name, l_plist);
186: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
180: null;
181: end;
182:
183: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
184: wf_event.AddParameterToList( 'DISPLAYNAME', l_name, l_plist);
185: wf_event.AddParameterToList( 'DESCRIPTION', l_name, l_plist);
186: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
181: end;
182:
183: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
184: wf_event.AddParameterToList( 'DISPLAYNAME', l_name, l_plist);
185: wf_event.AddParameterToList( 'DESCRIPTION', l_name, l_plist);
186: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
189: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
182:
183: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
184: wf_event.AddParameterToList( 'DISPLAYNAME', l_name, l_plist);
185: wf_event.AddParameterToList( 'DESCRIPTION', l_name, l_plist);
186: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
189: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
190: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
183: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
184: wf_event.AddParameterToList( 'DISPLAYNAME', l_name, l_plist);
185: wf_event.AddParameterToList( 'DESCRIPTION', l_name, l_plist);
186: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
189: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
190: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
191: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
184: wf_event.AddParameterToList( 'DISPLAYNAME', l_name, l_plist);
185: wf_event.AddParameterToList( 'DESCRIPTION', l_name, l_plist);
186: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
189: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
190: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
191: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
192: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
185: wf_event.AddParameterToList( 'DESCRIPTION', l_name, l_plist);
186: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
189: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
190: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
191: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
192: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
193:
186: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',l_plist);
187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
189: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
190: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
191: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
192: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
193:
194: if g_debug then
187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,l_plist);
188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
189: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
190: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
191: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
192: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
193:
194: if g_debug then
195: hr_utility.set_location('l_start_date is '||l_start_date, 20);
188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', l_plist);
189: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', l_plist);
190: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
191: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
192: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
193:
194: if g_debug then
195: hr_utility.set_location('l_start_date is '||l_start_date, 20);
196: end if;