PACKAGE: APPS.MSC_PHUB_UTIL

Source

1 PACKAGE msc_phub_util AS
2 /* $Header: MSCHBUTS.pls 120.0.12010000.4 2008/07/08 20:02:26 pabram ship $ */
3    g_rpt_curr_code varchar2(20);
4    FUNCTION get_conversion_rate(p_func_currency in varchar2,p_sr_instance_id in number, p_date in date) return number;
5    FUNCTION get_conversion_rate(p_sr_instance_id in number, p_organization_id in number, p_date in date) return number;
6    FUNCTION get_planning_hub_message(p_mesg_code in varchar2) return varchar2;
7    FUNCTION get_reporting_currency_code return varchar2;
8    FUNCTION get_exception_group(p_exception_type_id in number) return varchar2;
9    FUNCTION get_list_price(p_plan_id in number,p_inst_id in number,p_org_id in number, p_item_id in number) return number;
10    FUNCTION is_plan_constrained (l_daily number, l_weekly number, l_monthly number, l_dailym number, l_weeklym number, l_monthlym number) return number;
11    FUNCTION is_plan_constrained(p_plan_id number) return number;
12    FUNCTION get_plan_type(p_plan_id number) return number;
13    FUNCTION get_default_plan_id(p_scenario_id number, p_plan_type number, p_plan_run_name varchar2) return number;
14    FUNCTION get_user_name(p_user_id number) return varchar2;
15    procedure populate_item_categories(p_query_id number, p_plan_id number, p_plan_run_id number, p_plan_type number default null);
16 
17 
18   procedure validate_icx_session(p_icx_cookie varchar2, p_user varchar2, p_pwd varchar2);
19 END msc_phub_util;