[Home] [Help]
15: ,p_effective_date in date
16: ,p_attribute_update_mode in varchar2
17: ,p_assignment_id in number
18: ,p_object_version_number in out nocopy number
19: ,p_supervisor_id in number default hr_api.g_number
20: ,p_supervisor_assignment_id in number default hr_api.g_number
21: ,p_assignment_number in varchar2 default hr_api.g_varchar2
22: ,p_change_reason in varchar2 default hr_api.g_varchar2
23: ,p_comments in varchar2 default hr_api.g_varchar2
16: ,p_attribute_update_mode in varchar2
17: ,p_assignment_id in number
18: ,p_object_version_number in out nocopy number
19: ,p_supervisor_id in number default hr_api.g_number
20: ,p_supervisor_assignment_id in number default hr_api.g_number
21: ,p_assignment_number in varchar2 default hr_api.g_varchar2
22: ,p_change_reason in varchar2 default hr_api.g_varchar2
23: ,p_comments in varchar2 default hr_api.g_varchar2
24: ,p_date_probation_end in date default hr_api.g_date
17: ,p_assignment_id in number
18: ,p_object_version_number in out nocopy number
19: ,p_supervisor_id in number default hr_api.g_number
20: ,p_supervisor_assignment_id in number default hr_api.g_number
21: ,p_assignment_number in varchar2 default hr_api.g_varchar2
22: ,p_change_reason in varchar2 default hr_api.g_varchar2
23: ,p_comments in varchar2 default hr_api.g_varchar2
24: ,p_date_probation_end in date default hr_api.g_date
25: ,p_default_code_comb_id in number default hr_api.g_number
18: ,p_object_version_number in out nocopy number
19: ,p_supervisor_id in number default hr_api.g_number
20: ,p_supervisor_assignment_id in number default hr_api.g_number
21: ,p_assignment_number in varchar2 default hr_api.g_varchar2
22: ,p_change_reason in varchar2 default hr_api.g_varchar2
23: ,p_comments in varchar2 default hr_api.g_varchar2
24: ,p_date_probation_end in date default hr_api.g_date
25: ,p_default_code_comb_id in number default hr_api.g_number
26: ,p_frequency in varchar2 default hr_api.g_varchar2
19: ,p_supervisor_id in number default hr_api.g_number
20: ,p_supervisor_assignment_id in number default hr_api.g_number
21: ,p_assignment_number in varchar2 default hr_api.g_varchar2
22: ,p_change_reason in varchar2 default hr_api.g_varchar2
23: ,p_comments in varchar2 default hr_api.g_varchar2
24: ,p_date_probation_end in date default hr_api.g_date
25: ,p_default_code_comb_id in number default hr_api.g_number
26: ,p_frequency in varchar2 default hr_api.g_varchar2
27: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
20: ,p_supervisor_assignment_id in number default hr_api.g_number
21: ,p_assignment_number in varchar2 default hr_api.g_varchar2
22: ,p_change_reason in varchar2 default hr_api.g_varchar2
23: ,p_comments in varchar2 default hr_api.g_varchar2
24: ,p_date_probation_end in date default hr_api.g_date
25: ,p_default_code_comb_id in number default hr_api.g_number
26: ,p_frequency in varchar2 default hr_api.g_varchar2
27: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
28: ,p_manager_flag in varchar2 default hr_api.g_varchar2
21: ,p_assignment_number in varchar2 default hr_api.g_varchar2
22: ,p_change_reason in varchar2 default hr_api.g_varchar2
23: ,p_comments in varchar2 default hr_api.g_varchar2
24: ,p_date_probation_end in date default hr_api.g_date
25: ,p_default_code_comb_id in number default hr_api.g_number
26: ,p_frequency in varchar2 default hr_api.g_varchar2
27: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
28: ,p_manager_flag in varchar2 default hr_api.g_varchar2
29: ,p_normal_hours in number default hr_api.g_number
22: ,p_change_reason in varchar2 default hr_api.g_varchar2
23: ,p_comments in varchar2 default hr_api.g_varchar2
24: ,p_date_probation_end in date default hr_api.g_date
25: ,p_default_code_comb_id in number default hr_api.g_number
26: ,p_frequency in varchar2 default hr_api.g_varchar2
27: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
28: ,p_manager_flag in varchar2 default hr_api.g_varchar2
29: ,p_normal_hours in number default hr_api.g_number
30: ,p_perf_review_period in number default hr_api.g_number
23: ,p_comments in varchar2 default hr_api.g_varchar2
24: ,p_date_probation_end in date default hr_api.g_date
25: ,p_default_code_comb_id in number default hr_api.g_number
26: ,p_frequency in varchar2 default hr_api.g_varchar2
27: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
28: ,p_manager_flag in varchar2 default hr_api.g_varchar2
29: ,p_normal_hours in number default hr_api.g_number
30: ,p_perf_review_period in number default hr_api.g_number
31: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
24: ,p_date_probation_end in date default hr_api.g_date
25: ,p_default_code_comb_id in number default hr_api.g_number
26: ,p_frequency in varchar2 default hr_api.g_varchar2
27: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
28: ,p_manager_flag in varchar2 default hr_api.g_varchar2
29: ,p_normal_hours in number default hr_api.g_number
30: ,p_perf_review_period in number default hr_api.g_number
31: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
32: ,p_probation_period in number default hr_api.g_number
25: ,p_default_code_comb_id in number default hr_api.g_number
26: ,p_frequency in varchar2 default hr_api.g_varchar2
27: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
28: ,p_manager_flag in varchar2 default hr_api.g_varchar2
29: ,p_normal_hours in number default hr_api.g_number
30: ,p_perf_review_period in number default hr_api.g_number
31: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
32: ,p_probation_period in number default hr_api.g_number
33: ,p_probation_unit in varchar2 default hr_api.g_varchar2
26: ,p_frequency in varchar2 default hr_api.g_varchar2
27: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
28: ,p_manager_flag in varchar2 default hr_api.g_varchar2
29: ,p_normal_hours in number default hr_api.g_number
30: ,p_perf_review_period in number default hr_api.g_number
31: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
32: ,p_probation_period in number default hr_api.g_number
33: ,p_probation_unit in varchar2 default hr_api.g_varchar2
34: ,p_sal_review_period in number default hr_api.g_number
27: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
28: ,p_manager_flag in varchar2 default hr_api.g_varchar2
29: ,p_normal_hours in number default hr_api.g_number
30: ,p_perf_review_period in number default hr_api.g_number
31: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
32: ,p_probation_period in number default hr_api.g_number
33: ,p_probation_unit in varchar2 default hr_api.g_varchar2
34: ,p_sal_review_period in number default hr_api.g_number
35: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
28: ,p_manager_flag in varchar2 default hr_api.g_varchar2
29: ,p_normal_hours in number default hr_api.g_number
30: ,p_perf_review_period in number default hr_api.g_number
31: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
32: ,p_probation_period in number default hr_api.g_number
33: ,p_probation_unit in varchar2 default hr_api.g_varchar2
34: ,p_sal_review_period in number default hr_api.g_number
35: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
36: ,p_set_of_books_id in number default hr_api.g_number
29: ,p_normal_hours in number default hr_api.g_number
30: ,p_perf_review_period in number default hr_api.g_number
31: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
32: ,p_probation_period in number default hr_api.g_number
33: ,p_probation_unit in varchar2 default hr_api.g_varchar2
34: ,p_sal_review_period in number default hr_api.g_number
35: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
36: ,p_set_of_books_id in number default hr_api.g_number
37: ,p_source_type in varchar2 default hr_api.g_varchar2
30: ,p_perf_review_period in number default hr_api.g_number
31: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
32: ,p_probation_period in number default hr_api.g_number
33: ,p_probation_unit in varchar2 default hr_api.g_varchar2
34: ,p_sal_review_period in number default hr_api.g_number
35: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
36: ,p_set_of_books_id in number default hr_api.g_number
37: ,p_source_type in varchar2 default hr_api.g_varchar2
38: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
31: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
32: ,p_probation_period in number default hr_api.g_number
33: ,p_probation_unit in varchar2 default hr_api.g_varchar2
34: ,p_sal_review_period in number default hr_api.g_number
35: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
36: ,p_set_of_books_id in number default hr_api.g_number
37: ,p_source_type in varchar2 default hr_api.g_varchar2
38: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
39: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
32: ,p_probation_period in number default hr_api.g_number
33: ,p_probation_unit in varchar2 default hr_api.g_varchar2
34: ,p_sal_review_period in number default hr_api.g_number
35: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
36: ,p_set_of_books_id in number default hr_api.g_number
37: ,p_source_type in varchar2 default hr_api.g_varchar2
38: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
39: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
40: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
33: ,p_probation_unit in varchar2 default hr_api.g_varchar2
34: ,p_sal_review_period in number default hr_api.g_number
35: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
36: ,p_set_of_books_id in number default hr_api.g_number
37: ,p_source_type in varchar2 default hr_api.g_varchar2
38: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
39: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
40: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
41: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
34: ,p_sal_review_period in number default hr_api.g_number
35: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
36: ,p_set_of_books_id in number default hr_api.g_number
37: ,p_source_type in varchar2 default hr_api.g_varchar2
38: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
39: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
40: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
41: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
42: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
35: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
36: ,p_set_of_books_id in number default hr_api.g_number
37: ,p_source_type in varchar2 default hr_api.g_varchar2
38: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
39: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
40: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
41: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
42: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
43: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
36: ,p_set_of_books_id in number default hr_api.g_number
37: ,p_source_type in varchar2 default hr_api.g_varchar2
38: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
39: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
40: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
41: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
42: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
43: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
44: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
37: ,p_source_type in varchar2 default hr_api.g_varchar2
38: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
39: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
40: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
41: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
42: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
43: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
44: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
45: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
38: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
39: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
40: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
41: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
42: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
43: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
44: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
45: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
46: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
39: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
40: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
41: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
42: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
43: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
44: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
45: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
46: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
47: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
40: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
41: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
42: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
43: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
44: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
45: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
46: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
47: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
48: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
41: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
42: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
43: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
44: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
45: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
46: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
47: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
48: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
49: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
42: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
43: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
44: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
45: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
46: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
47: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
48: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
49: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
50: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
43: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
44: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
45: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
46: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
47: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
48: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
49: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
50: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
51: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
44: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
45: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
46: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
47: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
48: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
49: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
50: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
51: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
52: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
45: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
46: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
47: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
48: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
49: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
50: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
51: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
52: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
53: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
46: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
47: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
48: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
49: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
50: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
51: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
52: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
53: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
54: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
47: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
48: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
49: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
50: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
51: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
52: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
53: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
54: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
55: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
48: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
49: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
50: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
51: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
52: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
53: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
54: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
55: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
56: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
49: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
50: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
51: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
52: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
53: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
54: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
55: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
56: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
57: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
50: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
51: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
52: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
53: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
54: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
55: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
56: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
57: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
58: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
51: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
52: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
53: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
54: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
55: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
56: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
57: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
58: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
59: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
52: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
53: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
54: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
55: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
56: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
57: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
58: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
59: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
60: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
53: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
54: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
55: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
56: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
57: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
58: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
59: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
60: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
61: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
54: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
55: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
56: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
57: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
58: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
59: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
60: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
61: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
62: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
55: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
56: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
57: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
58: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
59: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
60: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
61: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
62: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
63: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
56: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
57: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
58: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
59: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
60: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
61: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
62: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
63: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
64: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
57: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
58: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
59: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
60: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
61: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
62: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
63: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
64: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
65: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
58: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
59: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
60: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
61: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
62: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
63: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
64: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
65: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
66: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
59: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
60: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
61: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
62: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
63: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
64: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
65: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
66: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
67: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
60: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
61: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
62: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
63: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
64: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
65: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
66: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
67: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
68: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
61: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
62: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
63: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
64: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
65: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
66: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
67: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
68: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
69: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
62: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
63: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
64: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
65: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
66: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
67: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
68: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
69: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
70: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
63: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
64: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
65: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
66: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
67: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
68: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
69: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
70: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
71: ,p_title in varchar2 default hr_api.g_varchar2
64: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
65: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
66: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
67: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
68: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
69: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
70: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
71: ,p_title in varchar2 default hr_api.g_varchar2
72: ,p_project_title in varchar2 default hr_api.g_varchar2
65: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
66: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
67: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
68: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
69: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
70: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
71: ,p_title in varchar2 default hr_api.g_varchar2
72: ,p_project_title in varchar2 default hr_api.g_varchar2
73: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
66: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
67: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
68: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
69: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
70: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
71: ,p_title in varchar2 default hr_api.g_varchar2
72: ,p_project_title in varchar2 default hr_api.g_varchar2
73: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
74: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
67: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
68: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
69: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
70: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
71: ,p_title in varchar2 default hr_api.g_varchar2
72: ,p_project_title in varchar2 default hr_api.g_varchar2
73: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
74: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
75: ,p_vendor_id in number default hr_api.g_number
68: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
69: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
70: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
71: ,p_title in varchar2 default hr_api.g_varchar2
72: ,p_project_title in varchar2 default hr_api.g_varchar2
73: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
74: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
75: ,p_vendor_id in number default hr_api.g_number
76: ,p_assignment_type in varchar2
69: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
70: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
71: ,p_title in varchar2 default hr_api.g_varchar2
72: ,p_project_title in varchar2 default hr_api.g_varchar2
73: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
74: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
75: ,p_vendor_id in number default hr_api.g_number
76: ,p_assignment_type in varchar2
77: ,p_comment_id out nocopy number
70: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
71: ,p_title in varchar2 default hr_api.g_varchar2
72: ,p_project_title in varchar2 default hr_api.g_varchar2
73: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
74: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
75: ,p_vendor_id in number default hr_api.g_number
76: ,p_assignment_type in varchar2
77: ,p_comment_id out nocopy number
78: ,p_effective_start_date out nocopy date
71: ,p_title in varchar2 default hr_api.g_varchar2
72: ,p_project_title in varchar2 default hr_api.g_varchar2
73: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
74: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
75: ,p_vendor_id in number default hr_api.g_number
76: ,p_assignment_type in varchar2
77: ,p_comment_id out nocopy number
78: ,p_effective_start_date out nocopy date
79: ,p_effective_end_date out nocopy date
319: -- --------------------------------------------------------------------------
320: function process_row
321: (c_effective_start_date in date
322: ,c_object_version_number in number
323: ,c_supervisor_id in number default hr_api.g_number
324: ,c_supervisor_assignment_id in number default hr_api.g_number
325:
326: ,c_assignment_number in varchar2 default hr_api.g_varchar2
327: ,c_change_reason in varchar2 default hr_api.g_varchar2
320: function process_row
321: (c_effective_start_date in date
322: ,c_object_version_number in number
323: ,c_supervisor_id in number default hr_api.g_number
324: ,c_supervisor_assignment_id in number default hr_api.g_number
325:
326: ,c_assignment_number in varchar2 default hr_api.g_varchar2
327: ,c_change_reason in varchar2 default hr_api.g_varchar2
328: ,c_comments in varchar2 default hr_api.g_varchar2
322: ,c_object_version_number in number
323: ,c_supervisor_id in number default hr_api.g_number
324: ,c_supervisor_assignment_id in number default hr_api.g_number
325:
326: ,c_assignment_number in varchar2 default hr_api.g_varchar2
327: ,c_change_reason in varchar2 default hr_api.g_varchar2
328: ,c_comments in varchar2 default hr_api.g_varchar2
329: ,c_date_probation_end in date default hr_api.g_date
330: ,c_default_code_comb_id in number default hr_api.g_number
323: ,c_supervisor_id in number default hr_api.g_number
324: ,c_supervisor_assignment_id in number default hr_api.g_number
325:
326: ,c_assignment_number in varchar2 default hr_api.g_varchar2
327: ,c_change_reason in varchar2 default hr_api.g_varchar2
328: ,c_comments in varchar2 default hr_api.g_varchar2
329: ,c_date_probation_end in date default hr_api.g_date
330: ,c_default_code_comb_id in number default hr_api.g_number
331: ,c_frequency in varchar2 default hr_api.g_varchar2
324: ,c_supervisor_assignment_id in number default hr_api.g_number
325:
326: ,c_assignment_number in varchar2 default hr_api.g_varchar2
327: ,c_change_reason in varchar2 default hr_api.g_varchar2
328: ,c_comments in varchar2 default hr_api.g_varchar2
329: ,c_date_probation_end in date default hr_api.g_date
330: ,c_default_code_comb_id in number default hr_api.g_number
331: ,c_frequency in varchar2 default hr_api.g_varchar2
332: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
325:
326: ,c_assignment_number in varchar2 default hr_api.g_varchar2
327: ,c_change_reason in varchar2 default hr_api.g_varchar2
328: ,c_comments in varchar2 default hr_api.g_varchar2
329: ,c_date_probation_end in date default hr_api.g_date
330: ,c_default_code_comb_id in number default hr_api.g_number
331: ,c_frequency in varchar2 default hr_api.g_varchar2
332: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
333: ,c_manager_flag in varchar2 default hr_api.g_varchar2
326: ,c_assignment_number in varchar2 default hr_api.g_varchar2
327: ,c_change_reason in varchar2 default hr_api.g_varchar2
328: ,c_comments in varchar2 default hr_api.g_varchar2
329: ,c_date_probation_end in date default hr_api.g_date
330: ,c_default_code_comb_id in number default hr_api.g_number
331: ,c_frequency in varchar2 default hr_api.g_varchar2
332: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
333: ,c_manager_flag in varchar2 default hr_api.g_varchar2
334: ,c_normal_hours in number default hr_api.g_number
327: ,c_change_reason in varchar2 default hr_api.g_varchar2
328: ,c_comments in varchar2 default hr_api.g_varchar2
329: ,c_date_probation_end in date default hr_api.g_date
330: ,c_default_code_comb_id in number default hr_api.g_number
331: ,c_frequency in varchar2 default hr_api.g_varchar2
332: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
333: ,c_manager_flag in varchar2 default hr_api.g_varchar2
334: ,c_normal_hours in number default hr_api.g_number
335: ,c_perf_review_period in number default hr_api.g_number
328: ,c_comments in varchar2 default hr_api.g_varchar2
329: ,c_date_probation_end in date default hr_api.g_date
330: ,c_default_code_comb_id in number default hr_api.g_number
331: ,c_frequency in varchar2 default hr_api.g_varchar2
332: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
333: ,c_manager_flag in varchar2 default hr_api.g_varchar2
334: ,c_normal_hours in number default hr_api.g_number
335: ,c_perf_review_period in number default hr_api.g_number
336: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
329: ,c_date_probation_end in date default hr_api.g_date
330: ,c_default_code_comb_id in number default hr_api.g_number
331: ,c_frequency in varchar2 default hr_api.g_varchar2
332: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
333: ,c_manager_flag in varchar2 default hr_api.g_varchar2
334: ,c_normal_hours in number default hr_api.g_number
335: ,c_perf_review_period in number default hr_api.g_number
336: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
337: ,c_probation_period in number default hr_api.g_number
330: ,c_default_code_comb_id in number default hr_api.g_number
331: ,c_frequency in varchar2 default hr_api.g_varchar2
332: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
333: ,c_manager_flag in varchar2 default hr_api.g_varchar2
334: ,c_normal_hours in number default hr_api.g_number
335: ,c_perf_review_period in number default hr_api.g_number
336: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
337: ,c_probation_period in number default hr_api.g_number
338: ,c_probation_unit in varchar2 default hr_api.g_varchar2
331: ,c_frequency in varchar2 default hr_api.g_varchar2
332: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
333: ,c_manager_flag in varchar2 default hr_api.g_varchar2
334: ,c_normal_hours in number default hr_api.g_number
335: ,c_perf_review_period in number default hr_api.g_number
336: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
337: ,c_probation_period in number default hr_api.g_number
338: ,c_probation_unit in varchar2 default hr_api.g_varchar2
339: ,c_sal_review_period in number default hr_api.g_number
332: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
333: ,c_manager_flag in varchar2 default hr_api.g_varchar2
334: ,c_normal_hours in number default hr_api.g_number
335: ,c_perf_review_period in number default hr_api.g_number
336: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
337: ,c_probation_period in number default hr_api.g_number
338: ,c_probation_unit in varchar2 default hr_api.g_varchar2
339: ,c_sal_review_period in number default hr_api.g_number
340: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
333: ,c_manager_flag in varchar2 default hr_api.g_varchar2
334: ,c_normal_hours in number default hr_api.g_number
335: ,c_perf_review_period in number default hr_api.g_number
336: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
337: ,c_probation_period in number default hr_api.g_number
338: ,c_probation_unit in varchar2 default hr_api.g_varchar2
339: ,c_sal_review_period in number default hr_api.g_number
340: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
341: ,c_set_of_books_id in number default hr_api.g_number
334: ,c_normal_hours in number default hr_api.g_number
335: ,c_perf_review_period in number default hr_api.g_number
336: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
337: ,c_probation_period in number default hr_api.g_number
338: ,c_probation_unit in varchar2 default hr_api.g_varchar2
339: ,c_sal_review_period in number default hr_api.g_number
340: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
341: ,c_set_of_books_id in number default hr_api.g_number
342: ,c_source_type in varchar2 default hr_api.g_varchar2
335: ,c_perf_review_period in number default hr_api.g_number
336: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
337: ,c_probation_period in number default hr_api.g_number
338: ,c_probation_unit in varchar2 default hr_api.g_varchar2
339: ,c_sal_review_period in number default hr_api.g_number
340: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
341: ,c_set_of_books_id in number default hr_api.g_number
342: ,c_source_type in varchar2 default hr_api.g_varchar2
343: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
336: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
337: ,c_probation_period in number default hr_api.g_number
338: ,c_probation_unit in varchar2 default hr_api.g_varchar2
339: ,c_sal_review_period in number default hr_api.g_number
340: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
341: ,c_set_of_books_id in number default hr_api.g_number
342: ,c_source_type in varchar2 default hr_api.g_varchar2
343: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
344: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
337: ,c_probation_period in number default hr_api.g_number
338: ,c_probation_unit in varchar2 default hr_api.g_varchar2
339: ,c_sal_review_period in number default hr_api.g_number
340: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
341: ,c_set_of_books_id in number default hr_api.g_number
342: ,c_source_type in varchar2 default hr_api.g_varchar2
343: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
344: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
345: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
338: ,c_probation_unit in varchar2 default hr_api.g_varchar2
339: ,c_sal_review_period in number default hr_api.g_number
340: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
341: ,c_set_of_books_id in number default hr_api.g_number
342: ,c_source_type in varchar2 default hr_api.g_varchar2
343: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
344: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
345: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
346: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
339: ,c_sal_review_period in number default hr_api.g_number
340: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
341: ,c_set_of_books_id in number default hr_api.g_number
342: ,c_source_type in varchar2 default hr_api.g_varchar2
343: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
344: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
345: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
346: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
347: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
340: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
341: ,c_set_of_books_id in number default hr_api.g_number
342: ,c_source_type in varchar2 default hr_api.g_varchar2
343: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
344: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
345: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
346: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
347: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
348: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
341: ,c_set_of_books_id in number default hr_api.g_number
342: ,c_source_type in varchar2 default hr_api.g_varchar2
343: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
344: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
345: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
346: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
347: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
348: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
349: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
342: ,c_source_type in varchar2 default hr_api.g_varchar2
343: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
344: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
345: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
346: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
347: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
348: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
349: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
350: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
343: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
344: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
345: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
346: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
347: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
348: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
349: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
350: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
351: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
344: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
345: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
346: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
347: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
348: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
349: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
350: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
351: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
352: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
345: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
346: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
347: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
348: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
349: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
350: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
351: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
352: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
353: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
346: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
347: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
348: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
349: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
350: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
351: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
352: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
353: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
354: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
347: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
348: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
349: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
350: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
351: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
352: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
353: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
354: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
348: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
349: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
350: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
351: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
352: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
353: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
354: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
349: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
350: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
351: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
352: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
353: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
354: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
350: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
351: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
352: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
353: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
354: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
351: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
352: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
353: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
354: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
352: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
353: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
354: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
353: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
354: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
354: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
376: ,c_title in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
376: ,c_title in varchar2 default hr_api.g_varchar2
377: ,c_project_title in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
376: ,c_title in varchar2 default hr_api.g_varchar2
377: ,c_project_title in varchar2 default hr_api.g_varchar2
378: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
376: ,c_title in varchar2 default hr_api.g_varchar2
377: ,c_project_title in varchar2 default hr_api.g_varchar2
378: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
379: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
376: ,c_title in varchar2 default hr_api.g_varchar2
377: ,c_project_title in varchar2 default hr_api.g_varchar2
378: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
379: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
380: ,c_vendor_id in number default hr_api.g_number
373: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
376: ,c_title in varchar2 default hr_api.g_varchar2
377: ,c_project_title in varchar2 default hr_api.g_varchar2
378: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
379: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
380: ,c_vendor_id in number default hr_api.g_number
381: )
374: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
376: ,c_title in varchar2 default hr_api.g_varchar2
377: ,c_project_title in varchar2 default hr_api.g_varchar2
378: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
379: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
380: ,c_vendor_id in number default hr_api.g_number
381: )
382: return boolean is
375: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
376: ,c_title in varchar2 default hr_api.g_varchar2
377: ,c_project_title in varchar2 default hr_api.g_varchar2
378: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
379: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
380: ,c_vendor_id in number default hr_api.g_number
381: )
382: return boolean is
383: l_proc varchar2(72) := g_package||'process_row';
376: ,c_title in varchar2 default hr_api.g_varchar2
377: ,c_project_title in varchar2 default hr_api.g_varchar2
378: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
379: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
380: ,c_vendor_id in number default hr_api.g_number
381: )
382: return boolean is
383: l_proc varchar2(72) := g_package||'process_row';
384: begin
900: if l_effective_date_row then
901: -- reset the first row flag
902: l_effective_date_row := false;
903: -- set all future row operations to a CORRECTION
904: l_datetrack_update_mode := hr_api.g_correction;
905: -- set the API out parameters for the first transaction
906: p_object_version_number := l_asg_rec.object_version_number;
907: p_comment_id := l_comment_id;
908: p_effective_start_date := l_effective_start_date;
940: -- b) to populate the l_validation_start_date which is used
941: -- in determining the correct datetrack mode on an update operation
942: per_asg_shd.lck
943: (p_effective_date => l_constant_effective_date
944: ,p_datetrack_mode => hr_api.g_correction
945: ,p_assignment_id => p_assignment_id
946: ,p_object_version_number => p_object_version_number
947: ,p_validation_start_date => l_validation_start_date
948: ,p_validation_end_date => l_validation_end_date);
972: ,p_update_change_insert => l_update_change_insert);
973: -- step 1.2
974: if l_update then
975: -- we can do an update
976: l_datetrack_update_mode := hr_api.g_update;
977: elsif l_update_change_insert then
978: -- we can do an update change insert
979: l_datetrack_update_mode := hr_api.g_update_change_insert;
980: elsif (l_validation_start_date = l_constant_effective_date) and
975: -- we can do an update
976: l_datetrack_update_mode := hr_api.g_update;
977: elsif l_update_change_insert then
978: -- we can do an update change insert
979: l_datetrack_update_mode := hr_api.g_update_change_insert;
980: elsif (l_validation_start_date = l_constant_effective_date) and
981: l_correction then
982: -- we can only perform a correction
983: l_datetrack_update_mode := hr_api.g_correction;
979: l_datetrack_update_mode := hr_api.g_update_change_insert;
980: elsif (l_validation_start_date = l_constant_effective_date) and
981: l_correction then
982: -- we can only perform a correction
983: l_datetrack_update_mode := hr_api.g_correction;
984: else
985: -- we cannot perform an update due to a restriction within the APIs
986: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
987: hr_utility.set_message_token('PROCEDURE', l_proc);
992: l_lck_start_date := l_constant_effective_date;
993: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
994: -- set lock start date to start of time and the datetrack mode
995: -- to CORRECTION
996: l_lck_start_date := hr_api.g_sot;
997: l_datetrack_update_mode := hr_api.g_correction;
998: else
999: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1000: -- so raise DT invalid mode error
993: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
994: -- set lock start date to start of time and the datetrack mode
995: -- to CORRECTION
996: l_lck_start_date := hr_api.g_sot;
997: l_datetrack_update_mode := hr_api.g_correction;
998: else
999: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1000: -- so raise DT invalid mode error
1001: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1153: --
1154: -- When in validation only mode raise the Validate_Enabled exception
1155: --
1156: if p_validate then
1157: raise hr_api.validate_enabled;
1158: end if;
1159: -- set the warning OUT parameters
1160: p_no_managers_warning := l_api_no_managers_warning;
1161: p_other_manager_warning := l_api_other_manager_warning;
1161: p_other_manager_warning := l_api_other_manager_warning;
1162: --
1163: hr_utility.set_location(' Leaving:'||l_proc, 10);
1164: exception
1165: when hr_api.validate_enabled then
1166: --
1167: -- As the Validate_Enabled exception has been raised
1168: -- we must rollback to the savepoint
1169: --
1201: ,p_effective_date in date
1202: ,p_attribute_update_mode in varchar2
1203: ,p_assignment_id in number
1204: ,p_object_version_number in out nocopy number
1205: ,p_grade_id in number default hr_api.g_number
1206: ,p_position_id in number default hr_api.g_number
1207: ,p_job_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1202: ,p_attribute_update_mode in varchar2
1203: ,p_assignment_id in number
1204: ,p_object_version_number in out nocopy number
1205: ,p_grade_id in number default hr_api.g_number
1206: ,p_position_id in number default hr_api.g_number
1207: ,p_job_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_special_ceiling_step_id in out nocopy number
1203: ,p_assignment_id in number
1204: ,p_object_version_number in out nocopy number
1205: ,p_grade_id in number default hr_api.g_number
1206: ,p_position_id in number default hr_api.g_number
1207: ,p_job_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_special_ceiling_step_id in out nocopy number
1211: ,p_organization_id in number default hr_api.g_number
1204: ,p_object_version_number in out nocopy number
1205: ,p_grade_id in number default hr_api.g_number
1206: ,p_position_id in number default hr_api.g_number
1207: ,p_job_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_special_ceiling_step_id in out nocopy number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_pay_basis_id in number default hr_api.g_number
1205: ,p_grade_id in number default hr_api.g_number
1206: ,p_position_id in number default hr_api.g_number
1207: ,p_job_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_special_ceiling_step_id in out nocopy number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_pay_basis_id in number default hr_api.g_number
1213: ,p_employment_category in varchar2 default hr_api.g_varchar2
1207: ,p_job_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_special_ceiling_step_id in out nocopy number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_pay_basis_id in number default hr_api.g_number
1213: ,p_employment_category in varchar2 default hr_api.g_varchar2
1214: ,p_assignment_type in varchar2
1215: ,p_effective_start_date out nocopy date
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_special_ceiling_step_id in out nocopy number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_pay_basis_id in number default hr_api.g_number
1213: ,p_employment_category in varchar2 default hr_api.g_varchar2
1214: ,p_assignment_type in varchar2
1215: ,p_effective_start_date out nocopy date
1216: ,p_effective_end_date out nocopy date
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_special_ceiling_step_id in out nocopy number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_pay_basis_id in number default hr_api.g_number
1213: ,p_employment_category in varchar2 default hr_api.g_varchar2
1214: ,p_assignment_type in varchar2
1215: ,p_effective_start_date out nocopy date
1216: ,p_effective_end_date out nocopy date
1217: ,p_no_managers_warning out nocopy boolean
1360: -- --------------------------------------------------------------------------
1361: function process_row
1362: (c_effective_start_date in date
1363: ,c_object_version_number in number
1364: ,c_grade_id in number default hr_api.g_number
1365: ,c_position_id in number default hr_api.g_number
1366: ,c_job_id in number default hr_api.g_number
1367: ,c_payroll_id in number default hr_api.g_number
1368: ,c_location_id in number default hr_api.g_number
1361: function process_row
1362: (c_effective_start_date in date
1363: ,c_object_version_number in number
1364: ,c_grade_id in number default hr_api.g_number
1365: ,c_position_id in number default hr_api.g_number
1366: ,c_job_id in number default hr_api.g_number
1367: ,c_payroll_id in number default hr_api.g_number
1368: ,c_location_id in number default hr_api.g_number
1369: ,c_special_ceiling_step_id in out nocopy number
1362: (c_effective_start_date in date
1363: ,c_object_version_number in number
1364: ,c_grade_id in number default hr_api.g_number
1365: ,c_position_id in number default hr_api.g_number
1366: ,c_job_id in number default hr_api.g_number
1367: ,c_payroll_id in number default hr_api.g_number
1368: ,c_location_id in number default hr_api.g_number
1369: ,c_special_ceiling_step_id in out nocopy number
1370: ,c_organization_id in number default hr_api.g_number
1363: ,c_object_version_number in number
1364: ,c_grade_id in number default hr_api.g_number
1365: ,c_position_id in number default hr_api.g_number
1366: ,c_job_id in number default hr_api.g_number
1367: ,c_payroll_id in number default hr_api.g_number
1368: ,c_location_id in number default hr_api.g_number
1369: ,c_special_ceiling_step_id in out nocopy number
1370: ,c_organization_id in number default hr_api.g_number
1371: ,c_pay_basis_id in number default hr_api.g_number
1364: ,c_grade_id in number default hr_api.g_number
1365: ,c_position_id in number default hr_api.g_number
1366: ,c_job_id in number default hr_api.g_number
1367: ,c_payroll_id in number default hr_api.g_number
1368: ,c_location_id in number default hr_api.g_number
1369: ,c_special_ceiling_step_id in out nocopy number
1370: ,c_organization_id in number default hr_api.g_number
1371: ,c_pay_basis_id in number default hr_api.g_number
1372: ,c_employment_category in varchar2 default hr_api.g_varchar2
1366: ,c_job_id in number default hr_api.g_number
1367: ,c_payroll_id in number default hr_api.g_number
1368: ,c_location_id in number default hr_api.g_number
1369: ,c_special_ceiling_step_id in out nocopy number
1370: ,c_organization_id in number default hr_api.g_number
1371: ,c_pay_basis_id in number default hr_api.g_number
1372: ,c_employment_category in varchar2 default hr_api.g_varchar2
1373: )
1374: return boolean is
1367: ,c_payroll_id in number default hr_api.g_number
1368: ,c_location_id in number default hr_api.g_number
1369: ,c_special_ceiling_step_id in out nocopy number
1370: ,c_organization_id in number default hr_api.g_number
1371: ,c_pay_basis_id in number default hr_api.g_number
1372: ,c_employment_category in varchar2 default hr_api.g_varchar2
1373: )
1374: return boolean is
1375: l_proc varchar2(72) := g_package||'process_row';
1368: ,c_location_id in number default hr_api.g_number
1369: ,c_special_ceiling_step_id in out nocopy number
1370: ,c_organization_id in number default hr_api.g_number
1371: ,c_pay_basis_id in number default hr_api.g_number
1372: ,c_employment_category in varchar2 default hr_api.g_varchar2
1373: )
1374: return boolean is
1375: l_proc varchar2(72) := g_package||'process_row';
1376: begin
1498: if l_effective_date_row then
1499: -- reset the first row flag
1500: l_effective_date_row := false;
1501: -- set all future row operations to a CORRECTION
1502: l_datetrack_update_mode := hr_api.g_correction;
1503: -- set the API out parameters for the first transaction
1504: p_object_version_number := l_asg_rec.object_version_number;
1505: p_special_ceiling_step_id := l_asg_rec.special_ceiling_step_id;
1506: p_effective_start_date := l_effective_start_date;
1548: -- b) to populate the l_validation_start_date which is used
1549: -- in determining the correct datetrack mode on an update operation
1550: per_asg_shd.lck
1551: (p_effective_date => l_constant_effective_date
1552: ,p_datetrack_mode => hr_api.g_correction
1553: ,p_assignment_id => p_assignment_id
1554: ,p_object_version_number => p_object_version_number
1555: ,p_validation_start_date => l_validation_start_date
1556: ,p_validation_end_date => l_validation_end_date);
1580: ,p_update_change_insert => l_update_change_insert);
1581: -- step 1.2
1582: if l_update then
1583: -- we can do an update
1584: l_datetrack_update_mode := hr_api.g_update;
1585: elsif l_update_change_insert then
1586: -- we can do an update change insert
1587: l_datetrack_update_mode := hr_api.g_update_change_insert;
1588: elsif (l_validation_start_date = l_constant_effective_date) and
1583: -- we can do an update
1584: l_datetrack_update_mode := hr_api.g_update;
1585: elsif l_update_change_insert then
1586: -- we can do an update change insert
1587: l_datetrack_update_mode := hr_api.g_update_change_insert;
1588: elsif (l_validation_start_date = l_constant_effective_date) and
1589: l_correction then
1590: -- we can only perform a correction
1591: l_datetrack_update_mode := hr_api.g_correction;
1587: l_datetrack_update_mode := hr_api.g_update_change_insert;
1588: elsif (l_validation_start_date = l_constant_effective_date) and
1589: l_correction then
1590: -- we can only perform a correction
1591: l_datetrack_update_mode := hr_api.g_correction;
1592: else
1593: -- we cannot perform an update due to a restriction within the APIs
1594: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1595: hr_utility.set_message_token('PROCEDURE', l_proc);
1600: l_lck_start_date := l_constant_effective_date;
1601: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1602: -- set lock start date to start of time and the datetrack mode
1603: -- to CORRECTION
1604: l_lck_start_date := hr_api.g_sot;
1605: l_datetrack_update_mode := hr_api.g_correction;
1606: else
1607: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1608: -- so raise DT invalid mode error
1601: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1602: -- set lock start date to start of time and the datetrack mode
1603: -- to CORRECTION
1604: l_lck_start_date := hr_api.g_sot;
1605: l_datetrack_update_mode := hr_api.g_correction;
1606: else
1607: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1608: -- so raise DT invalid mode error
1609: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1660: --
1661: -- When in validation only mode raise the Validate_Enabled exception
1662: --
1663: if p_validate then
1664: raise hr_api.validate_enabled;
1665: end if;
1666: -- set the warning OUT parameters
1667: p_no_managers_warning := l_api_no_managers_warning;
1668: p_other_manager_warning := l_api_other_manager_warning;
1671: p_tax_district_changed_warning := l_api_tax_district_changed;
1672: --
1673: hr_utility.set_location(' Leaving:'||l_proc, 10);
1674: exception
1675: when hr_api.validate_enabled then
1676: --
1677: -- As the Validate_Enabled exception has been raised
1678: -- we must rollback to the savepoint
1679: --