1 PACKAGE MSC_ALLOCATION_PLAN AS
2 /* $Header: MSCALPHS.pls 120.1 2005/08/25 10:19:04 eychen noship $ */
3 Procedure populate_allocation_plan (
4 arg_query_id IN NUMBER,
5 arg_plan_id IN NUMBER,
6 arg_org_id IN NUMBER,
7 arg_instance_id IN NUMBER,
8 arg_item_id IN NUMBER,
9 arg_group_by IN NUMBER,
10 arg_customer_id IN NUMBER DEFAULT NULL,
11 arg_customer_site_id IN NUMBER DEFAULT NULL,
12 arg_customer_list_id IN NUMBER DEFAULT NULL);
13
14 FUNCTION send_dates RETURN varchar2;
15
16 PROCEDURE create_planned_arrival(
17 p_plan_id in number, p_org_id in number,
18 p_inst_id in number, p_item_id in number,
19 p_source_org in number, p_source_inst in number,
20 p_bkt_start_date in date,
21 p_allocate_qty in number);
22
23 PROCEDURE query_list(
24 p_query_id IN NUMBER,
25 p_plan_id IN NUMBER,
26 p_org_id IN NUMBER,
27 p_inst_id IN NUMBER,
28 p_category_set IN NUMBER,
29 p_category_name IN VARCHAR2);
30
31 FUNCTION flush_suggAlloc_drillDown(p_item_query_id number,
32 p_sub_type number,
33 p_start_date date, p_end_date date)
34 return NUMBER;
35
36 END MSC_ALLOCATION_PLAN;