1 PACKAGE MSC_AATP_FUNC AUTHID CURRENT_USER AS
2 /* $Header: MSCFAATS.pls 120.1 2007/12/12 10:26:52 sbnaik ship $ */
3
4
5 FUNCTION Get_Allowed_Stolen_Percent(
6 p_instance_id IN NUMBER,
7 p_inv_item_id IN NUMBER,
8 p_org_id IN NUMBER,
9 p_dept_id IN NUMBER,
10 p_res_id IN NUMBER,
11 p_demand_class IN VARCHAR2,
12 p_request_date IN DATE)
13 RETURN NUMBER;
14
15
16 FUNCTION Get_DC_Alloc_Percent(
17 p_instance_id IN NUMBER,
18 p_inv_item_id IN NUMBER,
19 p_org_id IN NUMBER,
20 p_dept_id IN NUMBER,
21 p_res_id IN NUMBER,
22 p_demand_class IN VARCHAR2,
23 p_request_date IN DATE)
24 RETURN NUMBER;
25
26
27 FUNCTION Get_Hierarchy_Demand_Class(
28 p_partner_id IN NUMBER,
29 p_partner_site_id IN NUMBER,
30 p_inventory_item_id IN NUMBER,
31 p_organization_id IN NUMBER,
32 p_instance_id IN NUMBER,
33 p_request_date IN DATE,
34 p_level_id IN NUMBER,
35 p_demand_class IN VARCHAR2)
36 RETURN VARCHAR2;
37
38
39 FUNCTION Get_Item_Demand_Alloc_Percent(
40 p_plan_id IN NUMBER,
41 p_demand_id IN NUMBER,
42 p_demand_date IN DATE,
43 p_assembly_item_id IN NUMBER,
44 p_source_org_id IN NUMBER,
45 p_inventory_item_id IN NUMBER,
46 p_org_id IN NUMBER,
47 p_instance_id IN NUMBER,
48 p_origination_type IN NUMBER,
49 p_record_class IN VARCHAR2,
50 p_demand_class IN VARCHAR2,
51 p_level_id IN NUMBER)
52 RETURN NUMBER;
53
54
55 FUNCTION Get_Res_Demand_Alloc_Percent(
56 p_demand_date IN DATE,
57 p_assembly_item_id IN NUMBER,
58 p_org_id IN NUMBER,
59 p_instance_id IN NUMBER,
60 p_dept_id IN NUMBER,
61 p_res_id IN NUMBER,
62 p_record_class IN VARCHAR2,
63 p_demand_class IN VARCHAR2)
64 RETURN NUMBER;
65
66 FUNCTION Get_Res_Hierarchy_Demand_Class(
67 p_partner_id IN NUMBER,
68 p_partner_site_id IN NUMBER,
69 p_department_id IN NUMBER,
70 p_resource_id IN NUMBER,
71 p_organization_id IN NUMBER,
72 p_instance_id IN NUMBER,
73 p_request_date IN DATE,
74 p_level_id IN NUMBER,
75 p_demand_class IN VARCHAR2)
76 RETURN VARCHAR2;
77
78
79
80 END MSC_AATP_FUNC;