APPS.AMV_SEARCH_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 10: , a1 JTF_VARCHAR2_TABLE_100

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
14: );

Line 13: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
17: , a1 JTF_VARCHAR2_TABLE_100

Line 17: , a1 JTF_VARCHAR2_TABLE_100

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
21: );

Line 18: , a2 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
21: );
22: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE

Line 19: , a3 JTF_VARCHAR2_TABLE_100

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

Line 23: , a1 out nocopy 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
27: );

Line 24: , a2 out nocopy 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
27: );
28:

Line 25: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
27: );
28:
29: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE

Line 30: , a1 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
34: , a5 JTF_VARCHAR2_TABLE_100

Line 31: , a2 JTF_VARCHAR2_TABLE_100

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
34: , a5 JTF_VARCHAR2_TABLE_100
35: , a6 JTF_VARCHAR2_TABLE_100

Line 33: , a4 JTF_VARCHAR2_TABLE_100

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
37: );

Line 34: , a5 JTF_VARCHAR2_TABLE_100

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
37: );
38: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE

Line 35: , a6 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
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

Line 39: , a1 out nocopy 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
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , a2 out nocopy 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
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 42: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
46: );

Line 43: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
46: );
47:

Line 44: , a6 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
46: );
47:
48: procedure rosetta_table_copy_in_p11(t out nocopy amv_search_pvt.amv_searchpar_varray_type, a0 JTF_VARCHAR2_TABLE_100

Line 48: procedure rosetta_table_copy_in_p11(t out nocopy amv_search_pvt.amv_searchpar_varray_type, a0 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
50: );
51: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_400

Line 51: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

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
50: );
51: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_400
53: );
54:
55: procedure rosetta_table_copy_in_p13(t out nocopy amv_search_pvt.amv_searchres_varray_type, a0 JTF_VARCHAR2_TABLE_300

Line 60: , a5 JTF_VARCHAR2_TABLE_100

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
64: );

Line 70: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
74: );

Line 89: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
93: );

Line 90: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
93: );
94: procedure find_repository_areas(p_api_version NUMBER

Line 91: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
93: );
94: procedure find_repository_areas(p_api_version NUMBER
95: , p_init_msg_list VARCHAR2

Line 102: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
106: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 103: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
106: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
107: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 105: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
109: , p7_a0 NUMBER := 0-1962.0724

Line 106: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
109: , p7_a0 NUMBER := 0-1962.0724
110: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

Line 107: , p8_a6 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
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

Line 128: , p10_a0 JTF_VARCHAR2_TABLE_100

124: , p_check_login_user VARCHAR2
125: , p_application_id NUMBER
126: , p_area_array JTF_VARCHAR2_TABLE_4000
127: , p_content_array JTF_VARCHAR2_TABLE_4000
128: , p10_a0 JTF_VARCHAR2_TABLE_100
129: , p10_a1 JTF_VARCHAR2_TABLE_400
130: , p_imt_string VARCHAR2
131: , p_days NUMBER
132: , p_user_id NUMBER

Line 144: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
148: , p17_a0 NUMBER := 0-1962.0724