APPS.EDW_MISC_UTIL dependencies on EDW_MISC_UTIL

Line 1: package body edw_misc_util AS

1: package body edw_misc_util AS
2: /* $Header: EDWMISCB.pls 115.7 2002/12/05 22:16:07 arsantha ship $ */
3:
4: Procedure globalNamesOff IS
5: l_cid number;

Line 78: edw_misc_util.globalnamesoff;

74: Type CurTyp is Ref Cursor;
75: cv CurTyp;
76: begin
77:
78: edw_misc_util.globalnamesoff;
79: l_stmt:='select mts.category_set_name from mtl_category_sets@'||l_db_link
80: ||' mts, mtl_default_category_sets@'||l_db_link ||' mtd '||
81: 'where mts.category_set_id=mtd.category_set_id
82: and mtd.functional_area_id=2

Line 99: edw_misc_util.globalnamesoff;

95: Type CurTyp is Ref Cursor;
96: cv CurTyp;
97: begin
98:
99: edw_misc_util.globalnamesoff;
100: l_stmt:='select mts.category_set_name from mtl_category_sets@'||l_db_link
101: ||' mts, mtl_default_category_sets@'||l_db_link ||' mtd '||
102: 'where mts.category_set_id=mtd.category_set_id
103: and mtd.functional_area_id=1';

Line 112: end edw_misc_util;

108:
109: end get_itemorg_default;
110:
111:
112: end edw_misc_util;