APPS.JTF_RS_JSP_LOV_RECS_PUB_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000

1: package jtf_rs_jsp_lov_recs_pub_w AUTHID CURRENT_USER as
2: /* $Header: jtfrsjws.pls 120.0 2005/05/11 08:20:26 appldev ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000

Line 5: , a2 JTF_VARCHAR2_TABLE_2000

1: package jtf_rs_jsp_lov_recs_pub_w AUTHID CURRENT_USER as
2: /* $Header: jtfrsjws.pls 120.0 2005/05/11 08:20:26 appldev ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000

Line 6: , a3 JTF_VARCHAR2_TABLE_2000

2: /* $Header: jtfrsjws.pls 120.0 2005/05/11 08:20:26 appldev ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_2000

Line 7: , a4 JTF_VARCHAR2_TABLE_2000

3: procedure rosetta_table_copy_in_p2(t out nocopy jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_2000

Line 8: , a5 JTF_VARCHAR2_TABLE_2000

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000

Line 9: , a6 JTF_VARCHAR2_TABLE_2000

5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: );

Line 10: , a7 JTF_VARCHAR2_TABLE_2000

6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: );
14: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000

Line 11: , a8 JTF_VARCHAR2_TABLE_2000

7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: );
14: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_VARCHAR2_TABLE_2000

8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: );
14: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

Line 14: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000

10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: );
14: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
17: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 16: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

12: , a9 JTF_VARCHAR2_TABLE_2000
13: );
14: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
17: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 17: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

13: );
14: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
17: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 18: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

14: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
17: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
22: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 19: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
17: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
22: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
23: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

Line 20: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

16: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
17: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
22: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
23: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
24: );

Line 21: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

17: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
22: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
23: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
24: );
25:

Line 22: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

18: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
22: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
23: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
24: );
25:
26: procedure get_lov_records(p_range_low NUMBER

Line 23: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

19: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
22: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
23: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
24: );
25:
26: procedure get_lov_records(p_range_low NUMBER
27: , p_range_high NUMBER

Line 34: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_2000

30: , p_in_filter2 VARCHAR2
31: , x_total_rows out nocopy NUMBER
32: , x_more_data_flag out nocopy VARCHAR2
33: , x_lov_ak_region out nocopy VARCHAR2
34: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_2000
35: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_2000
37: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_2000
38: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 36: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_2000

32: , x_more_data_flag out nocopy VARCHAR2
33: , x_lov_ak_region out nocopy VARCHAR2
34: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_2000
35: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_2000
37: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_2000
38: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
39: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_2000
40: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 37: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_2000

33: , x_lov_ak_region out nocopy VARCHAR2
34: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_2000
35: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_2000
37: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_2000
38: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
39: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_2000
40: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_2000
41: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 38: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000

34: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_2000
35: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_2000
37: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_2000
38: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
39: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_2000
40: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_2000
41: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
42: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 39: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_2000

35: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_2000
37: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_2000
38: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
39: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_2000
40: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_2000
41: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
42: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
43: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000

Line 40: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_2000

36: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_2000
37: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_2000
38: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
39: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_2000
40: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_2000
41: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
42: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
43: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
44: , x_ext_col_cnt out nocopy NUMBER

Line 41: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000

37: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_2000
38: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
39: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_2000
40: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_2000
41: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
42: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
43: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
44: , x_ext_col_cnt out nocopy NUMBER
45: , p3_a0 VARCHAR2 := fnd_api.g_miss_char

Line 42: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000

38: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
39: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_2000
40: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_2000
41: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
42: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
43: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
44: , x_ext_col_cnt out nocopy NUMBER
45: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
46: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

Line 43: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000

39: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_2000
40: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_2000
41: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
42: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
43: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
44: , x_ext_col_cnt out nocopy NUMBER
45: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
46: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
47: , p3_a2 VARCHAR2 := fnd_api.g_miss_char