DBA Data[Home] [Help]

APPS.MSC_PHUB_UTIL dependencies on MSC_PHUB_UTIL

Line 1: PACKAGE BODY msc_phub_util AS

1: PACKAGE BODY msc_phub_util AS
2: /* $Header: MSCHBUTB.pls 120.3.12010000.7 2008/09/03 14:44:22 wexia ship $ */
3: SYS_YES CONSTANT INTEGER := 1;
4: SYS_NO CONSTANT INTEGER := 2;
5:

Line 30: l_rate := msc_phub_util.get_conversion_rate(l_func_currency, p_sr_instance_id, p_date);

26: from msc_trading_partners
27: where sr_instance_id = p_sr_instance_id
28: and organization_id = p_organization_id
29: and partner_type = 3;*/
30: l_rate := msc_phub_util.get_conversion_rate(l_func_currency, p_sr_instance_id, p_date);
31: return l_rate;
32: end get_conversion_rate;
33:
34: function get_planning_hub_message(p_mesg_code varchar2) return varchar2 is

Line 213: return msc_phub_util.get_planning_hub_message('MSC_HUB_UNASSIGNED');

209: return l_user_name;
210:
211: exception
212: when others then
213: return msc_phub_util.get_planning_hub_message('MSC_HUB_UNASSIGNED');
214: end get_user_name;
215:
216: procedure populate_item_categories(p_query_id number, p_plan_id number, p_plan_run_id number,
217: p_plan_type number, p_aggr_type number, p_category_set_id number) is

Line 345: END msc_phub_util;

341: raise SECURITY_CONTEXT_INVALID;
342: end if;
343: end validate_icx_session;
344:
345: END msc_phub_util;