eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_JOB_TITLE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_job_title_pvt.job_title_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 6: , a3 JTF_NUMBER_TABLE

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
10: , a1 out nocopy JTF_VARCHAR2_TABLE_300

Line 9: procedure rosetta_table_copy_out_p1(t cn_job_title_pvt.job_title_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 12: , a3 out nocopy JTF_NUMBER_TABLE

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:
16: procedure rosetta_table_copy_in_p3(t out nocopy cn_job_title_pvt.job_role_tbl_type, a0 JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p3(t out nocopy cn_job_title_pvt.job_role_tbl_type, a0 JTF_NUMBER_TABLE

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
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_DATE_TABLE

Line 17: , a1 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
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100

Line 18: , a2 JTF_NUMBER_TABLE

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

Line 38: , a22 JTF_NUMBER_TABLE

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

Line 40: procedure rosetta_table_copy_out_p3(t cn_job_title_pvt.job_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_DATE_TABLE
44: , a4 out nocopy JTF_DATE_TABLE

Line 41: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 42: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 62: , a22 out nocopy JTF_NUMBER_TABLE

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
66: , p_init_msg_list VARCHAR2

Line 129: , p1_a0 out nocopy JTF_NUMBER_TABLE

125: , x_msg_count out nocopy NUMBER
126: , x_msg_data out nocopy VARCHAR2
127: );
128: procedure get_job_details(p_job_title_id NUMBER
129: , p1_a0 out nocopy JTF_NUMBER_TABLE
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

Line 130: , p1_a1 out nocopy JTF_NUMBER_TABLE

126: , x_msg_data out nocopy VARCHAR2
127: );
128: procedure get_job_details(p_job_title_id NUMBER
129: , p1_a0 out nocopy JTF_NUMBER_TABLE
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

Line 131: , p1_a2 out nocopy JTF_NUMBER_TABLE

127: );
128: procedure get_job_details(p_job_title_id NUMBER
129: , p1_a0 out nocopy JTF_NUMBER_TABLE
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

Line 151: , p1_a22 out nocopy JTF_NUMBER_TABLE

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
155: , p_search_name VARCHAR2

Line 158: , p5_a0 out nocopy JTF_NUMBER_TABLE

154: , p_range_high NUMBER
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

Line 161: , p5_a3 out nocopy JTF_NUMBER_TABLE

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
165: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300

Line 164: procedure get_all_job_titles(p0_a0 out nocopy JTF_NUMBER_TABLE

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
167: , p0_a3 out nocopy JTF_NUMBER_TABLE
168: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , p0_a3 out nocopy JTF_NUMBER_TABLE

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
171: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300

Line 170: procedure get_job_roles(p0_a0 out nocopy JTF_NUMBER_TABLE

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
173: , p0_a3 out nocopy JTF_NUMBER_TABLE
174: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 173: , p0_a3 out nocopy JTF_NUMBER_TABLE

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;