PACKAGE: APPS.MSC_HORIZONTAL_PLAN_SC

Source

1 PACKAGE MSC_HORIZONTAL_PLAN_SC AUTHID CURRENT_USER AS
2 /* $Header: MSCPHOPS.pls 120.1 2008/08/19 22:24:18 cnazarma ship $ */
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                 p_project_id IN VARCHAR2 DEFAULT NULL,
53                 p_task_id IN VARCHAR2 DEFAULT NULL);
54 
55 
56 FUNCTION      compute_daily_rate_t
57                     (var_calendar_code varchar2,
58                      var_exception_set_id number,
59                      var_daily_production_rate number,
60                      var_quantity_completed number,
61                      fucd date,
62                      var_date date) return number  ;
63 
64 FUNCTION     update_ss
65              (p_plan_id number,
66               p_sr_instance_id number,
67               p_organization_id number,
68               p_item_id number,
69               p_from_date date,
70               p_to_date date,
71               p_new_qty number ) return number ;
72 
73 
74 END MSC_HORIZONTAL_PLAN_SC;