APPS.IBE_CATALOG_PRELOAD_PUB dependencies on IBE_CATALOG_PRELOAD_PUB

Line 1: PACKAGE BODY IBE_CATALOG_PRELOAD_PUB AS

1: PACKAGE BODY IBE_CATALOG_PRELOAD_PUB AS
2: /* $Header: IBEPCPLB.pls 120.0 2005/05/30 02:54:06 appldev noship $ */
3:
4:
5: -- Start of comments

Line 71: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(+)');

67: -- initialize API return status to success
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
71: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(+)');
72: END IF;
73: -- begin API body
74:
75: OPEN x_section_id_csr FOR

Line 82: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(-)');

78: WHERE sysdate between s.start_date_active and nvl(s.end_date_active,sysdate);
79:
80: -- end API body
81: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
82: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Section_Ids(-)');
83: END IF;
84:
85: -- standard call to get message count and if count is 1, get message info.
86: FND_MSG_PUB.Count_And_Get

Line 200: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(+)');

196:
197: -- initialize API return status to success
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(+)');
201: -- begin API body
202: OPEN x_item_id_csr FOR
203: SELECT DISTINCT si.INVENTORY_ITEM_ID
204: FROM IBE_DSP_SECTIONS_B s, IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B i

Line 211: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(-)');

207: AND sysdate between s.start_date_active and nvl(s.end_date_active,sysdate)
208: AND sysdate between si.start_date_active and nvl(si.end_date_active,sysdate);
209:
210: -- end API body
211: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(-)');
212:
213: -- standard call to get message count and if count is 1, get message info.
214: FND_MSG_PUB.Count_And_Get
215: ( p_encoded => FND_API.G_FALSE,

Line 272: end IBE_CATALOG_PRELOAD_PUB;

268: -- Section cache.
269: --
270:
271:
272: end IBE_CATALOG_PRELOAD_PUB;