DBA Data[Home] [Help]

APPS.HR_PSF_SHD dependencies on WF_EVENT

Line 156: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);

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

Line 157: wf_event.AddParameterToList( 'DISPLAYNAME', '-', 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);

Line 158: wf_event.AddParameterToList( 'DESCRIPTION', '-', 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);

Line 159: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',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);

Line 160: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,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);

Line 161: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', 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);

Line 162: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', 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:

Line 163: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), 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:
167: WF_LOCAL_SYNCH.propagate_role(

Line 164: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',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(
168: p_orig_system => 'POS',

Line 165: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', 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',
169: p_orig_system_id => l_position_id,

Line 183: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);

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

Line 184: wf_event.AddParameterToList( 'DISPLAYNAME', l_name, 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);

Line 185: wf_event.AddParameterToList( 'DESCRIPTION', l_name, 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);

Line 186: wf_event.AddParameterToList( 'orclWFOrigSystem','POS',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);

Line 187: wf_event.AddParameterToList( 'orclWFOrigSystemID',l_position_id,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);

Line 188: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', 'QUERY', 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);

Line 189: wf_event.AddParameterToList( 'orclIsEnabled', 'ACTIVE', 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:

Line 190: wf_event.AddParameterToList( 'ExpirationDate',to_char(l_expiration_date,wf_engine.date_format), 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:
194: if g_debug then

Line 191: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',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
195: hr_utility.set_location('l_start_date is '||l_start_date, 20);

Line 192: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', 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);
196: end if;