[Home] [Help]
PACKAGE: APPS.JTF_TERR_JSP_LOV_RECS_PUB_W
Source
1 package jtf_terr_jsp_lov_recs_pub_w as
2 /* $Header: jtfwjlvs.pls 120.0 2005/06/02 18:23:17 appldev ship $ */
3 procedure rosetta_table_copy_in_p2(t OUT NOCOPY jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000
4 , a1 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 , a10 JTF_VARCHAR2_TABLE_2000
14 , a11 JTF_VARCHAR2_TABLE_2000
15 , a12 JTF_VARCHAR2_TABLE_2000
16 , a13 JTF_VARCHAR2_TABLE_2000
17 , a14 JTF_VARCHAR2_TABLE_2000
18 , a15 JTF_VARCHAR2_TABLE_2000
19 , a16 JTF_VARCHAR2_TABLE_2000
20 , a17 JTF_VARCHAR2_TABLE_2000
21 , a18 JTF_VARCHAR2_TABLE_2000
22 , a19 JTF_VARCHAR2_TABLE_2000
23 );
24 procedure rosetta_table_copy_out_p2(t jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
25 , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
26 , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
27 , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
28 , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
29 , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
30 , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
31 , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
32 , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
33 , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
34 , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
35 , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
36 , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
37 , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
38 , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
39 , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
40 , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
41 , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
42 , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
43 , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
44 );
45
46 procedure rosetta_table_copy_in_p3(t OUT NOCOPY jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type, a0 JTF_NUMBER_TABLE
47 , a1 JTF_VARCHAR2_TABLE_100
48 , a2 JTF_VARCHAR2_TABLE_100
49 );
50 procedure rosetta_table_copy_out_p3(t jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
51 , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52 , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53 );
54
55 procedure get_lov_records(p_range_low NUMBER
56 , p_range_high NUMBER
57 , p_record_group_name VARCHAR2
58 , p3_a0 VARCHAR2
59 , p3_a1 VARCHAR2
60 , p3_a2 VARCHAR2
61 , p3_a3 VARCHAR2
62 , p3_a4 VARCHAR2
63 , p3_a5 VARCHAR2
64 , p3_a6 VARCHAR2
65 , p3_a7 VARCHAR2
66 , p3_a8 VARCHAR2
67 , p3_a9 VARCHAR2
68 , p3_a10 VARCHAR2
69 , p3_a11 VARCHAR2
70 , p3_a12 VARCHAR2
71 , p3_a13 VARCHAR2
72 , p3_a14 VARCHAR2
73 , p3_a15 VARCHAR2
74 , p3_a16 VARCHAR2
75 , p3_a17 VARCHAR2
76 , p3_a18 VARCHAR2
77 , p3_a19 VARCHAR2
78 , x_total_rows OUT NOCOPY NUMBER
79 , x_more_data_flag OUT NOCOPY VARCHAR2
80 , x_lov_ak_region OUT NOCOPY VARCHAR2
81 , p7_a0 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
82 , p7_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
83 , p7_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
84 , p7_a3 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
85 , p7_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
86 , p7_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
87 , p7_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
88 , p7_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
89 , p7_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
90 , p7_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
91 , p7_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
92 , p7_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
93 , p7_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
94 , p7_a13 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
95 , p7_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
96 , p7_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
97 , p7_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
98 , p7_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
99 , p7_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
100 , p7_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
101 , p8_a0 OUT NOCOPY JTF_NUMBER_TABLE
102 , p8_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103 , p8_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
104 );
105 end jtf_terr_jsp_lov_recs_pub_w;