DBA Data[Home] [Help]

APPS.CN_JOB_TITLE_PVT dependencies on CN_JOB_ROLES

Line 14: (job_role_id cn_job_roles.job_role_id%type,

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,

Line 15: job_title_id cn_job_roles.job_title_id%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,

Line 16: role_id cn_job_roles.role_id%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,

Line 17: start_date cn_job_roles.start_date%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,

Line 18: end_date cn_job_roles.end_date%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,

Line 19: default_flag cn_job_roles.default_flag%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,

Line 20: attribute_category cn_job_roles.attribute_category%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,

Line 21: attribute1 cn_job_roles.attribute1%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,

Line 22: attribute2 cn_job_roles.attribute2%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,

Line 23: attribute3 cn_job_roles.attribute3%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,

Line 24: attribute4 cn_job_roles.attribute4%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,

Line 25: attribute5 cn_job_roles.attribute5%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,

Line 26: attribute6 cn_job_roles.attribute6%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,

Line 27: attribute7 cn_job_roles.attribute7%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,

Line 28: attribute8 cn_job_roles.attribute8%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,

Line 29: attribute9 cn_job_roles.attribute9%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,

Line 30: attribute10 cn_job_roles.attribute10%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,

Line 31: attribute11 cn_job_roles.attribute11%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,

Line 32: attribute12 cn_job_roles.attribute12%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);

Line 33: attribute13 cn_job_roles.attribute13%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:

Line 34: attribute14 cn_job_roles.attribute14%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:
38: TYPE job_role_tbl_type IS table of job_role_rec_type

Line 35: attribute15 cn_job_roles.attribute15%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;

Line 36: object_version_number cn_job_roles.object_version_number%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;
40:

Line 61: x_job_role_id OUT NOCOPY cn_job_roles.job_role_id%type);

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.

Line 98: p_job_role_id IN cn_job_roles.job_role_id%type,

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);

Line 99: p_object_version_number IN cn_job_roles.object_version_number%type,

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: