APPS.IBE_CATALOG_PRELOAD_PUB dependencies on IBE_DSP_SECTIONS_B

Line 10: -- IBE_DSP_SECTIONS_B.SECTION_ID or a table with a foreign key to

6: -- API name : Get_Preload_Section_Ids
7: -- Type : Public.
8: -- Function : Returns ref cursor containing section_ids of sections to be preloaded
9: -- into the cache. Section IDs should come from
10: -- IBE_DSP_SECTIONS_B.SECTION_ID or a table with a foreign key to
11: -- IBE_DSP_SECTIONS_B.SECTION_ID. Current implementation returns
12: -- all section ids.
13: --
14: -- Pre-reqs : None.

Line 11: -- IBE_DSP_SECTIONS_B.SECTION_ID. Current implementation returns

7: -- Type : Public.
8: -- Function : Returns ref cursor containing section_ids of sections to be preloaded
9: -- into the cache. Section IDs should come from
10: -- IBE_DSP_SECTIONS_B.SECTION_ID or a table with a foreign key to
11: -- IBE_DSP_SECTIONS_B.SECTION_ID. Current implementation returns
12: -- all section ids.
13: --
14: -- Pre-reqs : None.
15: -- Parameters :

Line 77: FROM IBE_DSP_SECTIONS_B s

73: -- begin API body
74:
75: OPEN x_section_id_csr FOR
76: SELECT s.SECTION_ID
77: FROM IBE_DSP_SECTIONS_B s
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

Line 204: FROM IBE_DSP_SECTIONS_B s, IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B i

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
205: WHERE s.SECTION_TYPE_CODE = 'F' AND s.SECTION_ID = si.SECTION_ID
206: AND si.INVENTORY_ITEM_ID = i.INVENTORY_ITEM_ID AND i.WEB_STATUS = 'PUBLISHED'
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);