[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
329: -- --------------------------------------------------------------------------
330: function process_row
331: (c_effective_start_date in date
332: ,c_object_version_number in number
333: ,c_supervisor_id in number default hr_api.g_number
334: ,c_supervisor_assignment_id in number default hr_api.g_number
335:
336: ,c_assignment_number in varchar2 default hr_api.g_varchar2
337: ,c_change_reason in varchar2 default hr_api.g_varchar2
330: function process_row
331: (c_effective_start_date in date
332: ,c_object_version_number in number
333: ,c_supervisor_id in number default hr_api.g_number
334: ,c_supervisor_assignment_id in number default hr_api.g_number
335:
336: ,c_assignment_number in varchar2 default hr_api.g_varchar2
337: ,c_change_reason in varchar2 default hr_api.g_varchar2
338: ,c_comments in varchar2 default hr_api.g_varchar2
332: ,c_object_version_number in number
333: ,c_supervisor_id in number default hr_api.g_number
334: ,c_supervisor_assignment_id in number default hr_api.g_number
335:
336: ,c_assignment_number in varchar2 default hr_api.g_varchar2
337: ,c_change_reason in varchar2 default hr_api.g_varchar2
338: ,c_comments in varchar2 default hr_api.g_varchar2
339: ,c_date_probation_end in date default hr_api.g_date
340: ,c_default_code_comb_id in number default hr_api.g_number
333: ,c_supervisor_id in number default hr_api.g_number
334: ,c_supervisor_assignment_id in number default hr_api.g_number
335:
336: ,c_assignment_number in varchar2 default hr_api.g_varchar2
337: ,c_change_reason in varchar2 default hr_api.g_varchar2
338: ,c_comments in varchar2 default hr_api.g_varchar2
339: ,c_date_probation_end in date default hr_api.g_date
340: ,c_default_code_comb_id in number default hr_api.g_number
341: ,c_frequency in varchar2 default hr_api.g_varchar2
334: ,c_supervisor_assignment_id in number default hr_api.g_number
335:
336: ,c_assignment_number in varchar2 default hr_api.g_varchar2
337: ,c_change_reason in varchar2 default hr_api.g_varchar2
338: ,c_comments in varchar2 default hr_api.g_varchar2
339: ,c_date_probation_end in date default hr_api.g_date
340: ,c_default_code_comb_id in number default hr_api.g_number
341: ,c_frequency in varchar2 default hr_api.g_varchar2
342: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
335:
336: ,c_assignment_number in varchar2 default hr_api.g_varchar2
337: ,c_change_reason in varchar2 default hr_api.g_varchar2
338: ,c_comments in varchar2 default hr_api.g_varchar2
339: ,c_date_probation_end in date default hr_api.g_date
340: ,c_default_code_comb_id in number default hr_api.g_number
341: ,c_frequency in varchar2 default hr_api.g_varchar2
342: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
343: ,c_manager_flag in varchar2 default hr_api.g_varchar2
336: ,c_assignment_number in varchar2 default hr_api.g_varchar2
337: ,c_change_reason in varchar2 default hr_api.g_varchar2
338: ,c_comments in varchar2 default hr_api.g_varchar2
339: ,c_date_probation_end in date default hr_api.g_date
340: ,c_default_code_comb_id in number default hr_api.g_number
341: ,c_frequency in varchar2 default hr_api.g_varchar2
342: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
343: ,c_manager_flag in varchar2 default hr_api.g_varchar2
344: ,c_normal_hours in number default hr_api.g_number
337: ,c_change_reason in varchar2 default hr_api.g_varchar2
338: ,c_comments in varchar2 default hr_api.g_varchar2
339: ,c_date_probation_end in date default hr_api.g_date
340: ,c_default_code_comb_id in number default hr_api.g_number
341: ,c_frequency in varchar2 default hr_api.g_varchar2
342: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
343: ,c_manager_flag in varchar2 default hr_api.g_varchar2
344: ,c_normal_hours in number default hr_api.g_number
345: ,c_perf_review_period in number default hr_api.g_number
338: ,c_comments in varchar2 default hr_api.g_varchar2
339: ,c_date_probation_end in date default hr_api.g_date
340: ,c_default_code_comb_id in number default hr_api.g_number
341: ,c_frequency in varchar2 default hr_api.g_varchar2
342: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
343: ,c_manager_flag in varchar2 default hr_api.g_varchar2
344: ,c_normal_hours in number default hr_api.g_number
345: ,c_perf_review_period in number default hr_api.g_number
346: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
339: ,c_date_probation_end in date default hr_api.g_date
340: ,c_default_code_comb_id in number default hr_api.g_number
341: ,c_frequency in varchar2 default hr_api.g_varchar2
342: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
343: ,c_manager_flag in varchar2 default hr_api.g_varchar2
344: ,c_normal_hours in number default hr_api.g_number
345: ,c_perf_review_period in number default hr_api.g_number
346: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
347: ,c_probation_period in number default hr_api.g_number
340: ,c_default_code_comb_id in number default hr_api.g_number
341: ,c_frequency in varchar2 default hr_api.g_varchar2
342: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
343: ,c_manager_flag in varchar2 default hr_api.g_varchar2
344: ,c_normal_hours in number default hr_api.g_number
345: ,c_perf_review_period in number default hr_api.g_number
346: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
347: ,c_probation_period in number default hr_api.g_number
348: ,c_probation_unit in varchar2 default hr_api.g_varchar2
341: ,c_frequency in varchar2 default hr_api.g_varchar2
342: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
343: ,c_manager_flag in varchar2 default hr_api.g_varchar2
344: ,c_normal_hours in number default hr_api.g_number
345: ,c_perf_review_period in number default hr_api.g_number
346: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
347: ,c_probation_period in number default hr_api.g_number
348: ,c_probation_unit in varchar2 default hr_api.g_varchar2
349: ,c_sal_review_period in number default hr_api.g_number
342: ,c_internal_address_line in varchar2 default hr_api.g_varchar2
343: ,c_manager_flag in varchar2 default hr_api.g_varchar2
344: ,c_normal_hours in number default hr_api.g_number
345: ,c_perf_review_period in number default hr_api.g_number
346: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
347: ,c_probation_period in number default hr_api.g_number
348: ,c_probation_unit in varchar2 default hr_api.g_varchar2
349: ,c_sal_review_period in number default hr_api.g_number
350: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
343: ,c_manager_flag in varchar2 default hr_api.g_varchar2
344: ,c_normal_hours in number default hr_api.g_number
345: ,c_perf_review_period in number default hr_api.g_number
346: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
347: ,c_probation_period in number default hr_api.g_number
348: ,c_probation_unit in varchar2 default hr_api.g_varchar2
349: ,c_sal_review_period in number default hr_api.g_number
350: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
351: ,c_set_of_books_id in number default hr_api.g_number
344: ,c_normal_hours in number default hr_api.g_number
345: ,c_perf_review_period in number default hr_api.g_number
346: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
347: ,c_probation_period in number default hr_api.g_number
348: ,c_probation_unit in varchar2 default hr_api.g_varchar2
349: ,c_sal_review_period in number default hr_api.g_number
350: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
351: ,c_set_of_books_id in number default hr_api.g_number
352: ,c_source_type in varchar2 default hr_api.g_varchar2
345: ,c_perf_review_period in number default hr_api.g_number
346: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
347: ,c_probation_period in number default hr_api.g_number
348: ,c_probation_unit in varchar2 default hr_api.g_varchar2
349: ,c_sal_review_period in number default hr_api.g_number
350: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
351: ,c_set_of_books_id in number default hr_api.g_number
352: ,c_source_type in varchar2 default hr_api.g_varchar2
353: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
346: ,c_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
347: ,c_probation_period in number default hr_api.g_number
348: ,c_probation_unit in varchar2 default hr_api.g_varchar2
349: ,c_sal_review_period in number default hr_api.g_number
350: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
351: ,c_set_of_books_id in number default hr_api.g_number
352: ,c_source_type in varchar2 default hr_api.g_varchar2
353: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
354: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
347: ,c_probation_period in number default hr_api.g_number
348: ,c_probation_unit in varchar2 default hr_api.g_varchar2
349: ,c_sal_review_period in number default hr_api.g_number
350: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
351: ,c_set_of_books_id in number default hr_api.g_number
352: ,c_source_type in varchar2 default hr_api.g_varchar2
353: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
354: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
348: ,c_probation_unit in varchar2 default hr_api.g_varchar2
349: ,c_sal_review_period in number default hr_api.g_number
350: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
351: ,c_set_of_books_id in number default hr_api.g_number
352: ,c_source_type in varchar2 default hr_api.g_varchar2
353: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
354: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
349: ,c_sal_review_period in number default hr_api.g_number
350: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
351: ,c_set_of_books_id in number default hr_api.g_number
352: ,c_source_type in varchar2 default hr_api.g_varchar2
353: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
354: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
350: ,c_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
351: ,c_set_of_books_id in number default hr_api.g_number
352: ,c_source_type in varchar2 default hr_api.g_varchar2
353: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
354: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
351: ,c_set_of_books_id in number default hr_api.g_number
352: ,c_source_type in varchar2 default hr_api.g_varchar2
353: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
354: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
352: ,c_source_type in varchar2 default hr_api.g_varchar2
353: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
354: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
353: ,c_time_normal_finish in varchar2 default hr_api.g_varchar2
354: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
354: ,c_time_normal_start in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
355: ,c_ass_attribute_category in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
356: ,c_ass_attribute1 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
357: ,c_ass_attribute2 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
358: ,c_ass_attribute3 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
359: ,c_ass_attribute4 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
360: ,c_ass_attribute5 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
361: ,c_ass_attribute6 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
362: ,c_ass_attribute7 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
363: ,c_ass_attribute8 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
364: ,c_ass_attribute9 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
365: ,c_ass_attribute10 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
366: ,c_ass_attribute11 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
367: ,c_ass_attribute12 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
368: ,c_ass_attribute13 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
376: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
369: ,c_ass_attribute14 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
376: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
377: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
370: ,c_ass_attribute15 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
376: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
377: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
378: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
371: ,c_ass_attribute16 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
376: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
377: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
378: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
379: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
372: ,c_ass_attribute17 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
376: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
377: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
378: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
379: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
380: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
373: ,c_ass_attribute18 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
376: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
377: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
378: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
379: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
380: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
381: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
374: ,c_ass_attribute19 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
376: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
377: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
378: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
379: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
380: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
381: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
382: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
375: ,c_ass_attribute20 in varchar2 default hr_api.g_varchar2
376: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
377: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
378: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
379: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
380: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
381: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
382: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
383: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
376: ,c_ass_attribute21 in varchar2 default hr_api.g_varchar2
377: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
378: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
379: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
380: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
381: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
382: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
383: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
384: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
377: ,c_ass_attribute22 in varchar2 default hr_api.g_varchar2
378: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
379: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
380: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
381: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
382: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
383: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
384: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
385: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
378: ,c_ass_attribute23 in varchar2 default hr_api.g_varchar2
379: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
380: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
381: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
382: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
383: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
384: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
385: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
386: ,c_title in varchar2 default hr_api.g_varchar2
379: ,c_ass_attribute24 in varchar2 default hr_api.g_varchar2
380: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
381: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
382: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
383: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
384: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
385: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
386: ,c_title in varchar2 default hr_api.g_varchar2
387: ,c_project_title in varchar2 default hr_api.g_varchar2
380: ,c_ass_attribute25 in varchar2 default hr_api.g_varchar2
381: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
382: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
383: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
384: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
385: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
386: ,c_title in varchar2 default hr_api.g_varchar2
387: ,c_project_title in varchar2 default hr_api.g_varchar2
388: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
381: ,c_ass_attribute26 in varchar2 default hr_api.g_varchar2
382: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
383: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
384: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
385: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
386: ,c_title in varchar2 default hr_api.g_varchar2
387: ,c_project_title in varchar2 default hr_api.g_varchar2
388: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
389: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
382: ,c_ass_attribute27 in varchar2 default hr_api.g_varchar2
383: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
384: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
385: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
386: ,c_title in varchar2 default hr_api.g_varchar2
387: ,c_project_title in varchar2 default hr_api.g_varchar2
388: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
389: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
390: ,c_vendor_id in number default hr_api.g_number
383: ,c_ass_attribute28 in varchar2 default hr_api.g_varchar2
384: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
385: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
386: ,c_title in varchar2 default hr_api.g_varchar2
387: ,c_project_title in varchar2 default hr_api.g_varchar2
388: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
389: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
390: ,c_vendor_id in number default hr_api.g_number
391: ,c_soft_coding_keyflex_id in number default hr_api.g_number
384: ,c_ass_attribute29 in varchar2 default hr_api.g_varchar2
385: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
386: ,c_title in varchar2 default hr_api.g_varchar2
387: ,c_project_title in varchar2 default hr_api.g_varchar2
388: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
389: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
390: ,c_vendor_id in number default hr_api.g_number
391: ,c_soft_coding_keyflex_id in number default hr_api.g_number
392: )
385: ,c_ass_attribute30 in varchar2 default hr_api.g_varchar2
386: ,c_title in varchar2 default hr_api.g_varchar2
387: ,c_project_title in varchar2 default hr_api.g_varchar2
388: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
389: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
390: ,c_vendor_id in number default hr_api.g_number
391: ,c_soft_coding_keyflex_id in number default hr_api.g_number
392: )
393: return boolean is
386: ,c_title in varchar2 default hr_api.g_varchar2
387: ,c_project_title in varchar2 default hr_api.g_varchar2
388: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
389: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
390: ,c_vendor_id in number default hr_api.g_number
391: ,c_soft_coding_keyflex_id in number default hr_api.g_number
392: )
393: return boolean is
394: l_proc varchar2(72) := g_package||'process_row';
387: ,c_project_title in varchar2 default hr_api.g_varchar2
388: ,c_vendor_assignment_number in varchar2 default hr_api.g_varchar2
389: ,c_vendor_employee_number in varchar2 default hr_api.g_varchar2
390: ,c_vendor_id in number default hr_api.g_number
391: ,c_soft_coding_keyflex_id in number default hr_api.g_number
392: )
393: return boolean is
394: l_proc varchar2(72) := g_package||'process_row';
395: begin
917: if l_effective_date_row then
918: -- reset the first row flag
919: l_effective_date_row := false;
920: -- set all future row operations to a CORRECTION
921: l_datetrack_update_mode := hr_api.g_correction;
922: -- set the API out parameters for the first transaction
923: p_object_version_number := l_asg_rec.object_version_number;
924: p_comment_id := l_comment_id;
925: p_effective_start_date := l_effective_start_date;
968: -- b) to populate the l_validation_start_date which is used
969: -- in determining the correct datetrack mode on an update operation
970: per_asg_shd.lck
971: (p_effective_date => l_constant_effective_date
972: ,p_datetrack_mode => hr_api.g_correction
973: ,p_assignment_id => p_assignment_id
974: ,p_object_version_number => p_object_version_number
975: ,p_validation_start_date => l_validation_start_date
976: ,p_validation_end_date => l_validation_end_date);
1000: ,p_update_change_insert => l_update_change_insert);
1001: -- step 1.2
1002: if l_update then
1003: -- we can do an update
1004: l_datetrack_update_mode := hr_api.g_update;
1005: elsif l_update_change_insert then
1006: -- we can do an update change insert
1007: l_datetrack_update_mode := hr_api.g_update_change_insert;
1008: elsif (l_validation_start_date = l_constant_effective_date) and
1003: -- we can do an update
1004: l_datetrack_update_mode := hr_api.g_update;
1005: elsif l_update_change_insert then
1006: -- we can do an update change insert
1007: l_datetrack_update_mode := hr_api.g_update_change_insert;
1008: elsif (l_validation_start_date = l_constant_effective_date) and
1009: l_correction then
1010: -- we can only perform a correction
1011: l_datetrack_update_mode := hr_api.g_correction;
1007: l_datetrack_update_mode := hr_api.g_update_change_insert;
1008: elsif (l_validation_start_date = l_constant_effective_date) and
1009: l_correction then
1010: -- we can only perform a correction
1011: l_datetrack_update_mode := hr_api.g_correction;
1012: else
1013: -- we cannot perform an update due to a restriction within the APIs
1014: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1015: hr_utility.set_message_token('PROCEDURE', l_proc);
1020: l_lck_start_date := l_constant_effective_date;
1021: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1022: -- set lock start date to start of time and the datetrack mode
1023: -- to CORRECTION
1024: l_lck_start_date := hr_api.g_sot;
1025: l_datetrack_update_mode := hr_api.g_correction;
1026: else
1027: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1028: -- so raise DT invalid mode error
1021: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1022: -- set lock start date to start of time and the datetrack mode
1023: -- to CORRECTION
1024: l_lck_start_date := hr_api.g_sot;
1025: l_datetrack_update_mode := hr_api.g_correction;
1026: else
1027: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1028: -- so raise DT invalid mode error
1029: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1191: --
1192: -- When in validation only mode raise the Validate_Enabled exception
1193: --
1194: if p_validate then
1195: raise hr_api.validate_enabled;
1196: end if;
1197: -- set the warning OUT parameters
1198: p_no_managers_warning := l_api_no_managers_warning;
1199: p_other_manager_warning := l_api_other_manager_warning;
1199: p_other_manager_warning := l_api_other_manager_warning;
1200: --
1201: hr_utility.set_location(' Leaving:'||l_proc, 10);
1202: exception
1203: when hr_api.validate_enabled then
1204: --
1205: -- As the Validate_Enabled exception has been raised
1206: -- we must rollback to the savepoint
1207: --
1239: ,p_effective_date in date
1240: ,p_attribute_update_mode in varchar2
1241: ,p_assignment_id in number
1242: ,p_object_version_number in out nocopy number
1243: ,p_grade_id in number default hr_api.g_number
1244: ,p_position_id in number default hr_api.g_number
1245: ,p_job_id in number default hr_api.g_number
1246: ,p_payroll_id in number default hr_api.g_number
1247: ,p_location_id in number default hr_api.g_number
1240: ,p_attribute_update_mode in varchar2
1241: ,p_assignment_id in number
1242: ,p_object_version_number in out nocopy number
1243: ,p_grade_id in number default hr_api.g_number
1244: ,p_position_id in number default hr_api.g_number
1245: ,p_job_id in number default hr_api.g_number
1246: ,p_payroll_id in number default hr_api.g_number
1247: ,p_location_id in number default hr_api.g_number
1248: ,p_special_ceiling_step_id in out nocopy number
1241: ,p_assignment_id in number
1242: ,p_object_version_number in out nocopy number
1243: ,p_grade_id in number default hr_api.g_number
1244: ,p_position_id in number default hr_api.g_number
1245: ,p_job_id in number default hr_api.g_number
1246: ,p_payroll_id in number default hr_api.g_number
1247: ,p_location_id in number default hr_api.g_number
1248: ,p_special_ceiling_step_id in out nocopy number
1249: ,p_organization_id in number default hr_api.g_number
1242: ,p_object_version_number in out nocopy number
1243: ,p_grade_id in number default hr_api.g_number
1244: ,p_position_id in number default hr_api.g_number
1245: ,p_job_id in number default hr_api.g_number
1246: ,p_payroll_id in number default hr_api.g_number
1247: ,p_location_id in number default hr_api.g_number
1248: ,p_special_ceiling_step_id in out nocopy number
1249: ,p_organization_id in number default hr_api.g_number
1250: ,p_pay_basis_id in number default hr_api.g_number
1243: ,p_grade_id in number default hr_api.g_number
1244: ,p_position_id in number default hr_api.g_number
1245: ,p_job_id in number default hr_api.g_number
1246: ,p_payroll_id in number default hr_api.g_number
1247: ,p_location_id in number default hr_api.g_number
1248: ,p_special_ceiling_step_id in out nocopy number
1249: ,p_organization_id in number default hr_api.g_number
1250: ,p_pay_basis_id in number default hr_api.g_number
1251: ,p_employment_category in varchar2 default hr_api.g_varchar2
1245: ,p_job_id in number default hr_api.g_number
1246: ,p_payroll_id in number default hr_api.g_number
1247: ,p_location_id in number default hr_api.g_number
1248: ,p_special_ceiling_step_id in out nocopy number
1249: ,p_organization_id in number default hr_api.g_number
1250: ,p_pay_basis_id in number default hr_api.g_number
1251: ,p_employment_category in varchar2 default hr_api.g_varchar2
1252: ,p_assignment_type in varchar2
1253: ,p_effective_start_date out nocopy date
1246: ,p_payroll_id in number default hr_api.g_number
1247: ,p_location_id in number default hr_api.g_number
1248: ,p_special_ceiling_step_id in out nocopy number
1249: ,p_organization_id in number default hr_api.g_number
1250: ,p_pay_basis_id in number default hr_api.g_number
1251: ,p_employment_category in varchar2 default hr_api.g_varchar2
1252: ,p_assignment_type in varchar2
1253: ,p_effective_start_date out nocopy date
1254: ,p_effective_end_date out nocopy date
1247: ,p_location_id in number default hr_api.g_number
1248: ,p_special_ceiling_step_id in out nocopy number
1249: ,p_organization_id in number default hr_api.g_number
1250: ,p_pay_basis_id in number default hr_api.g_number
1251: ,p_employment_category in varchar2 default hr_api.g_varchar2
1252: ,p_assignment_type in varchar2
1253: ,p_effective_start_date out nocopy date
1254: ,p_effective_end_date out nocopy date
1255: ,p_no_managers_warning out nocopy boolean
1398: -- --------------------------------------------------------------------------
1399: function process_row
1400: (c_effective_start_date in date
1401: ,c_object_version_number in number
1402: ,c_grade_id in number default hr_api.g_number
1403: ,c_position_id in number default hr_api.g_number
1404: ,c_job_id in number default hr_api.g_number
1405: ,c_payroll_id in number default hr_api.g_number
1406: ,c_location_id in number default hr_api.g_number
1399: function process_row
1400: (c_effective_start_date in date
1401: ,c_object_version_number in number
1402: ,c_grade_id in number default hr_api.g_number
1403: ,c_position_id in number default hr_api.g_number
1404: ,c_job_id in number default hr_api.g_number
1405: ,c_payroll_id in number default hr_api.g_number
1406: ,c_location_id in number default hr_api.g_number
1407: ,c_special_ceiling_step_id in out nocopy number
1400: (c_effective_start_date in date
1401: ,c_object_version_number in number
1402: ,c_grade_id in number default hr_api.g_number
1403: ,c_position_id in number default hr_api.g_number
1404: ,c_job_id in number default hr_api.g_number
1405: ,c_payroll_id in number default hr_api.g_number
1406: ,c_location_id in number default hr_api.g_number
1407: ,c_special_ceiling_step_id in out nocopy number
1408: ,c_organization_id in number default hr_api.g_number
1401: ,c_object_version_number in number
1402: ,c_grade_id in number default hr_api.g_number
1403: ,c_position_id in number default hr_api.g_number
1404: ,c_job_id in number default hr_api.g_number
1405: ,c_payroll_id in number default hr_api.g_number
1406: ,c_location_id in number default hr_api.g_number
1407: ,c_special_ceiling_step_id in out nocopy number
1408: ,c_organization_id in number default hr_api.g_number
1409: ,c_pay_basis_id in number default hr_api.g_number
1402: ,c_grade_id in number default hr_api.g_number
1403: ,c_position_id in number default hr_api.g_number
1404: ,c_job_id in number default hr_api.g_number
1405: ,c_payroll_id in number default hr_api.g_number
1406: ,c_location_id in number default hr_api.g_number
1407: ,c_special_ceiling_step_id in out nocopy number
1408: ,c_organization_id in number default hr_api.g_number
1409: ,c_pay_basis_id in number default hr_api.g_number
1410: ,c_employment_category in varchar2 default hr_api.g_varchar2
1404: ,c_job_id in number default hr_api.g_number
1405: ,c_payroll_id in number default hr_api.g_number
1406: ,c_location_id in number default hr_api.g_number
1407: ,c_special_ceiling_step_id in out nocopy number
1408: ,c_organization_id in number default hr_api.g_number
1409: ,c_pay_basis_id in number default hr_api.g_number
1410: ,c_employment_category in varchar2 default hr_api.g_varchar2
1411: )
1412: return boolean is
1405: ,c_payroll_id in number default hr_api.g_number
1406: ,c_location_id in number default hr_api.g_number
1407: ,c_special_ceiling_step_id in out nocopy number
1408: ,c_organization_id in number default hr_api.g_number
1409: ,c_pay_basis_id in number default hr_api.g_number
1410: ,c_employment_category in varchar2 default hr_api.g_varchar2
1411: )
1412: return boolean is
1413: l_proc varchar2(72) := g_package||'process_row';
1406: ,c_location_id in number default hr_api.g_number
1407: ,c_special_ceiling_step_id in out nocopy number
1408: ,c_organization_id in number default hr_api.g_number
1409: ,c_pay_basis_id in number default hr_api.g_number
1410: ,c_employment_category in varchar2 default hr_api.g_varchar2
1411: )
1412: return boolean is
1413: l_proc varchar2(72) := g_package||'process_row';
1414: begin
1536: if l_effective_date_row then
1537: -- reset the first row flag
1538: l_effective_date_row := false;
1539: -- set all future row operations to a CORRECTION
1540: l_datetrack_update_mode := hr_api.g_correction;
1541: -- set the API out parameters for the first transaction
1542: p_object_version_number := l_asg_rec.object_version_number;
1543: p_special_ceiling_step_id := l_asg_rec.special_ceiling_step_id;
1544: p_effective_start_date := l_effective_start_date;
1586: -- b) to populate the l_validation_start_date which is used
1587: -- in determining the correct datetrack mode on an update operation
1588: per_asg_shd.lck
1589: (p_effective_date => l_constant_effective_date
1590: ,p_datetrack_mode => hr_api.g_correction
1591: ,p_assignment_id => p_assignment_id
1592: ,p_object_version_number => p_object_version_number
1593: ,p_validation_start_date => l_validation_start_date
1594: ,p_validation_end_date => l_validation_end_date);
1618: ,p_update_change_insert => l_update_change_insert);
1619: -- step 1.2
1620: if l_update then
1621: -- we can do an update
1622: l_datetrack_update_mode := hr_api.g_update;
1623: elsif l_update_change_insert then
1624: -- we can do an update change insert
1625: l_datetrack_update_mode := hr_api.g_update_change_insert;
1626: elsif (l_validation_start_date = l_constant_effective_date) and
1621: -- we can do an update
1622: l_datetrack_update_mode := hr_api.g_update;
1623: elsif l_update_change_insert then
1624: -- we can do an update change insert
1625: l_datetrack_update_mode := hr_api.g_update_change_insert;
1626: elsif (l_validation_start_date = l_constant_effective_date) and
1627: l_correction then
1628: -- we can only perform a correction
1629: l_datetrack_update_mode := hr_api.g_correction;
1625: l_datetrack_update_mode := hr_api.g_update_change_insert;
1626: elsif (l_validation_start_date = l_constant_effective_date) and
1627: l_correction then
1628: -- we can only perform a correction
1629: l_datetrack_update_mode := hr_api.g_correction;
1630: else
1631: -- we cannot perform an update due to a restriction within the APIs
1632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1633: hr_utility.set_message_token('PROCEDURE', l_proc);
1638: l_lck_start_date := l_constant_effective_date;
1639: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1640: -- set lock start date to start of time and the datetrack mode
1641: -- to CORRECTION
1642: l_lck_start_date := hr_api.g_sot;
1643: l_datetrack_update_mode := hr_api.g_correction;
1644: else
1645: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1646: -- so raise DT invalid mode error
1639: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1640: -- set lock start date to start of time and the datetrack mode
1641: -- to CORRECTION
1642: l_lck_start_date := hr_api.g_sot;
1643: l_datetrack_update_mode := hr_api.g_correction;
1644: else
1645: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1646: -- so raise DT invalid mode error
1647: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1698: --
1699: -- When in validation only mode raise the Validate_Enabled exception
1700: --
1701: if p_validate then
1702: raise hr_api.validate_enabled;
1703: end if;
1704: -- set the warning OUT parameters
1705: p_no_managers_warning := l_api_no_managers_warning;
1706: p_other_manager_warning := l_api_other_manager_warning;
1709: p_tax_district_changed_warning := l_api_tax_district_changed;
1710: --
1711: hr_utility.set_location(' Leaving:'||l_proc, 10);
1712: exception
1713: when hr_api.validate_enabled then
1714: --
1715: -- As the Validate_Enabled exception has been raised
1716: -- we must rollback to the savepoint
1717: --