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.AMV_SEARCH_PVT_W dependencies on JTF_NUMBER_TABLE

Line 6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);

2: /* $Header: amvwsers.pls 120.2 2005/06/30 08:43 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100

Line 7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);

3: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: );

Line 9: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE

5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 12: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE

8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE

12: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 20: , a4 JTF_NUMBER_TABLE

16: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_VARCHAR2_TABLE_100
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 22: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE

18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_VARCHAR2_TABLE_100
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_VARCHAR2_TABLE_100
26: , a4 out nocopy JTF_NUMBER_TABLE

Line 26: , a4 out nocopy JTF_NUMBER_TABLE

22: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_VARCHAR2_TABLE_100
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_VARCHAR2_TABLE_100
26: , a4 out nocopy JTF_NUMBER_TABLE
27: );
28:
29: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE
30: , a1 JTF_VARCHAR2_TABLE_100

Line 29: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE

25: , a3 out nocopy JTF_VARCHAR2_TABLE_100
26: , a4 out nocopy JTF_NUMBER_TABLE
27: );
28:
29: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE
30: , a1 JTF_VARCHAR2_TABLE_100
31: , a2 JTF_VARCHAR2_TABLE_100
32: , a3 JTF_NUMBER_TABLE
33: , a4 JTF_VARCHAR2_TABLE_100

Line 32: , a3 JTF_NUMBER_TABLE

28:
29: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE
30: , a1 JTF_VARCHAR2_TABLE_100
31: , a2 JTF_VARCHAR2_TABLE_100
32: , a3 JTF_NUMBER_TABLE
33: , a4 JTF_VARCHAR2_TABLE_100
34: , a5 JTF_VARCHAR2_TABLE_100
35: , a6 JTF_VARCHAR2_TABLE_100
36: , a7 JTF_NUMBER_TABLE

Line 36: , a7 JTF_NUMBER_TABLE

32: , a3 JTF_NUMBER_TABLE
33: , a4 JTF_VARCHAR2_TABLE_100
34: , a5 JTF_VARCHAR2_TABLE_100
35: , a6 JTF_VARCHAR2_TABLE_100
36: , a7 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE

34: , a5 JTF_VARCHAR2_TABLE_100
35: , a6 JTF_VARCHAR2_TABLE_100
36: , a7 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 41: , a3 out nocopy JTF_NUMBER_TABLE

37: );
38: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE

Line 45: , a7 out nocopy JTF_NUMBER_TABLE

41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: );
47:
48: procedure rosetta_table_copy_in_p11(t out nocopy amv_search_pvt.amv_searchpar_varray_type, a0 JTF_VARCHAR2_TABLE_100
49: , a1 JTF_VARCHAR2_TABLE_400

Line 58: , a3 JTF_NUMBER_TABLE

54:
55: procedure rosetta_table_copy_in_p13(t out nocopy amv_search_pvt.amv_searchres_varray_type, a0 JTF_VARCHAR2_TABLE_300
56: , a1 JTF_VARCHAR2_TABLE_2000
57: , a2 JTF_VARCHAR2_TABLE_4000
58: , a3 JTF_NUMBER_TABLE
59: , a4 JTF_NUMBER_TABLE
60: , a5 JTF_VARCHAR2_TABLE_100
61: , a6 JTF_VARCHAR2_TABLE_300
62: , a7 JTF_VARCHAR2_TABLE_300

Line 59: , a4 JTF_NUMBER_TABLE

55: procedure rosetta_table_copy_in_p13(t out nocopy amv_search_pvt.amv_searchres_varray_type, a0 JTF_VARCHAR2_TABLE_300
56: , a1 JTF_VARCHAR2_TABLE_2000
57: , a2 JTF_VARCHAR2_TABLE_4000
58: , a3 JTF_NUMBER_TABLE
59: , a4 JTF_NUMBER_TABLE
60: , a5 JTF_VARCHAR2_TABLE_100
61: , a6 JTF_VARCHAR2_TABLE_300
62: , a7 JTF_VARCHAR2_TABLE_300
63: , a8 JTF_VARCHAR2_TABLE_300

Line 68: , a3 out nocopy JTF_NUMBER_TABLE

64: );
65: procedure rosetta_table_copy_out_p13(t amv_search_pvt.amv_searchres_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
66: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_VARCHAR2_TABLE_100
71: , a6 out nocopy JTF_VARCHAR2_TABLE_300
72: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 69: , a4 out nocopy JTF_NUMBER_TABLE

65: procedure rosetta_table_copy_out_p13(t amv_search_pvt.amv_searchres_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
66: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_VARCHAR2_TABLE_100
71: , a6 out nocopy JTF_VARCHAR2_TABLE_300
72: , a7 out nocopy JTF_VARCHAR2_TABLE_300
73: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 88: , p12_a0 out nocopy JTF_NUMBER_TABLE

84: , p_repository_id NUMBER
85: , p_repository_code VARCHAR2
86: , p_repository_name VARCHAR2
87: , p_status VARCHAR2
88: , p12_a0 out nocopy JTF_NUMBER_TABLE
89: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
90: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
91: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a4 out nocopy JTF_NUMBER_TABLE

Line 92: , p12_a4 out nocopy JTF_NUMBER_TABLE

88: , p12_a0 out nocopy JTF_NUMBER_TABLE
89: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
90: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
91: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a4 out nocopy JTF_NUMBER_TABLE
93: );
94: procedure find_repository_areas(p_api_version NUMBER
95: , p_init_msg_list VARCHAR2
96: , p_validation_level NUMBER

Line 101: , p8_a0 out nocopy JTF_NUMBER_TABLE

97: , x_return_status out nocopy VARCHAR2
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p_check_login_user VARCHAR2
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: , p8_a3 out nocopy JTF_NUMBER_TABLE
105: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 104: , p8_a3 out nocopy JTF_NUMBER_TABLE

100: , p_check_login_user VARCHAR2
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: , p8_a3 out nocopy JTF_NUMBER_TABLE
105: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
107: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
108: , p8_a7 out nocopy JTF_NUMBER_TABLE

Line 108: , p8_a7 out nocopy JTF_NUMBER_TABLE

104: , p8_a3 out nocopy JTF_NUMBER_TABLE
105: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
107: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
108: , p8_a7 out nocopy JTF_NUMBER_TABLE
109: , p7_a0 NUMBER := 0-1962.0724
110: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a3 NUMBER := 0-1962.0724

Line 133: , p_category_id JTF_NUMBER_TABLE

129: , p10_a1 JTF_VARCHAR2_TABLE_400
130: , p_imt_string VARCHAR2
131: , p_days NUMBER
132: , p_user_id NUMBER
133: , p_category_id JTF_NUMBER_TABLE
134: , p_include_subcats VARCHAR2
135: , p_external_contents VARCHAR2
136: , p18_a0 out nocopy NUMBER
137: , p18_a1 out nocopy NUMBER

Line 142: , p19_a3 out nocopy JTF_NUMBER_TABLE

138: , p18_a2 out nocopy NUMBER
139: , p19_a0 out nocopy JTF_VARCHAR2_TABLE_300
140: , p19_a1 out nocopy JTF_VARCHAR2_TABLE_2000
141: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_4000
142: , p19_a3 out nocopy JTF_NUMBER_TABLE
143: , p19_a4 out nocopy JTF_NUMBER_TABLE
144: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300
146: , p19_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 143: , p19_a4 out nocopy JTF_NUMBER_TABLE

139: , p19_a0 out nocopy JTF_VARCHAR2_TABLE_300
140: , p19_a1 out nocopy JTF_VARCHAR2_TABLE_2000
141: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_4000
142: , p19_a3 out nocopy JTF_NUMBER_TABLE
143: , p19_a4 out nocopy JTF_NUMBER_TABLE
144: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300
146: , p19_a7 out nocopy JTF_VARCHAR2_TABLE_300
147: , p19_a8 out nocopy JTF_VARCHAR2_TABLE_300