1 PACKAGE AMS_RUNTIME_PROD_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvrpds.pls 115.9 2003/12/10 13:24:19 sikalyan ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_RUNTIME_PROD_PVT';
5 G_MAX_NO_PRODS NUMBER := 0;
6
7 TYPE prod_cursor is REF CURSOR;
8
9 PROCEDURE getRelatedItems(
10 p_api_version_number IN NUMBER ,
11 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
12 p_application_id IN NUMBER ,
13 p_prod_lst IN JTF_NUMBER_TABLE ,
14 p_rel_type_code IN VARCHAR2 ,
15 p_org_id IN NUMBER ,
16 p_max_ret_num IN NUMBER := NULL ,
17 p_order_by_clause IN VARCHAR2 := NULL ,
18 x_items_tbl OUT NOCOPY JTF_Number_Table ,
19 x_return_status OUT NOCOPY VARCHAR2 ,
20 x_msg_count OUT NOCOPY NUMBER ,
21 x_msg_data OUT NOCOPY VARCHAR2
22 );
23
24
25 PROCEDURE getRelatedItems(
26 p_api_version_number IN NUMBER ,
27 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28 p_application_id IN NUMBER ,
29 p_msite_id IN NUMBER ,
30 p_top_section_id IN NUMBER ,
31 p_incl_section IN VARCHAR2 := NULL ,
32 p_prod_lst IN JTF_NUMBER_TABLE ,
33 p_rel_type_code IN VARCHAR2 ,
34 p_org_id IN NUMBER ,
35 p_max_ret_num IN NUMBER := NULL ,
36 p_order_by_clause IN VARCHAR2 := NULL ,
37 x_items_tbl OUT NOCOPY JTF_Number_Table ,
38 x_return_status OUT NOCOPY VARCHAR2 ,
39 x_msg_count OUT NOCOPY NUMBER ,
40 x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43
44 PROCEDURE getFilteredProdsFromList
45 (p_api_version_number IN NUMBER,
46 p_init_msg_list IN VARCHAR2,
47 p_application_id IN NUMBER,
48 p_party_id IN NUMBER,
49 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
50 p_currency_code IN VARCHAR2 := NULL,
51 p_prod_lst IN JTF_NUMBER_TABLE,
52 p_msite_id IN NUMBER := NULL,
53 p_top_section_id IN NUMBER := NULL,
54 p_org_id IN NUMBER,
55 p_bus_prior IN VARCHAR2 := NULL,
56 p_bus_prior_order IN VARCHAR2 := NULL,
57 p_filter_ref_code IN VARCHAR2 := NULL,
58 p_price_list_id IN NUMBER := NULL,
59 p_max_ret_num IN NUMBER := NULL,
60 x_prod_lst OUT NOCOPY JTF_Number_Table,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE getRelProdsForQuoteAndCust
67 (p_api_version_number IN NUMBER,
68 p_init_msg_list IN VARCHAR2,
69 p_application_id IN NUMBER,
70 p_party_id IN NUMBER,
71 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
72 p_currency_code IN VARCHAR2 := NULL,
73 p_quote_id IN NUMBER,
74 p_msite_id IN NUMBER,
75 p_top_section_id IN NUMBER,
76 p_org_id IN NUMBER,
77 p_rel_type_code IN VARCHAR2,
78 p_bus_prior IN VARCHAR2,
79 p_bus_prior_order IN VARCHAR2,
80 p_filter_ref_code IN VARCHAR2,
81 p_price_list_id IN NUMBER := NULL,
82 p_max_ret_num IN NUMBER := NULL,
83 x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE getRelProdsForProdAndCust
90 (p_api_version_number IN NUMBER,
91 p_init_msg_list IN VARCHAR2,
92 p_application_id IN NUMBER,
93 p_party_id IN NUMBER,
94 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
95 p_currency_code IN VARCHAR2 := NULL,
96 p_prod_lst IN JTF_NUMBER_TABLE,
97 p_msite_id IN NUMBER,
98 p_top_section_id IN NUMBER,
99 p_org_id IN NUMBER,
100 p_rel_type_code IN VARCHAR2,
101 p_bus_prior IN VARCHAR2,
102 p_bus_prior_order IN VARCHAR2,
103 p_filter_ref_code IN VARCHAR2,
104 p_price_list_id IN NUMBER := NULL,
105 p_max_ret_num IN NUMBER := NULL,
106 x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112
113 PROCEDURE getPrioritizedProds
114 (p_api_version_number IN NUMBER,
115 p_init_msg_list IN VARCHAR2,
116 p_application_id IN NUMBER,
117 p_party_id IN NUMBER,
118 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
119 p_currency_code IN VARCHAR2 := NULL,
120 p_prod_lst IN JTF_NUMBER_TABLE,
121 p_org_id IN NUMBER,
122 p_bus_prior IN VARCHAR2,
123 p_bus_prior_order IN VARCHAR2,
124 p_price_list_id IN NUMBER := NULL,
125 p_max_ret_num IN NUMBER := NULL,
126 x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2
130 );
131
132 procedure loadItemDetails
133 (p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
135 p_application_id IN NUMBER,
136 p_party_id IN NUMBER,
137 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
138 p_currency_code IN VARCHAR2 := NULL,
139 p_itmid_tbl IN JTF_NUMBER_TABLE,
140 p_organization_id IN NUMBER,
141 p_category_set_id IN NUMBER,
142 p_retrieve_price IN VARCHAR2 := FND_API.G_FALSE,
143 p_price_list_id IN NUMBER := NULL,
144 p_price_request_type IN VARCHAR2 := NULL,
145 p_price_event IN VARCHAR2 := NULL,
146 x_item_csr OUT NOCOPY prod_cursor,
147 x_category_id_csr OUT NOCOPY prod_cursor,
148 x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE,
149 x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE,
150 x_price_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100,
151 x_price_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300,
152 x_price_return_status OUT NOCOPY VARCHAR2,
153 x_price_return_status_text OUT NOCOPY VARCHAR2,
154 x_item_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2
157 );
158
159
160 PROCEDURE getRelProdsForProd
161 (p_api_version_number IN NUMBER,
162 p_init_msg_list IN VARCHAR2,
163 p_application_id IN NUMBER,
164 p_party_id IN NUMBER,
165 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
166 p_currency_code IN VARCHAR2 := NULL,
167 p_prod_lst IN JTF_NUMBER_TABLE,
168 p_msite_id IN NUMBER,
169 p_top_section_id IN NUMBER,
170 p_org_id IN NUMBER,
171 p_rel_type_code IN VARCHAR2,
172 p_max_ret_num IN NUMBER := NULL,
173 x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2
177 );
178
179
180 PROCEDURE getRelProdsForCart
181 (p_api_version_number IN NUMBER,
182 p_init_msg_list IN VARCHAR2,
183 p_application_id IN NUMBER,
184 p_party_id IN NUMBER,
185 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
186 p_currency_code IN VARCHAR2 := NULL,
187 p_quote_id IN NUMBER,
188 p_msite_id IN NUMBER,
189 p_top_section_id IN NUMBER,
190 p_org_id IN NUMBER,
191 p_rel_type_code IN VARCHAR2,
192 p_max_ret_num IN NUMBER := NULL,
193 x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2
197 );
198
199 END AMS_RUNTIME_PROD_PVT;