DBA Data[Home] [Help]

APPS.CN_JOB_TITLE_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 4: , a1 JTF_VARCHAR2_TABLE_300

1: package cn_job_title_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwjobs.pls 115.6 2002/11/25 22:24:29 nkodkani ship $ */
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: );

Line 5: , a2 JTF_VARCHAR2_TABLE_300

1: package cn_job_title_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwjobs.pls 115.6 2002/11/25 22:24:29 nkodkani ship $ */
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

Line 10: , a1 out nocopy 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
12: , a3 out nocopy JTF_NUMBER_TABLE
13: , a4 out nocopy JTF_VARCHAR2_TABLE_100
14: );

Line 11: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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
12: , a3 out nocopy JTF_NUMBER_TABLE
13: , a4 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:

Line 159: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_300

155: , p_search_name VARCHAR2
156: , p_search_code VARCHAR2
157: , x_total_rows out nocopy NUMBER
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: );

Line 160: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_300

156: , p_search_code VARCHAR2
157: , x_total_rows out nocopy NUMBER
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

Line 165: , p0_a1 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
167: , p0_a3 out nocopy JTF_NUMBER_TABLE
168: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100
169: );

Line 166: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 171: , p0_a1 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
173: , p0_a3 out nocopy JTF_NUMBER_TABLE
174: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100
175: );

Line 172: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300

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