[Home] [Help]
PACKAGE: APPS.AMV_STOCK_PVT_W
Source
1 package amv_stock_pvt_w as
2 /* $Header: amvwstks.pls 120.2 2005/06/30 08:26 appldev ship $ */
3 procedure rosetta_table_copy_in_p6(t out nocopy amv_stock_pvt.amv_tkr_varray_type, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_NUMBER_TABLE
5 );
6 procedure rosetta_table_copy_out_p6(t amv_stock_pvt.amv_tkr_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7 , a1 out nocopy JTF_NUMBER_TABLE
8 );
9
10 procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE
11 , a1 JTF_VARCHAR2_TABLE_100
12 , a2 JTF_VARCHAR2_TABLE_100
13 );
14 procedure rosetta_table_copy_out_p7(t amv_stock_pvt.amv_sym_varray_type, a0 out nocopy JTF_NUMBER_TABLE
15 , a1 out nocopy JTF_VARCHAR2_TABLE_100
16 , a2 out nocopy JTF_VARCHAR2_TABLE_100
17 );
18
19 procedure rosetta_table_copy_in_p8(t out nocopy amv_stock_pvt.amv_stk_varray_type, a0 JTF_NUMBER_TABLE
20 , a1 JTF_VARCHAR2_TABLE_100
21 , a2 JTF_VARCHAR2_TABLE_300
22 , a3 JTF_NUMBER_TABLE
23 , a4 JTF_NUMBER_TABLE
24 );
25 procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE
26 , a1 out nocopy JTF_VARCHAR2_TABLE_100
27 , a2 out nocopy JTF_VARCHAR2_TABLE_300
28 , a3 out nocopy JTF_NUMBER_TABLE
29 , a4 out nocopy JTF_NUMBER_TABLE
30 );
31
32 procedure rosetta_table_copy_in_p9(t out nocopy amv_stock_pvt.amv_news_varray_type, a0 JTF_VARCHAR2_TABLE_100
33 , a1 JTF_VARCHAR2_TABLE_2000
34 , a2 JTF_VARCHAR2_TABLE_2000
35 , a3 JTF_VARCHAR2_TABLE_300
36 , a4 JTF_DATE_TABLE
37 );
38 procedure rosetta_table_copy_out_p9(t amv_stock_pvt.amv_news_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
39 , a1 out nocopy JTF_VARCHAR2_TABLE_2000
40 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
41 , a3 out nocopy JTF_VARCHAR2_TABLE_300
42 , a4 out nocopy JTF_DATE_TABLE
43 );
44
45 procedure rosetta_table_copy_in_p10(t out nocopy amv_stock_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_400);
46 procedure rosetta_table_copy_out_p10(t amv_stock_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_400);
47
48 procedure rosetta_table_copy_in_p11(t out nocopy amv_stock_pvt.amv_num_varray_type, a0 JTF_NUMBER_TABLE);
49 procedure rosetta_table_copy_out_p11(t amv_stock_pvt.amv_num_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
50
51 procedure get_userticker(p_api_version NUMBER
52 , p_init_msg_list VARCHAR2
53 , p_validation_level NUMBER
54 , x_return_status out nocopy VARCHAR2
55 , x_msg_count out nocopy NUMBER
56 , x_msg_data out nocopy VARCHAR2
57 , p_user_id NUMBER
58 , p_distinct_stocks VARCHAR2
59 , p_sort_order VARCHAR2
60 , p9_a0 out nocopy JTF_NUMBER_TABLE
61 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
62 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
63 , p9_a3 out nocopy JTF_NUMBER_TABLE
64 , p9_a4 out nocopy JTF_NUMBER_TABLE
65 );
66 procedure get_stockdetails(p_api_version NUMBER
67 , p_init_msg_list VARCHAR2
68 , p_validation_level NUMBER
69 , x_return_status out nocopy VARCHAR2
70 , x_msg_count out nocopy NUMBER
71 , x_msg_data out nocopy VARCHAR2
72 , p_symbols VARCHAR2
73 , p7_a0 out nocopy JTF_NUMBER_TABLE
74 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
75 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
76 , p7_a3 out nocopy JTF_NUMBER_TABLE
77 , p7_a4 out nocopy JTF_NUMBER_TABLE
78 );
79 procedure get_vendormissedstocks(p_api_version NUMBER
80 , p_init_msg_list VARCHAR2
81 , p_validation_level NUMBER
82 , x_return_status out nocopy VARCHAR2
83 , x_msg_count out nocopy NUMBER
84 , x_msg_data out nocopy VARCHAR2
85 , p_vendor_id NUMBER
86 , p_start_index NUMBER
87 , p_batch_size NUMBER
88 , p9_a0 out nocopy JTF_NUMBER_TABLE
89 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
90 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
91 );
92 procedure insert_stockvendorkeys(p_api_version NUMBER
93 , p_init_msg_list VARCHAR2
94 , p_commit VARCHAR2
95 , p_validation_level NUMBER
96 , x_return_status out nocopy VARCHAR2
97 , x_msg_count out nocopy NUMBER
98 , x_msg_data out nocopy VARCHAR2
99 , p_vendor_id NUMBER
100 , p8_a0 VARCHAR2 := fnd_api.g_miss_char
101 , p8_a1 NUMBER := 0-1962.0724
102 );
103 procedure get_userselectedkeys(p_api_version NUMBER
104 , p_init_msg_list VARCHAR2
105 , p_validation_level NUMBER
106 , x_return_status out nocopy VARCHAR2
107 , x_msg_count out nocopy NUMBER
108 , x_msg_data out nocopy VARCHAR2
109 , p_vendor_id NUMBER
110 , p_all_keys VARCHAR2
111 , x_keys_array out nocopy JTF_VARCHAR2_TABLE_400
112 );
113 procedure insert_vendornews(p_api_version NUMBER
114 , p_init_msg_list VARCHAR2
115 , p_commit VARCHAR2
116 , p_validation_level NUMBER
117 , x_return_status out nocopy VARCHAR2
118 , x_msg_count out nocopy NUMBER
119 , x_msg_data out nocopy VARCHAR2
120 , p_vendor_id NUMBER
121 , p8_a0 VARCHAR2 := fnd_api.g_miss_char
122 , p8_a1 VARCHAR2 := fnd_api.g_miss_char
123 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
124 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
125 , p8_a4 DATE := fnd_api.g_miss_date
126 );
127 procedure get_companynews(p_api_version NUMBER
128 , p_init_msg_list VARCHAR2
129 , p_commit VARCHAR2
130 , p_validation_level NUMBER
131 , x_return_status out nocopy VARCHAR2
132 , x_msg_count out nocopy NUMBER
133 , x_msg_data out nocopy VARCHAR2
134 , p_stock_id NUMBER
135 , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
136 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_2000
137 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_2000
138 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_300
139 , p8_a4 out nocopy JTF_DATE_TABLE
140 );
141 end amv_stock_pvt_w;