PACKAGE: APPS.MSC_VERTICAL_PLAN_SC

Source

1 PACKAGE Msc_VERTICAL_PLAN_SC AUTHID CURRENT_USER AS
2 /* $Header: MSCVERPS.pls 115.7 2002/12/02 17:50:22 eychen ship $ */
3 
4 TYPE column_number IS TABLE OF number INDEX BY binary_integer;
5 
6   -- added by utham for multi_return action proc
7   TYPE number_arr is TABLE OF NUMBER;
8   TYPE sd_tbl_type IS record (p_query_id  number_arr
9                              ,p_number_1 number_arr);
10 
11 
12 
13 PROCEDURE populate_bucketed_quantity (
14 			  arg_plan_id IN NUMBER,
15                           arg_instance_id IN NUMBER,
16 			  arg_org_id IN NUMBER,
17                           arg_item_id IN NUMBER,
18 			  arg_cutoff_date IN DATE,
19                           arg_bucket_type IN VARCHAR2,
20                           p_quantity_string OUT NOCOPY VARCHAR2,
21                           p_period_string OUT NOCOPY VARCHAR2,
22                           p_period_count OUT NOCOPY NUMBER);
23 
24 FUNCTION  get_exception_group(l_where varchar2) return column_number;
25 
26 PROCEDURE flush_multi_return ( p_sd_table in msc_vertical_plan_sc.sd_tbl_type);
27 
28 
29 END Msc_VERTICAL_PLAN_SC;