10: TYPE job_title_tbl_type IS table OF job_title_rec_type
11: INDEX BY binary_integer;
12:
13: TYPE job_role_rec_type IS record
14: (job_role_id cn_job_roles.job_role_id%type,
15: job_title_id cn_job_roles.job_title_id%type,
16: role_id cn_job_roles.role_id%type,
17: start_date cn_job_roles.start_date%type,
18: end_date cn_job_roles.end_date%type,
11: INDEX BY binary_integer;
12:
13: TYPE job_role_rec_type IS record
14: (job_role_id cn_job_roles.job_role_id%type,
15: job_title_id cn_job_roles.job_title_id%type,
16: role_id cn_job_roles.role_id%type,
17: start_date cn_job_roles.start_date%type,
18: end_date cn_job_roles.end_date%type,
19: default_flag cn_job_roles.default_flag%type,
12:
13: TYPE job_role_rec_type IS record
14: (job_role_id cn_job_roles.job_role_id%type,
15: job_title_id cn_job_roles.job_title_id%type,
16: role_id cn_job_roles.role_id%type,
17: start_date cn_job_roles.start_date%type,
18: end_date cn_job_roles.end_date%type,
19: default_flag cn_job_roles.default_flag%type,
20: attribute_category cn_job_roles.attribute_category%type,
13: TYPE job_role_rec_type IS record
14: (job_role_id cn_job_roles.job_role_id%type,
15: job_title_id cn_job_roles.job_title_id%type,
16: role_id cn_job_roles.role_id%type,
17: start_date cn_job_roles.start_date%type,
18: end_date cn_job_roles.end_date%type,
19: default_flag cn_job_roles.default_flag%type,
20: attribute_category cn_job_roles.attribute_category%type,
21: attribute1 cn_job_roles.attribute1%type,
14: (job_role_id cn_job_roles.job_role_id%type,
15: job_title_id cn_job_roles.job_title_id%type,
16: role_id cn_job_roles.role_id%type,
17: start_date cn_job_roles.start_date%type,
18: end_date cn_job_roles.end_date%type,
19: default_flag cn_job_roles.default_flag%type,
20: attribute_category cn_job_roles.attribute_category%type,
21: attribute1 cn_job_roles.attribute1%type,
22: attribute2 cn_job_roles.attribute2%type,
15: job_title_id cn_job_roles.job_title_id%type,
16: role_id cn_job_roles.role_id%type,
17: start_date cn_job_roles.start_date%type,
18: end_date cn_job_roles.end_date%type,
19: default_flag cn_job_roles.default_flag%type,
20: attribute_category cn_job_roles.attribute_category%type,
21: attribute1 cn_job_roles.attribute1%type,
22: attribute2 cn_job_roles.attribute2%type,
23: attribute3 cn_job_roles.attribute3%type,
16: role_id cn_job_roles.role_id%type,
17: start_date cn_job_roles.start_date%type,
18: end_date cn_job_roles.end_date%type,
19: default_flag cn_job_roles.default_flag%type,
20: attribute_category cn_job_roles.attribute_category%type,
21: attribute1 cn_job_roles.attribute1%type,
22: attribute2 cn_job_roles.attribute2%type,
23: attribute3 cn_job_roles.attribute3%type,
24: attribute4 cn_job_roles.attribute4%type,
17: start_date cn_job_roles.start_date%type,
18: end_date cn_job_roles.end_date%type,
19: default_flag cn_job_roles.default_flag%type,
20: attribute_category cn_job_roles.attribute_category%type,
21: attribute1 cn_job_roles.attribute1%type,
22: attribute2 cn_job_roles.attribute2%type,
23: attribute3 cn_job_roles.attribute3%type,
24: attribute4 cn_job_roles.attribute4%type,
25: attribute5 cn_job_roles.attribute5%type,
18: end_date cn_job_roles.end_date%type,
19: default_flag cn_job_roles.default_flag%type,
20: attribute_category cn_job_roles.attribute_category%type,
21: attribute1 cn_job_roles.attribute1%type,
22: attribute2 cn_job_roles.attribute2%type,
23: attribute3 cn_job_roles.attribute3%type,
24: attribute4 cn_job_roles.attribute4%type,
25: attribute5 cn_job_roles.attribute5%type,
26: attribute6 cn_job_roles.attribute6%type,
19: default_flag cn_job_roles.default_flag%type,
20: attribute_category cn_job_roles.attribute_category%type,
21: attribute1 cn_job_roles.attribute1%type,
22: attribute2 cn_job_roles.attribute2%type,
23: attribute3 cn_job_roles.attribute3%type,
24: attribute4 cn_job_roles.attribute4%type,
25: attribute5 cn_job_roles.attribute5%type,
26: attribute6 cn_job_roles.attribute6%type,
27: attribute7 cn_job_roles.attribute7%type,
20: attribute_category cn_job_roles.attribute_category%type,
21: attribute1 cn_job_roles.attribute1%type,
22: attribute2 cn_job_roles.attribute2%type,
23: attribute3 cn_job_roles.attribute3%type,
24: attribute4 cn_job_roles.attribute4%type,
25: attribute5 cn_job_roles.attribute5%type,
26: attribute6 cn_job_roles.attribute6%type,
27: attribute7 cn_job_roles.attribute7%type,
28: attribute8 cn_job_roles.attribute8%type,
21: attribute1 cn_job_roles.attribute1%type,
22: attribute2 cn_job_roles.attribute2%type,
23: attribute3 cn_job_roles.attribute3%type,
24: attribute4 cn_job_roles.attribute4%type,
25: attribute5 cn_job_roles.attribute5%type,
26: attribute6 cn_job_roles.attribute6%type,
27: attribute7 cn_job_roles.attribute7%type,
28: attribute8 cn_job_roles.attribute8%type,
29: attribute9 cn_job_roles.attribute9%type,
22: attribute2 cn_job_roles.attribute2%type,
23: attribute3 cn_job_roles.attribute3%type,
24: attribute4 cn_job_roles.attribute4%type,
25: attribute5 cn_job_roles.attribute5%type,
26: attribute6 cn_job_roles.attribute6%type,
27: attribute7 cn_job_roles.attribute7%type,
28: attribute8 cn_job_roles.attribute8%type,
29: attribute9 cn_job_roles.attribute9%type,
30: attribute10 cn_job_roles.attribute10%type,
23: attribute3 cn_job_roles.attribute3%type,
24: attribute4 cn_job_roles.attribute4%type,
25: attribute5 cn_job_roles.attribute5%type,
26: attribute6 cn_job_roles.attribute6%type,
27: attribute7 cn_job_roles.attribute7%type,
28: attribute8 cn_job_roles.attribute8%type,
29: attribute9 cn_job_roles.attribute9%type,
30: attribute10 cn_job_roles.attribute10%type,
31: attribute11 cn_job_roles.attribute11%type,
24: attribute4 cn_job_roles.attribute4%type,
25: attribute5 cn_job_roles.attribute5%type,
26: attribute6 cn_job_roles.attribute6%type,
27: attribute7 cn_job_roles.attribute7%type,
28: attribute8 cn_job_roles.attribute8%type,
29: attribute9 cn_job_roles.attribute9%type,
30: attribute10 cn_job_roles.attribute10%type,
31: attribute11 cn_job_roles.attribute11%type,
32: attribute12 cn_job_roles.attribute12%type,
25: attribute5 cn_job_roles.attribute5%type,
26: attribute6 cn_job_roles.attribute6%type,
27: attribute7 cn_job_roles.attribute7%type,
28: attribute8 cn_job_roles.attribute8%type,
29: attribute9 cn_job_roles.attribute9%type,
30: attribute10 cn_job_roles.attribute10%type,
31: attribute11 cn_job_roles.attribute11%type,
32: attribute12 cn_job_roles.attribute12%type,
33: attribute13 cn_job_roles.attribute13%type,
26: attribute6 cn_job_roles.attribute6%type,
27: attribute7 cn_job_roles.attribute7%type,
28: attribute8 cn_job_roles.attribute8%type,
29: attribute9 cn_job_roles.attribute9%type,
30: attribute10 cn_job_roles.attribute10%type,
31: attribute11 cn_job_roles.attribute11%type,
32: attribute12 cn_job_roles.attribute12%type,
33: attribute13 cn_job_roles.attribute13%type,
34: attribute14 cn_job_roles.attribute14%type,
27: attribute7 cn_job_roles.attribute7%type,
28: attribute8 cn_job_roles.attribute8%type,
29: attribute9 cn_job_roles.attribute9%type,
30: attribute10 cn_job_roles.attribute10%type,
31: attribute11 cn_job_roles.attribute11%type,
32: attribute12 cn_job_roles.attribute12%type,
33: attribute13 cn_job_roles.attribute13%type,
34: attribute14 cn_job_roles.attribute14%type,
35: attribute15 cn_job_roles.attribute15%type,
28: attribute8 cn_job_roles.attribute8%type,
29: attribute9 cn_job_roles.attribute9%type,
30: attribute10 cn_job_roles.attribute10%type,
31: attribute11 cn_job_roles.attribute11%type,
32: attribute12 cn_job_roles.attribute12%type,
33: attribute13 cn_job_roles.attribute13%type,
34: attribute14 cn_job_roles.attribute14%type,
35: attribute15 cn_job_roles.attribute15%type,
36: object_version_number cn_job_roles.object_version_number%type);
29: attribute9 cn_job_roles.attribute9%type,
30: attribute10 cn_job_roles.attribute10%type,
31: attribute11 cn_job_roles.attribute11%type,
32: attribute12 cn_job_roles.attribute12%type,
33: attribute13 cn_job_roles.attribute13%type,
34: attribute14 cn_job_roles.attribute14%type,
35: attribute15 cn_job_roles.attribute15%type,
36: object_version_number cn_job_roles.object_version_number%type);
37:
30: attribute10 cn_job_roles.attribute10%type,
31: attribute11 cn_job_roles.attribute11%type,
32: attribute12 cn_job_roles.attribute12%type,
33: attribute13 cn_job_roles.attribute13%type,
34: attribute14 cn_job_roles.attribute14%type,
35: attribute15 cn_job_roles.attribute15%type,
36: object_version_number cn_job_roles.object_version_number%type);
37:
38: TYPE job_role_tbl_type IS table of job_role_rec_type
31: attribute11 cn_job_roles.attribute11%type,
32: attribute12 cn_job_roles.attribute12%type,
33: attribute13 cn_job_roles.attribute13%type,
34: attribute14 cn_job_roles.attribute14%type,
35: attribute15 cn_job_roles.attribute15%type,
36: object_version_number cn_job_roles.object_version_number%type);
37:
38: TYPE job_role_tbl_type IS table of job_role_rec_type
39: INDEX BY binary_integer;
32: attribute12 cn_job_roles.attribute12%type,
33: attribute13 cn_job_roles.attribute13%type,
34: attribute14 cn_job_roles.attribute14%type,
35: attribute15 cn_job_roles.attribute15%type,
36: object_version_number cn_job_roles.object_version_number%type);
37:
38: TYPE job_role_tbl_type IS table of job_role_rec_type
39: INDEX BY binary_integer;
40:
57: p_rec IN job_role_rec_type,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61: x_job_role_id OUT NOCOPY cn_job_roles.job_role_id%type);
62:
63: -- Start of comments
64: -- API name : Update_Job_Role - Private.
65: -- Pre-reqs : None.
94: (p_api_version IN NUMBER, -- required
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE,
97: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98: p_job_role_id IN cn_job_roles.job_role_id%type,
99: p_object_version_number IN cn_job_roles.object_version_number%type,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2);
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE,
97: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98: p_job_role_id IN cn_job_roles.job_role_id%type,
99: p_object_version_number IN cn_job_roles.object_version_number%type,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2);
103: