39: l_effective_start_date date;
40: l_effective_end_date date;
41: --
42: begin
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Issue a savepoint
46: --
47: savepoint create_user_row;
144: --
145: ----For MLS---------------------------------------------------------------------
146: pay_urt_ins.ins_tl(userenv('lang'), p_user_row_id, p_row_low_range_or_name);
147: --------------------------------------------------------------------------------
148: hr_utility.set_location(' Leaving:'||l_proc, 70);
149: exception
150: when hr_api.validate_enabled then
151: --
152: -- As the Validate_Enabled exception has been raised
163: p_object_version_number := null ;
164: p_effective_start_date := null ;
165: p_effective_end_date := null ;
166:
167: hr_utility.set_location(' Leaving:'||l_proc, 80);
168: when others then
169: --
170: -- A validation or unexpected error has occured
171: --
179: p_object_version_number := null ;
180: p_effective_start_date := null ;
181: p_effective_end_date := null ;
182:
183: hr_utility.set_location(' Leaving:'||l_proc, 90);
184: raise;
185: end create_user_row;
186:
187: /* Since we added a parameter in create_user_row for bug fix 6735596
256: l_effective_start_date date;
257: l_effective_end_date date;
258: --
259: begin
260: hr_utility.set_location('Entering:'|| l_proc, 10);
261: --
262: -- Issue a savepoint
263: --
264: savepoint update_user_row;
360: --
361: ----For MLS---------------------------------------------------------------------
362: pay_urt_upd.upd_tl(userenv('lang'), p_user_row_id, p_row_low_range_or_name);
363: --------------------------------------------------------------------------------
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365: exception
366: when hr_api.validate_enabled then
367: --
368: -- As the Validate_Enabled exception has been raised
378: p_object_version_number := l_in_out_parameter2;
379: p_effective_start_date := null ;
380: p_effective_end_date := null ;
381:
382: hr_utility.set_location(' Leaving:'||l_proc, 80);
383: when others then
384: --
385: -- A validation or unexpected error has occured
386: --
393: p_object_version_number := l_in_out_parameter2;
394: p_effective_start_date := null ;
395: p_effective_end_date := null ;
396:
397: hr_utility.set_location(' Leaving:'||l_proc, 90);
398: raise;
399: end update_user_row;
400: --
401: -- ----------------------------------------------------------------------------
422: l_effective_start_date date;
423: l_effective_end_date date;
424: --
425: begin
426: hr_utility.set_location('Entering:'|| l_proc, 10);
427: --
428: -- Issue a savepoint
429: --
430: savepoint delete_user_row;
507: if (UPPER(p_datetrack_update_mode) = 'ZAP') then
508: pay_urt_del.del_tl(p_user_row_id);
509: end if;
510: --------------------------------------------------------------------------------
511: hr_utility.set_location(' Leaving:'||l_proc, 70);
512: exception
513: when hr_api.validate_enabled then
514: --
515: -- As the Validate_Enabled exception has been raised
524: p_object_version_number := l_in_out_parameter;
525: p_effective_start_date := null ;
526: p_effective_end_date := null ;
527:
528: hr_utility.set_location(' Leaving:'||l_proc, 80);
529: when others then
530: --
531: -- A validation or unexpected error has occured
532: --
538: p_object_version_number := l_in_out_parameter;
539: p_effective_start_date := null ;
540: p_effective_end_date := null ;
541:
542: hr_utility.set_location(' Leaving:'||l_proc, 90);
543: raise;
544: end delete_user_row;
545: --
546: