DBA Data[Home] [Help]

APPS.CN_JOB_TITLE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy cn_job_title_pvt.job_title_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t cn_job_title_pvt.job_title_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_VARCHAR2_TABLE_300
11: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 13: , a4 out nocopy JTF_VARCHAR2_TABLE_100

9: procedure rosetta_table_copy_out_p1(t cn_job_title_pvt.job_title_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_VARCHAR2_TABLE_300
11: , a2 out nocopy JTF_VARCHAR2_TABLE_300
12: , a3 out nocopy JTF_NUMBER_TABLE
13: , a4 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy cn_job_title_pvt.job_role_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE

Line 21: , a5 JTF_VARCHAR2_TABLE_100

17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
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

Line 22: , a6 JTF_VARCHAR2_TABLE_100

18: , a2 JTF_NUMBER_TABLE
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

Line 45: , a5 out nocopy JTF_VARCHAR2_TABLE_100

41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_NUMBER_TABLE
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

Line 46: , a6 out nocopy JTF_VARCHAR2_TABLE_100

42: , a2 out nocopy JTF_NUMBER_TABLE
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

Line 134: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

130: , p1_a1 out nocopy JTF_NUMBER_TABLE
131: , p1_a2 out nocopy JTF_NUMBER_TABLE
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

Line 135: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100

131: , p1_a2 out nocopy JTF_NUMBER_TABLE
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

Line 162: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

158: , p5_a0 out nocopy JTF_NUMBER_TABLE
159: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_300
160: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_300
161: , p5_a3 out nocopy JTF_NUMBER_TABLE
162: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
163: );
164: procedure get_all_job_titles(p0_a0 out nocopy JTF_NUMBER_TABLE
165: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300
166: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 168: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100

164: procedure get_all_job_titles(p0_a0 out nocopy JTF_NUMBER_TABLE
165: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300
166: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300
167: , p0_a3 out nocopy JTF_NUMBER_TABLE
168: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100
169: );
170: procedure get_job_roles(p0_a0 out nocopy JTF_NUMBER_TABLE
171: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300
172: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 174: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100

170: procedure get_job_roles(p0_a0 out nocopy JTF_NUMBER_TABLE
171: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300
172: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300
173: , p0_a3 out nocopy JTF_NUMBER_TABLE
174: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100
175: );
176: end cn_job_title_pvt_w;