96: l_ovn number := p_object_version_number;
97:
98: begin
99:
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101:
102: --
103: -- Pipe the main IN / IN OUT parameters for ease of debugging.
104: --
101:
102: --
103: -- Pipe the main IN / IN OUT parameters for ease of debugging.
104: --
105: hr_utility.trace(' ');
106: hr_utility.trace(' --------------------------------'||
107: '---------------------------------');
108: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
109: ' VALUE');
102: --
103: -- Pipe the main IN / IN OUT parameters for ease of debugging.
104: --
105: hr_utility.trace(' ');
106: hr_utility.trace(' --------------------------------'||
107: '---------------------------------');
108: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
109: ' VALUE');
110: hr_utility.trace(' --------------------------------'||
104: --
105: hr_utility.trace(' ');
106: hr_utility.trace(' --------------------------------'||
107: '---------------------------------');
108: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
109: ' VALUE');
110: hr_utility.trace(' --------------------------------'||
111: '+--------------------------------');
112: hr_utility.trace(' p_effective_date '||
106: hr_utility.trace(' --------------------------------'||
107: '---------------------------------');
108: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
109: ' VALUE');
110: hr_utility.trace(' --------------------------------'||
111: '+--------------------------------');
112: hr_utility.trace(' p_effective_date '||
113: to_char(p_effective_date));
114: hr_utility.trace(' p_object_version_number '||
108: hr_utility.trace(' IN / IN OUT NOCOPY PARAMETER '||
109: ' VALUE');
110: hr_utility.trace(' --------------------------------'||
111: '+--------------------------------');
112: hr_utility.trace(' p_effective_date '||
113: to_char(p_effective_date));
114: hr_utility.trace(' p_object_version_number '||
115: to_char(p_object_version_number));
116: hr_utility.trace(' p_person_id '||
110: hr_utility.trace(' --------------------------------'||
111: '+--------------------------------');
112: hr_utility.trace(' p_effective_date '||
113: to_char(p_effective_date));
114: hr_utility.trace(' p_object_version_number '||
115: to_char(p_object_version_number));
116: hr_utility.trace(' p_person_id '||
117: to_char(p_person_id));
118: hr_utility.trace(' p_date_start '||
112: hr_utility.trace(' p_effective_date '||
113: to_char(p_effective_date));
114: hr_utility.trace(' p_object_version_number '||
115: to_char(p_object_version_number));
116: hr_utility.trace(' p_person_id '||
117: to_char(p_person_id));
118: hr_utility.trace(' p_date_start '||
119: to_char(p_date_start));
120: hr_utility.trace(' p_termination_reason '||
114: hr_utility.trace(' p_object_version_number '||
115: to_char(p_object_version_number));
116: hr_utility.trace(' p_person_id '||
117: to_char(p_person_id));
118: hr_utility.trace(' p_date_start '||
119: to_char(p_date_start));
120: hr_utility.trace(' p_termination_reason '||
121: p_termination_reason);
122: hr_utility.trace(' --------------------------------'||
116: hr_utility.trace(' p_person_id '||
117: to_char(p_person_id));
118: hr_utility.trace(' p_date_start '||
119: to_char(p_date_start));
120: hr_utility.trace(' p_termination_reason '||
121: p_termination_reason);
122: hr_utility.trace(' --------------------------------'||
123: '---------------------------------');
124: hr_utility.trace(' ');
118: hr_utility.trace(' p_date_start '||
119: to_char(p_date_start));
120: hr_utility.trace(' p_termination_reason '||
121: p_termination_reason);
122: hr_utility.trace(' --------------------------------'||
123: '---------------------------------');
124: hr_utility.trace(' ');
125:
126: --
120: hr_utility.trace(' p_termination_reason '||
121: p_termination_reason);
122: hr_utility.trace(' --------------------------------'||
123: '---------------------------------');
124: hr_utility.trace(' ');
125:
126: --
127: -- Create a savepoint.
128: --
219: ,p_hook_type => 'BP'
220: );
221: end;
222:
223: hr_utility.set_location(l_proc, 30);
224: --
225: -- Update Period of Placement
226: --
227: per_pdp_upd.upd
299: -- Assign the out parameters
300: --
301: p_object_version_number := l_object_version_number;
302:
303: hr_utility.set_location(l_proc, 40);
304:
305: --
306: -- Call After Process User Hook
307: --
393:
394: --
395: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
396: --
397: hr_utility.trace(' ');
398: hr_utility.trace(' --------------------------------'||
399: '---------------------------------');
400: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
401: ' VALUE');
394: --
395: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
396: --
397: hr_utility.trace(' ');
398: hr_utility.trace(' --------------------------------'||
399: '---------------------------------');
400: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
401: ' VALUE');
402: hr_utility.trace(' --------------------------------'||
396: --
397: hr_utility.trace(' ');
398: hr_utility.trace(' --------------------------------'||
399: '---------------------------------');
400: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
401: ' VALUE');
402: hr_utility.trace(' --------------------------------'||
403: '+--------------------------------');
404: hr_utility.trace(' p_object_version_number '||
398: hr_utility.trace(' --------------------------------'||
399: '---------------------------------');
400: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
401: ' VALUE');
402: hr_utility.trace(' --------------------------------'||
403: '+--------------------------------');
404: hr_utility.trace(' p_object_version_number '||
405: to_char(p_object_version_number));
406: hr_utility.trace(' --------------------------------'||
400: hr_utility.trace(' IN OUT NOCOPY / OUT NOCOPY PARAMETER '||
401: ' VALUE');
402: hr_utility.trace(' --------------------------------'||
403: '+--------------------------------');
404: hr_utility.trace(' p_object_version_number '||
405: to_char(p_object_version_number));
406: hr_utility.trace(' --------------------------------'||
407: '---------------------------------');
408: hr_utility.trace(' ');
402: hr_utility.trace(' --------------------------------'||
403: '+--------------------------------');
404: hr_utility.trace(' p_object_version_number '||
405: to_char(p_object_version_number));
406: hr_utility.trace(' --------------------------------'||
407: '---------------------------------');
408: hr_utility.trace(' ');
409:
410: hr_utility.set_location(' Leaving:'||l_proc, 70);
404: hr_utility.trace(' p_object_version_number '||
405: to_char(p_object_version_number));
406: hr_utility.trace(' --------------------------------'||
407: '---------------------------------');
408: hr_utility.trace(' ');
409:
410: hr_utility.set_location(' Leaving:'||l_proc, 70);
411:
412: exception
406: hr_utility.trace(' --------------------------------'||
407: '---------------------------------');
408: hr_utility.trace(' ');
409:
410: hr_utility.set_location(' Leaving:'||l_proc, 70);
411:
412: exception
413: when hr_api.validate_enabled then
414: --
421: -- (Any key or derived arguments must be set to null
422: -- when validation only mode is being used.)
423: --
424: p_object_version_number := null;
425: hr_utility.set_location(l_proc, 80);
426: when others then
427: --
428: -- A validation or unexpected error has occured
429: --
431: --
432: -- set in out parameters and set out parameters
433: --
434: p_object_version_number := l_ovn;
435: hr_utility.set_location(' Leaving:'||l_proc, 90);
436: raise;
437: end update_pdp_details;
438: --
439: --