1 PACKAGE MSC_HORIZONTAL_PLAN_SC AS
2 /* $Header: MSCPHOPS.pls 120.0 2005/05/25 17:43:57 appldev noship $ */
3 PROCEDURE populate_horizontal_plan (p_agg_hzp IN NUMBER,
4 item_list_id IN NUMBER,
5 arg_query_id IN NUMBER,
6 arg_plan_id IN NUMBER,
7 arg_plan_organization_id IN NUMBER,
8 arg_plan_instance_id IN NUMBER,
9 arg_bucket_type IN NUMBER,
10 arg_cutoff_date IN DATE,
11 arg_current_data IN NUMBER DEFAULT 2,
12 arg_ind_demand_type IN NUMBER DEFAULT NULL,
13 arg_source_list_name IN VARCHAR2 DEFAULT NULL,
14 enterprize_view IN BOOLEAN := FALSE,
15 arg_res_level IN NUMBER DEFAULT 1,
16 arg_resval1 IN VARCHAR2 DEFAULT NULL,
17 arg_resval2 IN NUMBER DEFAULT NULL,
18 arg_category_name IN VARCHAR2 DEFAULT NULL,
19 arg_ep_view_also IN BOOLEAN DEFAULT FALSE);
20
21 PROCEDURE query_list(p_agg_hzp IN NUMBER,
22 p_query_id IN NUMBER,
23 p_plan_id IN NUMBER,
24 p_instance_id IN NUMBER,
25 p_org_list IN VARCHAR2,
26 p_pf IN NUMBER,
27 p_item_list IN VARCHAR2,
28 p_category_set IN NUMBER DEFAULT NULL,
29 p_category_name IN VARCHAR2 DEFAULT NULL,
30 p_display_pf_details IN BOOLEAN DEFAULT true);
31
32 PROCEDURE get_detail_records(p_node_type IN NUMBER,
33 p_plan_id IN NUMBER,
34 p_org_id IN NUMBER,
35 p_inst_id IN NUMBER,
36 p_item_id IN NUMBER,
37 p_supplier_id IN NUMBER,
38 p_supplier_site_id IN NUMBER,
39 p_dept_id IN NUMBER,
40 p_res_id IN NUMBER,
41 p_start_date IN DATE,
42 p_end_date IN DATE,
43 p_rowtype IN NUMBER,
44 p_item_query_id IN NUMBER,
45 x_trans_list OUT NOCOPY VARCHAR2,
46 x_error OUT NOCOPY NUMBER,
47 x_err_message OUT NOCOPY VARCHAR2,
48 p_plan_type IN NUMBER DEFAULT 2,
49 p_consumed_row_filter IN VARCHAR2 DEFAULT NULL,
50 p_res_instance_id IN NUMBER DEFAULT 0,
51 p_serial_number IN VARCHAR2 DEFAULT NULL);
52
53 FUNCTION compute_daily_rate_t
54 (var_calendar_code varchar2,
55 var_exception_set_id number,
56 var_daily_production_rate number,
57 var_quantity_completed number,
58 fucd date,
59 var_date date) return number ;
60
61 FUNCTION update_ss
62 (p_plan_id number,
63 p_sr_instance_id number,
64 p_organization_id number,
65 p_item_id number,
66 p_from_date date,
67 p_to_date date,
68 p_new_qty number ) return number ;
69
70
71 END MSC_HORIZONTAL_PLAN_SC;
[Home] [Help]