APPS.IBE_PROD_RELATION_GRP dependencies on JTF_NUMBER_TABLE

Line 113: -- x_items_tbl OUT JTF_Number_Table

109: -- Default = NULL (Bind variables for relationship rule defined by manual SQL)
110: -- OUT : x_return_status OUT VARCHAR2(1)
111: -- x_msg_count OUT NUMBER
112: -- x_msg_data OUT VARCHAR2(2000)
113: -- x_items_tbl OUT JTF_Number_Table
114: -- Version : Current version 1.0
115: --
116: -- previous version None
117: --

Line 149: x_items_tbl OUT NOCOPY JTF_Number_Table

145: p_bind_arg7 IN VARCHAR2 := NULL ,
146: p_bind_arg8 IN VARCHAR2 := NULL ,
147: p_bind_arg9 IN VARCHAR2 := NULL ,
148: p_bind_arg10 IN VARCHAR2 := NULL ,
149: x_items_tbl OUT NOCOPY JTF_Number_Table
150: )
151: IS
152: TYPE rel_items_csr_type IS REF CURSOR;
153: l_api_name CONSTANT VARCHAR2(30) := 'Get_Related_Items';

Line 163: l_items_tbl JTF_Number_Table;

159: l_bind_arg_num PLS_INTEGER;
160: l_dummy VARCHAR2(30);
161: i PLS_INTEGER := 1;
162: include_mtl BOOLEAN;
163: l_items_tbl JTF_Number_Table;
164: l_debug VARCHAR2(1);
165: l_init_msg_list VARCHAR2(5);
166: l_preview_flag VARCHAR2(5);
167: l_include_self_ref VARCHAR2(5);

Line 204: x_items_tbl := JTF_Number_Table();

200: END IF;
201: -- Initialize API return status to success
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203: -- Initialize the return value table
204: x_items_tbl := JTF_Number_Table();
205: l_items_tbl.extend();
206: l_items_tbl(1) := p_item_id;
207: IF (l_debug = 'Y') THEN
208: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');

Line 271: -- x_items_tbl OUT JTF_Number_Table

267: -- Default = NULL (Bind arguments for relationship rule defined by manual SQL)
268: -- OUT : x_return_status OUT VARCHAR2(1)
269: -- x_msg_count OUT NUMBER
270: -- x_msg_data OUT VARCHAR2(2000)
271: -- x_items_tbl OUT JTF_Number_Table
272: -- Version : Current version 1.0
273: --
274: -- previous version None
275: --

Line 304: x_items_tbl OUT NOCOPY JTF_Number_Table

300: p_bind_arg7 IN VARCHAR2 := NULL ,
301: p_bind_arg8 IN VARCHAR2 := NULL ,
302: p_bind_arg9 IN VARCHAR2 := NULL ,
303: p_bind_arg10 IN VARCHAR2 := NULL ,
304: x_items_tbl OUT NOCOPY JTF_Number_Table
305: )
306: IS
307: TYPE rel_items_csr_type IS REF CURSOR;
308: l_api_name CONSTANT VARCHAR2(30) := 'Get_Related_Items';

Line 443: x_items_tbl := JTF_Number_Table();

439: END IF;
440: -- Initialize API return status to success
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442: -- Initialize the return value table
443: x_items_tbl := JTF_Number_Table();
444: IF (l_debug = 'Y') THEN
445: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');
446: IBE_UTIL.debug('p_org_id : p_item_id : p_rel_type_code : l_rule_type = '
447: || p_org_id || ' : ' || p_item_id || ' : '

Line 694: p_item_ids IN JTF_Number_Table ,

690: x_msg_count OUT NOCOPY NUMBER ,
691: x_msg_data OUT NOCOPY VARCHAR2 ,
692: p_msite_id IN NUMBER ,
693: p_preview_flag IN VARCHAR2 := NULL ,
694: p_item_ids IN JTF_Number_Table ,
695: p_rel_type_code IN VARCHAR2 ,
696: p_org_id IN NUMBER ,
697: p_max_ret_num IN NUMBER := NULL ,
698: p_order_by_clause IN VARCHAR2 := NULL ,

Line 711: x_items_tbl OUT NOCOPY JTF_Number_Table

707: p_bind_arg7 IN VARCHAR2 := NULL ,
708: p_bind_arg8 IN VARCHAR2 := NULL ,
709: p_bind_arg9 IN VARCHAR2 := NULL ,
710: p_bind_arg10 IN VARCHAR2 := NULL ,
711: x_items_tbl OUT NOCOPY JTF_Number_Table
712: )
713: IS
714: TYPE rel_items_csr_type IS REF CURSOR;
715: l_api_name CONSTANT VARCHAR2(30) := 'Get_Related_Items';

Line 1146: x_items_tbl := JTF_Number_Table();

1142:
1143: -- Initialize API return status to success
1144: x_return_status := FND_API.G_RET_STS_SUCCESS;
1145: -- Initialize the return value table
1146: x_items_tbl := JTF_Number_Table();
1147:
1148: IF (l_debug = 'Y') THEN
1149: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');
1150: IBE_UTIL.debug('p_org_id : p_rel_type_code : l_rule_type = '