APPS.PER_QH_SUMMARY_UPDATE dependencies on HR_API

Line 126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

122: or p_chk1_date_due is not null
123: or p_chk1_date_done is not null
124: or p_chk1_notes is not null)) or
125: (l_checklist_item_id is not null and
126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
127: <> nvl(p_chk1_date_due,hr_api.g_date)
128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 127: <> nvl(p_chk1_date_due,hr_api.g_date)

123: or p_chk1_date_done is not null
124: or p_chk1_notes is not null)) or
125: (l_checklist_item_id is not null and
126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
127: <> nvl(p_chk1_date_due,hr_api.g_date)
128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)

Line 128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

124: or p_chk1_notes is not null)) or
125: (l_checklist_item_id is not null and
126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
127: <> nvl(p_chk1_date_due,hr_api.g_date)
128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 129: <> nvl(p_chk1_date_done,hr_api.g_date)

125: (l_checklist_item_id is not null and
126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
127: <> nvl(p_chk1_date_due,hr_api.g_date)
128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then

Line 130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

126: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
127: <> nvl(p_chk1_date_due,hr_api.g_date)
128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then
134: --

Line 131: <> nvl(p_chk1_status,hr_api.g_varchar2)

127: <> nvl(p_chk1_date_due,hr_api.g_date)
128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then
134: --
135: hr_utility.set_location(l_proc, 30);

Line 132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

128: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then
134: --
135: hr_utility.set_location(l_proc, 30);
136: --

Line 133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then

129: <> nvl(p_chk1_date_done,hr_api.g_date)
130: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then
134: --
135: hr_utility.set_location(l_proc, 30);
136: --
137: per_checklist_items_api.cre_or_upd_checklist_items

Line 164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

160: or p_chk2_date_due is not null
161: or p_chk2_date_done is not null
162: or p_chk2_notes is not null)) or
163: (l_checklist_item_id is not null and
164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
165: <> nvl(p_chk2_date_due,hr_api.g_date)
166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 165: <> nvl(p_chk2_date_due,hr_api.g_date)

161: or p_chk2_date_done is not null
162: or p_chk2_notes is not null)) or
163: (l_checklist_item_id is not null and
164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
165: <> nvl(p_chk2_date_due,hr_api.g_date)
166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)

Line 166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

162: or p_chk2_notes is not null)) or
163: (l_checklist_item_id is not null and
164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
165: <> nvl(p_chk2_date_due,hr_api.g_date)
166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 167: <> nvl(p_chk2_date_done,hr_api.g_date)

163: (l_checklist_item_id is not null and
164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
165: <> nvl(p_chk2_date_due,hr_api.g_date)
166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then

Line 168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

164: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
165: <> nvl(p_chk2_date_due,hr_api.g_date)
166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then
172: --

Line 169: <> nvl(p_chk2_status,hr_api.g_varchar2)

165: <> nvl(p_chk2_date_due,hr_api.g_date)
166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then
172: --
173: hr_utility.set_location(l_proc, 50);

Line 170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

166: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then
172: --
173: hr_utility.set_location(l_proc, 50);
174: --

Line 171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then

167: <> nvl(p_chk2_date_done,hr_api.g_date)
168: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then
172: --
173: hr_utility.set_location(l_proc, 50);
174: --
175: per_checklist_items_api.cre_or_upd_checklist_items

Line 202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

198: or p_chk3_date_due is not null
199: or p_chk3_date_done is not null
200: or p_chk3_notes is not null)) or
201: (l_checklist_item_id is not null and
202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
203: <> nvl(p_chk3_date_due,hr_api.g_date)
204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 203: <> nvl(p_chk3_date_due,hr_api.g_date)

199: or p_chk3_date_done is not null
200: or p_chk3_notes is not null)) or
201: (l_checklist_item_id is not null and
202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
203: <> nvl(p_chk3_date_due,hr_api.g_date)
204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)

Line 204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

200: or p_chk3_notes is not null)) or
201: (l_checklist_item_id is not null and
202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
203: <> nvl(p_chk3_date_due,hr_api.g_date)
204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 205: <> nvl(p_chk3_date_done,hr_api.g_date)

201: (l_checklist_item_id is not null and
202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
203: <> nvl(p_chk3_date_due,hr_api.g_date)
204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then

Line 206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

202: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
203: <> nvl(p_chk3_date_due,hr_api.g_date)
204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then
210: --

Line 207: <> nvl(p_chk3_status,hr_api.g_varchar2)

203: <> nvl(p_chk3_date_due,hr_api.g_date)
204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then
210: --
211: hr_utility.set_location(l_proc, 70);

Line 208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

204: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then
210: --
211: hr_utility.set_location(l_proc, 70);
212: --

Line 209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then

205: <> nvl(p_chk3_date_done,hr_api.g_date)
206: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then
210: --
211: hr_utility.set_location(l_proc, 70);
212: --
213: per_checklist_items_api.cre_or_upd_checklist_items

Line 240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

236: or p_chk4_date_due is not null
237: or p_chk4_date_done is not null
238: or p_chk4_notes is not null)) or
239: (l_checklist_item_id is not null and
240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
241: <> nvl(p_chk4_date_due,hr_api.g_date)
242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 241: <> nvl(p_chk4_date_due,hr_api.g_date)

237: or p_chk4_date_done is not null
238: or p_chk4_notes is not null)) or
239: (l_checklist_item_id is not null and
240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
241: <> nvl(p_chk4_date_due,hr_api.g_date)
242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)

Line 242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

238: or p_chk4_notes is not null)) or
239: (l_checklist_item_id is not null and
240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
241: <> nvl(p_chk4_date_due,hr_api.g_date)
242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 243: <> nvl(p_chk4_date_done,hr_api.g_date)

239: (l_checklist_item_id is not null and
240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
241: <> nvl(p_chk4_date_due,hr_api.g_date)
242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then

Line 244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

240: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
241: <> nvl(p_chk4_date_due,hr_api.g_date)
242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then
248: --

Line 245: <> nvl(p_chk4_status,hr_api.g_varchar2)

241: <> nvl(p_chk4_date_due,hr_api.g_date)
242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then
248: --
249: hr_utility.set_location(l_proc, 90);

Line 246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

242: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then
248: --
249: hr_utility.set_location(l_proc, 90);
250: --

Line 247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then

243: <> nvl(p_chk4_date_done,hr_api.g_date)
244: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then
248: --
249: hr_utility.set_location(l_proc, 90);
250: --
251: per_checklist_items_api.cre_or_upd_checklist_items

Line 278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

274: or p_chk5_date_due is not null
275: or p_chk5_date_done is not null
276: or p_chk5_notes is not null)) or
277: (l_checklist_item_id is not null and
278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
279: <> nvl(p_chk5_date_due,hr_api.g_date)
280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 279: <> nvl(p_chk5_date_due,hr_api.g_date)

275: or p_chk5_date_done is not null
276: or p_chk5_notes is not null)) or
277: (l_checklist_item_id is not null and
278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
279: <> nvl(p_chk5_date_due,hr_api.g_date)
280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)

Line 280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

276: or p_chk5_notes is not null)) or
277: (l_checklist_item_id is not null and
278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
279: <> nvl(p_chk5_date_due,hr_api.g_date)
280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 281: <> nvl(p_chk5_date_done,hr_api.g_date)

277: (l_checklist_item_id is not null and
278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
279: <> nvl(p_chk5_date_due,hr_api.g_date)
280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then

Line 282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

278: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
279: <> nvl(p_chk5_date_due,hr_api.g_date)
280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then
286: --

Line 283: <> nvl(p_chk5_status,hr_api.g_varchar2)

279: <> nvl(p_chk5_date_due,hr_api.g_date)
280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then
286: --
287: hr_utility.set_location(l_proc, 110);

Line 284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

280: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then
286: --
287: hr_utility.set_location(l_proc, 110);
288: --

Line 285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then

281: <> nvl(p_chk5_date_done,hr_api.g_date)
282: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then
286: --
287: hr_utility.set_location(l_proc, 110);
288: --
289: per_checklist_items_api.cre_or_upd_checklist_items

Line 316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

312: or p_chk6_date_due is not null
313: or p_chk6_date_done is not null
314: or p_chk6_notes is not null)) or
315: (l_checklist_item_id is not null and
316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
317: <> nvl(p_chk6_date_due,hr_api.g_date)
318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 317: <> nvl(p_chk6_date_due,hr_api.g_date)

313: or p_chk6_date_done is not null
314: or p_chk6_notes is not null)) or
315: (l_checklist_item_id is not null and
316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
317: <> nvl(p_chk6_date_due,hr_api.g_date)
318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)

Line 318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

314: or p_chk6_notes is not null)) or
315: (l_checklist_item_id is not null and
316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
317: <> nvl(p_chk6_date_due,hr_api.g_date)
318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 319: <> nvl(p_chk6_date_done,hr_api.g_date)

315: (l_checklist_item_id is not null and
316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
317: <> nvl(p_chk6_date_due,hr_api.g_date)
318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then

Line 320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

316: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
317: <> nvl(p_chk6_date_due,hr_api.g_date)
318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then
324: --

Line 321: <> nvl(p_chk6_status,hr_api.g_varchar2)

317: <> nvl(p_chk6_date_due,hr_api.g_date)
318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then
324: --
325: hr_utility.set_location(l_proc, 130);

Line 322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

318: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then
324: --
325: hr_utility.set_location(l_proc, 130);
326: --

Line 323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then

319: <> nvl(p_chk6_date_done,hr_api.g_date)
320: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then
324: --
325: hr_utility.set_location(l_proc, 130);
326: --
327: per_checklist_items_api.cre_or_upd_checklist_items

Line 354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

350: or p_chk7_date_due is not null
351: or p_chk7_date_done is not null
352: or p_chk7_notes is not null)) or
353: (l_checklist_item_id is not null and
354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
355: <> nvl(p_chk7_date_due,hr_api.g_date)
356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 355: <> nvl(p_chk7_date_due,hr_api.g_date)

351: or p_chk7_date_done is not null
352: or p_chk7_notes is not null)) or
353: (l_checklist_item_id is not null and
354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
355: <> nvl(p_chk7_date_due,hr_api.g_date)
356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)

Line 356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

352: or p_chk7_notes is not null)) or
353: (l_checklist_item_id is not null and
354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
355: <> nvl(p_chk7_date_due,hr_api.g_date)
356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 357: <> nvl(p_chk7_date_done,hr_api.g_date)

353: (l_checklist_item_id is not null and
354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
355: <> nvl(p_chk7_date_due,hr_api.g_date)
356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then

Line 358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

354: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
355: <> nvl(p_chk7_date_due,hr_api.g_date)
356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then
362: --

Line 359: <> nvl(p_chk7_status,hr_api.g_varchar2)

355: <> nvl(p_chk7_date_due,hr_api.g_date)
356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then
362: --
363: hr_utility.set_location(l_proc, 150);

Line 360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

356: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then
362: --
363: hr_utility.set_location(l_proc, 150);
364: --

Line 361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then

357: <> nvl(p_chk7_date_done,hr_api.g_date)
358: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then
362: --
363: hr_utility.set_location(l_proc, 150);
364: --
365: per_checklist_items_api.cre_or_upd_checklist_items

Line 392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

388: or p_chk8_date_due is not null
389: or p_chk8_date_done is not null
390: or p_chk8_notes is not null)) or
391: (l_checklist_item_id is not null and
392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
393: <> nvl(p_chk8_date_due,hr_api.g_date)
394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 393: <> nvl(p_chk8_date_due,hr_api.g_date)

389: or p_chk8_date_done is not null
390: or p_chk8_notes is not null)) or
391: (l_checklist_item_id is not null and
392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
393: <> nvl(p_chk8_date_due,hr_api.g_date)
394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)

Line 394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

390: or p_chk8_notes is not null)) or
391: (l_checklist_item_id is not null and
392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
393: <> nvl(p_chk8_date_due,hr_api.g_date)
394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 395: <> nvl(p_chk8_date_done,hr_api.g_date)

391: (l_checklist_item_id is not null and
392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
393: <> nvl(p_chk8_date_due,hr_api.g_date)
394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then

Line 396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

392: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
393: <> nvl(p_chk8_date_due,hr_api.g_date)
394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then
400: --

Line 397: <> nvl(p_chk8_status,hr_api.g_varchar2)

393: <> nvl(p_chk8_date_due,hr_api.g_date)
394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then
400: --
401: hr_utility.set_location(l_proc, 170);

Line 398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

394: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then
400: --
401: hr_utility.set_location(l_proc, 170);
402: --

Line 399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then

395: <> nvl(p_chk8_date_done,hr_api.g_date)
396: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then
400: --
401: hr_utility.set_location(l_proc, 170);
402: --
403: per_checklist_items_api.cre_or_upd_checklist_items

Line 430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

426: or p_chk9_date_due is not null
427: or p_chk9_date_done is not null
428: or p_chk9_notes is not null)) or
429: (l_checklist_item_id is not null and
430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
431: <> nvl(p_chk9_date_due,hr_api.g_date)
432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 431: <> nvl(p_chk9_date_due,hr_api.g_date)

427: or p_chk9_date_done is not null
428: or p_chk9_notes is not null)) or
429: (l_checklist_item_id is not null and
430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
431: <> nvl(p_chk9_date_due,hr_api.g_date)
432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)

Line 432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

428: or p_chk9_notes is not null)) or
429: (l_checklist_item_id is not null and
430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
431: <> nvl(p_chk9_date_due,hr_api.g_date)
432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 433: <> nvl(p_chk9_date_done,hr_api.g_date)

429: (l_checklist_item_id is not null and
430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
431: <> nvl(p_chk9_date_due,hr_api.g_date)
432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then

Line 434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

430: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
431: <> nvl(p_chk9_date_due,hr_api.g_date)
432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then
438: --

Line 435: <> nvl(p_chk9_status,hr_api.g_varchar2)

431: <> nvl(p_chk9_date_due,hr_api.g_date)
432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then
438: --
439: hr_utility.set_location(l_proc, 190);

Line 436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

432: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then
438: --
439: hr_utility.set_location(l_proc, 190);
440: --

Line 437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then

433: <> nvl(p_chk9_date_done,hr_api.g_date)
434: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then
438: --
439: hr_utility.set_location(l_proc, 190);
440: --
441: per_checklist_items_api.cre_or_upd_checklist_items

Line 468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)

464: or p_chk10_date_due is not null
465: or p_chk10_date_done is not null
466: or p_chk10_notes is not null)) or
467: (l_checklist_item_id is not null and
468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
469: <> nvl(p_chk10_date_due,hr_api.g_date)
470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

Line 469: <> nvl(p_chk10_date_due,hr_api.g_date)

465: or p_chk10_date_done is not null
466: or p_chk10_notes is not null)) or
467: (l_checklist_item_id is not null and
468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
469: <> nvl(p_chk10_date_due,hr_api.g_date)
470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)

Line 470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)

466: or p_chk10_notes is not null)) or
467: (l_checklist_item_id is not null and
468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
469: <> nvl(p_chk10_date_due,hr_api.g_date)
470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

Line 471: <> nvl(p_chk10_date_done,hr_api.g_date)

467: (l_checklist_item_id is not null and
468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
469: <> nvl(p_chk10_date_due,hr_api.g_date)
470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then

Line 472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

468: ( nvl(per_chk_shd.g_old_rec.date_due,hr_api.g_date)
469: <> nvl(p_chk10_date_due,hr_api.g_date)
470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then
476: --

Line 473: <> nvl(p_chk10_status,hr_api.g_varchar2)

469: <> nvl(p_chk10_date_due,hr_api.g_date)
470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then
476: --
477: hr_utility.set_location(l_proc, 210);

Line 474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)

470: or nvl(per_chk_shd.g_old_rec.date_done,hr_api.g_date)
471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then
476: --
477: hr_utility.set_location(l_proc, 210);
478: --

Line 475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then

471: <> nvl(p_chk10_date_done,hr_api.g_date)
472: or nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then
476: --
477: hr_utility.set_location(l_proc, 210);
478: --
479: per_checklist_items_api.cre_or_upd_checklist_items