[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;