APPS.CN_JOB_TITLE_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a7 JTF_VARCHAR2_TABLE_200

19: , a3 JTF_DATE_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_200
24: , a8 JTF_VARCHAR2_TABLE_200
25: , a9 JTF_VARCHAR2_TABLE_200
26: , a10 JTF_VARCHAR2_TABLE_200
27: , a11 JTF_VARCHAR2_TABLE_200

Line 24: , a8 JTF_VARCHAR2_TABLE_200

20: , a4 JTF_DATE_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_200
24: , a8 JTF_VARCHAR2_TABLE_200
25: , a9 JTF_VARCHAR2_TABLE_200
26: , a10 JTF_VARCHAR2_TABLE_200
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_VARCHAR2_TABLE_200

Line 25: , a9 JTF_VARCHAR2_TABLE_200

21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_200
24: , a8 JTF_VARCHAR2_TABLE_200
25: , a9 JTF_VARCHAR2_TABLE_200
26: , a10 JTF_VARCHAR2_TABLE_200
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200

Line 26: , a10 JTF_VARCHAR2_TABLE_200

22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_200
24: , a8 JTF_VARCHAR2_TABLE_200
25: , a9 JTF_VARCHAR2_TABLE_200
26: , a10 JTF_VARCHAR2_TABLE_200
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200

Line 27: , a11 JTF_VARCHAR2_TABLE_200

23: , a7 JTF_VARCHAR2_TABLE_200
24: , a8 JTF_VARCHAR2_TABLE_200
25: , a9 JTF_VARCHAR2_TABLE_200
26: , a10 JTF_VARCHAR2_TABLE_200
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200

Line 28: , a12 JTF_VARCHAR2_TABLE_200

24: , a8 JTF_VARCHAR2_TABLE_200
25: , a9 JTF_VARCHAR2_TABLE_200
26: , a10 JTF_VARCHAR2_TABLE_200
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200

Line 29: , a13 JTF_VARCHAR2_TABLE_200

25: , a9 JTF_VARCHAR2_TABLE_200
26: , a10 JTF_VARCHAR2_TABLE_200
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200

Line 30: , a14 JTF_VARCHAR2_TABLE_200

26: , a10 JTF_VARCHAR2_TABLE_200
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200

Line 31: , a15 JTF_VARCHAR2_TABLE_200

27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200
35: , a19 JTF_VARCHAR2_TABLE_200

Line 32: , a16 JTF_VARCHAR2_TABLE_200

28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200
35: , a19 JTF_VARCHAR2_TABLE_200
36: , a20 JTF_VARCHAR2_TABLE_200

Line 33: , a17 JTF_VARCHAR2_TABLE_200

29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200
35: , a19 JTF_VARCHAR2_TABLE_200
36: , a20 JTF_VARCHAR2_TABLE_200
37: , a21 JTF_VARCHAR2_TABLE_200

Line 34: , a18 JTF_VARCHAR2_TABLE_200

30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200
35: , a19 JTF_VARCHAR2_TABLE_200
36: , a20 JTF_VARCHAR2_TABLE_200
37: , a21 JTF_VARCHAR2_TABLE_200
38: , a22 JTF_NUMBER_TABLE

Line 35: , a19 JTF_VARCHAR2_TABLE_200

31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200
35: , a19 JTF_VARCHAR2_TABLE_200
36: , a20 JTF_VARCHAR2_TABLE_200
37: , a21 JTF_VARCHAR2_TABLE_200
38: , a22 JTF_NUMBER_TABLE
39: );

Line 36: , a20 JTF_VARCHAR2_TABLE_200

32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200
35: , a19 JTF_VARCHAR2_TABLE_200
36: , a20 JTF_VARCHAR2_TABLE_200
37: , a21 JTF_VARCHAR2_TABLE_200
38: , a22 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p3(t cn_job_title_pvt.job_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 37: , a21 JTF_VARCHAR2_TABLE_200

33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200
35: , a19 JTF_VARCHAR2_TABLE_200
36: , a20 JTF_VARCHAR2_TABLE_200
37: , a21 JTF_VARCHAR2_TABLE_200
38: , a22 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p3(t cn_job_title_pvt.job_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE

Line 47: , a7 out nocopy JTF_VARCHAR2_TABLE_200

43: , a3 out nocopy JTF_DATE_TABLE
44: , a4 out nocopy JTF_DATE_TABLE
45: , a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , a6 out nocopy JTF_VARCHAR2_TABLE_100
47: , a7 out nocopy JTF_VARCHAR2_TABLE_200
48: , a8 out nocopy JTF_VARCHAR2_TABLE_200
49: , a9 out nocopy JTF_VARCHAR2_TABLE_200
50: , a10 out nocopy JTF_VARCHAR2_TABLE_200
51: , a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 48: , a8 out nocopy JTF_VARCHAR2_TABLE_200

44: , a4 out nocopy JTF_DATE_TABLE
45: , a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , a6 out nocopy JTF_VARCHAR2_TABLE_100
47: , a7 out nocopy JTF_VARCHAR2_TABLE_200
48: , a8 out nocopy JTF_VARCHAR2_TABLE_200
49: , a9 out nocopy JTF_VARCHAR2_TABLE_200
50: , a10 out nocopy JTF_VARCHAR2_TABLE_200
51: , a11 out nocopy JTF_VARCHAR2_TABLE_200
52: , a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 49: , a9 out nocopy JTF_VARCHAR2_TABLE_200

45: , a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , a6 out nocopy JTF_VARCHAR2_TABLE_100
47: , a7 out nocopy JTF_VARCHAR2_TABLE_200
48: , a8 out nocopy JTF_VARCHAR2_TABLE_200
49: , a9 out nocopy JTF_VARCHAR2_TABLE_200
50: , a10 out nocopy JTF_VARCHAR2_TABLE_200
51: , a11 out nocopy JTF_VARCHAR2_TABLE_200
52: , a12 out nocopy JTF_VARCHAR2_TABLE_200
53: , a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 50: , a10 out nocopy JTF_VARCHAR2_TABLE_200

46: , a6 out nocopy JTF_VARCHAR2_TABLE_100
47: , a7 out nocopy JTF_VARCHAR2_TABLE_200
48: , a8 out nocopy JTF_VARCHAR2_TABLE_200
49: , a9 out nocopy JTF_VARCHAR2_TABLE_200
50: , a10 out nocopy JTF_VARCHAR2_TABLE_200
51: , a11 out nocopy JTF_VARCHAR2_TABLE_200
52: , a12 out nocopy JTF_VARCHAR2_TABLE_200
53: , a13 out nocopy JTF_VARCHAR2_TABLE_200
54: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 51: , a11 out nocopy JTF_VARCHAR2_TABLE_200

47: , a7 out nocopy JTF_VARCHAR2_TABLE_200
48: , a8 out nocopy JTF_VARCHAR2_TABLE_200
49: , a9 out nocopy JTF_VARCHAR2_TABLE_200
50: , a10 out nocopy JTF_VARCHAR2_TABLE_200
51: , a11 out nocopy JTF_VARCHAR2_TABLE_200
52: , a12 out nocopy JTF_VARCHAR2_TABLE_200
53: , a13 out nocopy JTF_VARCHAR2_TABLE_200
54: , a14 out nocopy JTF_VARCHAR2_TABLE_200
55: , a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 52: , a12 out nocopy JTF_VARCHAR2_TABLE_200

48: , a8 out nocopy JTF_VARCHAR2_TABLE_200
49: , a9 out nocopy JTF_VARCHAR2_TABLE_200
50: , a10 out nocopy JTF_VARCHAR2_TABLE_200
51: , a11 out nocopy JTF_VARCHAR2_TABLE_200
52: , a12 out nocopy JTF_VARCHAR2_TABLE_200
53: , a13 out nocopy JTF_VARCHAR2_TABLE_200
54: , a14 out nocopy JTF_VARCHAR2_TABLE_200
55: , a15 out nocopy JTF_VARCHAR2_TABLE_200
56: , a16 out nocopy JTF_VARCHAR2_TABLE_200

Line 53: , a13 out nocopy JTF_VARCHAR2_TABLE_200

49: , a9 out nocopy JTF_VARCHAR2_TABLE_200
50: , a10 out nocopy JTF_VARCHAR2_TABLE_200
51: , a11 out nocopy JTF_VARCHAR2_TABLE_200
52: , a12 out nocopy JTF_VARCHAR2_TABLE_200
53: , a13 out nocopy JTF_VARCHAR2_TABLE_200
54: , a14 out nocopy JTF_VARCHAR2_TABLE_200
55: , a15 out nocopy JTF_VARCHAR2_TABLE_200
56: , a16 out nocopy JTF_VARCHAR2_TABLE_200
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200

Line 54: , a14 out nocopy JTF_VARCHAR2_TABLE_200

50: , a10 out nocopy JTF_VARCHAR2_TABLE_200
51: , a11 out nocopy JTF_VARCHAR2_TABLE_200
52: , a12 out nocopy JTF_VARCHAR2_TABLE_200
53: , a13 out nocopy JTF_VARCHAR2_TABLE_200
54: , a14 out nocopy JTF_VARCHAR2_TABLE_200
55: , a15 out nocopy JTF_VARCHAR2_TABLE_200
56: , a16 out nocopy JTF_VARCHAR2_TABLE_200
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_200

Line 55: , a15 out nocopy JTF_VARCHAR2_TABLE_200

51: , a11 out nocopy JTF_VARCHAR2_TABLE_200
52: , a12 out nocopy JTF_VARCHAR2_TABLE_200
53: , a13 out nocopy JTF_VARCHAR2_TABLE_200
54: , a14 out nocopy JTF_VARCHAR2_TABLE_200
55: , a15 out nocopy JTF_VARCHAR2_TABLE_200
56: , a16 out nocopy JTF_VARCHAR2_TABLE_200
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_200
59: , a19 out nocopy JTF_VARCHAR2_TABLE_200

Line 56: , a16 out nocopy JTF_VARCHAR2_TABLE_200

52: , a12 out nocopy JTF_VARCHAR2_TABLE_200
53: , a13 out nocopy JTF_VARCHAR2_TABLE_200
54: , a14 out nocopy JTF_VARCHAR2_TABLE_200
55: , a15 out nocopy JTF_VARCHAR2_TABLE_200
56: , a16 out nocopy JTF_VARCHAR2_TABLE_200
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_200
59: , a19 out nocopy JTF_VARCHAR2_TABLE_200
60: , a20 out nocopy JTF_VARCHAR2_TABLE_200

Line 57: , a17 out nocopy JTF_VARCHAR2_TABLE_200

53: , a13 out nocopy JTF_VARCHAR2_TABLE_200
54: , a14 out nocopy JTF_VARCHAR2_TABLE_200
55: , a15 out nocopy JTF_VARCHAR2_TABLE_200
56: , a16 out nocopy JTF_VARCHAR2_TABLE_200
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_200
59: , a19 out nocopy JTF_VARCHAR2_TABLE_200
60: , a20 out nocopy JTF_VARCHAR2_TABLE_200
61: , a21 out nocopy JTF_VARCHAR2_TABLE_200

Line 58: , a18 out nocopy JTF_VARCHAR2_TABLE_200

54: , a14 out nocopy JTF_VARCHAR2_TABLE_200
55: , a15 out nocopy JTF_VARCHAR2_TABLE_200
56: , a16 out nocopy JTF_VARCHAR2_TABLE_200
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_200
59: , a19 out nocopy JTF_VARCHAR2_TABLE_200
60: , a20 out nocopy JTF_VARCHAR2_TABLE_200
61: , a21 out nocopy JTF_VARCHAR2_TABLE_200
62: , a22 out nocopy JTF_NUMBER_TABLE

Line 59: , a19 out nocopy JTF_VARCHAR2_TABLE_200

55: , a15 out nocopy JTF_VARCHAR2_TABLE_200
56: , a16 out nocopy JTF_VARCHAR2_TABLE_200
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_200
59: , a19 out nocopy JTF_VARCHAR2_TABLE_200
60: , a20 out nocopy JTF_VARCHAR2_TABLE_200
61: , a21 out nocopy JTF_VARCHAR2_TABLE_200
62: , a22 out nocopy JTF_NUMBER_TABLE
63: );

Line 60: , a20 out nocopy JTF_VARCHAR2_TABLE_200

56: , a16 out nocopy JTF_VARCHAR2_TABLE_200
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_200
59: , a19 out nocopy JTF_VARCHAR2_TABLE_200
60: , a20 out nocopy JTF_VARCHAR2_TABLE_200
61: , a21 out nocopy JTF_VARCHAR2_TABLE_200
62: , a22 out nocopy JTF_NUMBER_TABLE
63: );
64:

Line 61: , a21 out nocopy JTF_VARCHAR2_TABLE_200

57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_200
59: , a19 out nocopy JTF_VARCHAR2_TABLE_200
60: , a20 out nocopy JTF_VARCHAR2_TABLE_200
61: , a21 out nocopy JTF_VARCHAR2_TABLE_200
62: , a22 out nocopy JTF_NUMBER_TABLE
63: );
64:
65: procedure create_job_role(p_api_version NUMBER

Line 136: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200

132: , p1_a3 out nocopy JTF_DATE_TABLE
133: , p1_a4 out nocopy JTF_DATE_TABLE
134: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
137: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
138: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200
139: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200
140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 137: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200

133: , p1_a4 out nocopy JTF_DATE_TABLE
134: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
137: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
138: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200
139: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200
140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200
141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 138: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200

134: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
137: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
138: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200
139: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200
140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200
141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200
142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 139: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200

135: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
137: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
138: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200
139: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200
140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200
141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200
142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200
143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200

136: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
137: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
138: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200
139: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200
140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200
141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200
142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200
143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200
144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200

137: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
138: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200
139: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200
140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200
141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200
142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200
143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200
144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200
145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200

Line 142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200

138: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200
139: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200
140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200
141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200
142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200
143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200
144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200
145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200
146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200

Line 143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200

139: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200
140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200
141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200
142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200
143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200
144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200
145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200
146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
147: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200

Line 144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200

140: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200
141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200
142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200
143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200
144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200
145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200
146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
147: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
148: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200

Line 145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200

141: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200
142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200
143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200
144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200
145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200
146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
147: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
148: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
149: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200

Line 146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200

142: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200
143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200
144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200
145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200
146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
147: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
148: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
149: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200
150: , p1_a21 out nocopy JTF_VARCHAR2_TABLE_200

Line 147: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200

143: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200
144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200
145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200
146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
147: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
148: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
149: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200
150: , p1_a21 out nocopy JTF_VARCHAR2_TABLE_200
151: , p1_a22 out nocopy JTF_NUMBER_TABLE

Line 148: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200

144: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200
145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200
146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
147: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
148: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
149: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200
150: , p1_a21 out nocopy JTF_VARCHAR2_TABLE_200
151: , p1_a22 out nocopy JTF_NUMBER_TABLE
152: );

Line 149: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200

145: , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200
146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
147: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
148: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
149: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200
150: , p1_a21 out nocopy JTF_VARCHAR2_TABLE_200
151: , p1_a22 out nocopy JTF_NUMBER_TABLE
152: );
153: procedure get_job_titles(p_range_low NUMBER

Line 150: , p1_a21 out nocopy JTF_VARCHAR2_TABLE_200

146: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
147: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
148: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
149: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200
150: , p1_a21 out nocopy JTF_VARCHAR2_TABLE_200
151: , p1_a22 out nocopy JTF_NUMBER_TABLE
152: );
153: procedure get_job_titles(p_range_low NUMBER
154: , p_range_high NUMBER