APPS.IBC_STYLESHEETS_GRP dependencies on IBC_STYLESHEETS

Line 1: Package Body IBC_STYLESHEETS_GRP as

1: Package Body IBC_STYLESHEETS_GRP as
2: /* $Header: ibcgsshb.pls 120.2 2005/12/29 04:59:26 hsaiyed noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_STYLESHEETS_GRP';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcgsshb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_STYLESHEETS_GRP';

1: Package Body IBC_STYLESHEETS_GRP as
2: /* $Header: ibcgsshb.pls 120.2 2005/12/29 04:59:26 hsaiyed noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_STYLESHEETS_GRP';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcgsshb.pls';
6:
7: /***********************************************************************************
8: *************************** Private Procedures ************************************

Line 248: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i

244: l_stylesheet_id NUMBER;
245: --
246: CURSOR Get_StyleSheet_Id IS
247: select s.CONTENT_ITEM_ID
248: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
249: where i.CONTENT_ITEM_ID = p_content_item_id
250: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
251: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
252:

Line 336: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i

332: l_stylesheet_id NUMBER;
333: --
334: CURSOR Get_StyleSheet_Id IS
335: select s.CONTENT_ITEM_ID
336: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
337: where i.CONTENT_ITEM_ID = p_content_item_id
338: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
339: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
340:

Line 588: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i

584: --
585: CURSOR Get_StyleSheet_Ids IS
586: select s.CONTENT_ITEM_ID, p_stylesheets_label_code as LABEL,
587: userenv('LANG') as LANG
588: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
589: where i.CONTENT_ITEM_ID = p_content_item_id
590: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE;
591:
592: BEGIN

Line 688: END IBC_STYLESHEETS_GRP;

684:
685:
686:
687:
688: END IBC_STYLESHEETS_GRP;