DBA Data[Home] [Help]

PACKAGE: APPS.MSC_HP_UTIL

Source


1 package msc_hp_util AUTHID CURRENT_USER as
2 /* $Header: MSCPCUTS.pls 120.0.12020000.2 2012/10/10 15:29:55 wexia noship $ */
3     ft_organization constant number := 1;
4     ft_category constant number := 2;
5     ft_department constant number := 3;
6     ft_resource constant number := 4;
7     ft_exception constant number := 5;
8     ft_item constant number := 6;
9     ft_end_pegging constant number := 7;
10 
11     sync_purge constant number := 1;
12     sync_launch constant number := 2;
13 
14     -- debug only, replace fnd_global.login_id with msc_hp_util.login_id
15     login_id constant number := 101;
16 
17     function create_query_id return number;
18     function get_plan_id(p_query_id number) return number;
19     procedure prepare_col_dtls(p_plan_id number, p_refresh number);
20     procedure prepare_filters(p_query_id number, p_filter_type number, p_filters varchar2);
21     function get_calendar_code(p_plan_id number) return varchar2;
22     procedure sync_ui_data(p_plan_id number, p_mode number);
23 end msc_hp_util;