1 PACKAGE MSC_ATP_FUNC AS
2 /* $Header: MSCFATPS.pls 120.1 2007/12/12 10:27:30 sbnaik ship $ */
3
4 FUNCTION get_atp_flag (p_instance_id IN NUMBER,
5 p_plan_id IN NUMBER,
6 p_inventory_item_id IN NUMBER,
7 p_organization_id IN NUMBER)
8 RETURN VARCHAR2;
9
10
11 FUNCTION get_atp_comp_flag (p_instance_id IN NUMBER,
12 p_plan_id IN NUMBER,
13 p_inventory_item_id IN NUMBER,
14 p_organization_id IN NUMBER)
15 RETURN VARCHAR2;
16
17
18 FUNCTION get_location_id (p_instance_id IN NUMBER,
19 p_organization_id IN NUMBER,
20 p_customer_id IN NUMBER,
21 p_customer_site_id IN NUMBER,
22 p_supplier_id IN NUMBER,
23 p_supplier_site_id IN NUMBER)
24 RETURN NUMBER;
25
26
27 FUNCTION get_infinite_time_fence_date (p_instance_id IN NUMBER,
28 p_inventory_item_id IN NUMBER,
29 p_organization_id IN NUMBER,
30 p_plan_id IN NUMBER)
31 RETURN DATE;
32
33
34 FUNCTION get_org_code (p_instance_id IN NUMBER,
35 p_organization_id IN NUMBER)
36 RETURN VARCHAR2;
37
38
39 FUNCTION get_inv_item_name (p_instance_id IN NUMBER,
40 p_inventory_item_id IN NUMBER,
41 p_organization_id IN NUMBER)
42 RETURN VARCHAR2;
43
44
45 FUNCTION get_inv_item_id (p_instance_id IN NUMBER,
46 p_inventory_item_id IN NUMBER,
47 p_match_item_id IN NUMBER,
48 p_organization_id IN NUMBER)
49 RETURN NUMBER;
50
51
52 FUNCTION get_supplier_name (p_instance_id IN NUMBER,
53 p_supplier_id IN NUMBER)
54 RETURN VARCHAR2;
55
56
57 FUNCTION get_supplier_site_name (p_instance_id IN NUMBER,
58 p_supplier_site_id IN NUMBER)
59 RETURN VARCHAR2;
60
61
62 FUNCTION get_location_code (p_instance_id IN NUMBER,
63 p_location_id IN NUMBER)
64 RETURN VARCHAR2;
65
66
67 FUNCTION get_sd_source_name (p_instance_id IN NUMBER,
68 p_sd_type IN NUMBER,
69 p_sd_source_type IN NUMBER)
70 RETURN VARCHAR2;
71
72
73 FUNCTION prev_work_day(p_organization_id IN NUMBER,
74 p_instance_id IN NUMBER,
75 p_date IN DATE)
76 RETURN DATE;
77
78
79 FUNCTION MPS_ATP(p_desig_id IN NUMBER)
80 RETURN NUMBER;
81
82
83 FUNCTION Get_Designator(p_desig_id IN NUMBER)
84 RETURN VARCHAR2;
85
86
87 FUNCTION Get_MPS_Demand_Class(p_desig_id IN NUMBER)
88 RETURN VARCHAR2;
89
90
91 FUNCTION NEXT_WORK_DAY_SEQNUM(p_organization_id IN NUMBER,
92 p_instance_id IN NUMBER,
93 p_date IN DATE)
94 RETURN number;
95
96
97 FUNCTION get_tolerance_percentage(
98 p_instance_id IN NUMBER,
99 p_plan_id IN NUMBER,
100 p_inventory_item_id IN NUMBER,
101 p_organization_id IN NUMBER,
102 p_supplier_id IN NUMBER,
103 p_supplier_site_id IN NUMBER,
104 p_seq_num_difference IN NUMBER -- For ship_rec_cal
105 )
106 RETURN NUMBER;
107
108
109 FUNCTION Get_Order_Number(p_supply_id IN NUMBER,
110 p_plan_id IN NUMBER)
111 RETURN VARCHAR2;
112
113
114 FUNCTION Get_Order_Type(p_supply_id IN NUMBER,
115 p_plan_id IN NUMBER)
116 RETURN NUMBER;
117
118 -- savirine, Sep24, 2001: added the parameters p_session_id and p_partner_site_id
119
120 FUNCTION get_interloc_transit_time (p_from_location_id IN NUMBER,
121 p_from_instance_id IN NUMBER,
122 p_to_location_id IN NUMBER,
123 p_to_instance_id IN NUMBER,
124 p_ship_method IN VARCHAR2,
125 p_session_id IN NUMBER DEFAULT NULL,
126 p_partner_site_id IN NUMBER DEFAULT NULL)
127 return NUMBER;
128
129
130 FUNCTION Calc_Arrival_date(
131 org_id IN NUMBER,
132 instance_id IN NUMBER,
133 customer_id IN NUMBER,
134 bucket_type IN NUMBER,
135 sch_ship_date IN DATE,
136 req_arrival_date IN DATE,
137 delivery_lead_time IN NUMBER
138
139 ) RETURN DATE;
140
141
142 -- ngoel 9/28/2001, added this function for use in View MSC_SCATP_SOURCES_V to support
143 -- Region Level Sourcing.
144
145 FUNCTION Get_Session_id
146 RETURN NUMBER;
147
148 -- rajjain 02/19/2003 Bug 2788302 Begin
149 --pumehta added this function to get process_sequence_id to be populated when
150 --adding a planned order for Make Case.
151 FUNCTION get_process_seq_id(
152 p_plan_id IN NUMBER,
153 p_item_id IN NUMBER,
154 p_organization_id IN NUMBER,
155 p_sr_instance_id IN NUMBER,
156 p_new_schedule_date IN DATE
157 ) RETURN NUMBER;
158 -- rajjain 02/19/2003 Bug 2788302 End
159
160 END MSC_ATP_FUNC;