DBA Data[Home] [Help]

APPS.EGO_CATEGORY_SET_PUB dependencies on EGO_CATEGORY_SET_PUB

Line 1: PACKAGE BODY EGO_CATEGORY_SET_PUB AS

1: PACKAGE BODY EGO_CATEGORY_SET_PUB AS
2: /* $Header: EGOCSTPB.pls 120.2 2006/01/25 08:45:23 bparthas noship $ */
3:
4: g_pkg_name VARCHAR2(30) := 'EGO_CATEGORY_SET_PUB';
5: g_app_name VARCHAR2(3) := 'EGO';

Line 4: g_pkg_name VARCHAR2(30) := 'EGO_CATEGORY_SET_PUB';

1: PACKAGE BODY EGO_CATEGORY_SET_PUB AS
2: /* $Header: EGOCSTPB.pls 120.2 2006/01/25 08:45:23 bparthas noship $ */
3:
4: g_pkg_name VARCHAR2(30) := 'EGO_CATEGORY_SET_PUB';
5: g_app_name VARCHAR2(3) := 'EGO';
6: g_current_user_id NUMBER := EGO_SCTX.Get_User_Id();
7: g_current_login_id NUMBER := FND_GLOBAL.Login_Id;
8: g_plsql_err VARCHAR2(17) := 'EGO_PLSQL_ERR';

Line 144: where functional_area_id = EGO_CATEGORY_SET_PUB.G_DBI_FUNCTIONAL_AREA_ID

140:
141: SELECT category_set_id INTO l_DBI_category_set_id
142: FROM
143: (select * from mtl_default_category_sets
144: where functional_area_id = EGO_CATEGORY_SET_PUB.G_DBI_FUNCTIONAL_AREA_ID
145: and rownum = 1);
146:
147: END IF;
148:

Line 245: END EGO_CATEGORY_SET_PUB;

241:
242: END Process_DBI_Category;
243:
244:
245: END EGO_CATEGORY_SET_PUB;