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 163: INV_MGD_POS_UTIL.Log

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

Line 164: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

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

Line 176: INV_MGD_POS_UTIL.Log

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

Line 177: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

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

Line 223: INV_MGD_POS_UTIL.Log

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

Line 224: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

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

Line 278: INV_MGD_POS_UTIL.Log

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

Line 279: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

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