APPS.INV_MGD_POS_ITEM_MDTR dependencies on INV_MGD_POS_UTIL

Line 50: ( p_organization_tbl IN INV_MGD_POS_UTIL.organization_tbl_type

46: -- PRE-COND : p_organization_tbl is not empty
47: -- POST-COND : x_item_tbl is not empty
48: --========================================================================
49: PROCEDURE Build_Item_List
50: ( p_organization_tbl IN INV_MGD_POS_UTIL.organization_tbl_type
51: , p_master_org_id IN NUMBER DEFAULT NULL
52: , p_item_from IN VARCHAR2 DEFAULT NULL
53: , p_item_to IN VARCHAR2 DEFAULT NULL
54: , p_category_id IN NUMBER DEFAULT NULL

Line 55: , x_item_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.item_tbl_type

51: , p_master_org_id IN NUMBER DEFAULT NULL
52: , p_item_from IN VARCHAR2 DEFAULT NULL
53: , p_item_to IN VARCHAR2 DEFAULT NULL
54: , p_category_id IN NUMBER DEFAULT NULL
55: , x_item_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.item_tbl_type
56: )
57: IS
58:
59: l_api_name CONSTANT VARCHAR2(30):= 'Build_Item_List';

Line 164: INV_MGD_POS_UTIL.Log

160: */
161: BEGIN
162:
163: IF G_DEBUG = 'Y' THEN
164: INV_MGD_POS_UTIL.Log
165: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
166: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
167: );
168: END IF;

Line 165: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

161: BEGIN
162:
163: IF G_DEBUG = 'Y' THEN
164: INV_MGD_POS_UTIL.Log
165: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
166: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
167: );
168: END IF;
169:

Line 177: INV_MGD_POS_UTIL.Log

173: IF p_category_id IS NULL THEN
174:
175: -- don't need to join to mtl_item_categories
176: IF G_DEBUG = 'Y' THEN
177: INV_MGD_POS_UTIL.Log
178: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
179: , p_msg => 'build item list without category filter'
180: );
181: END IF;

Line 178: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

174:
175: -- don't need to join to mtl_item_categories
176: IF G_DEBUG = 'Y' THEN
177: INV_MGD_POS_UTIL.Log
178: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
179: , p_msg => 'build item list without category filter'
180: );
181: END IF;
182:

Line 224: INV_MGD_POS_UTIL.Log

220: ELSE
221:
222: -- need to join to mtl_item_categories;
223: IF G_DEBUG = 'Y' THEN
224: INV_MGD_POS_UTIL.Log
225: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
226: , p_msg => 'build item list with category filter'
227: );
228: END IF;

Line 225: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

221:
222: -- need to join to mtl_item_categories;
223: IF G_DEBUG = 'Y' THEN
224: INV_MGD_POS_UTIL.Log
225: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
226: , p_msg => 'build item list with category filter'
227: );
228: END IF;
229:

Line 279: INV_MGD_POS_UTIL.Log

275:
276: END IF;
277:
278: IF G_DEBUG = 'Y' THEN
279: INV_MGD_POS_UTIL.Log
280: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
281: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
282: );
283: END IF;

Line 280: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

276: END IF;
277:
278: IF G_DEBUG = 'Y' THEN
279: INV_MGD_POS_UTIL.Log
280: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
281: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
282: );
283: END IF;
284: