[Home] [Help]
PACKAGE: APPS.CSP_PICK_UTILS
Source
1 PACKAGE CSP_PICK_UTILS AUTHID CURRENT_USER AS
2 /* $Header: cspgtpus.pls 120.2.12020000.5 2012/09/08 19:06:23 hhaugeru ship $ */
3
4 -- Start of comments
5 --
6 -- API name : create_pick
7 -- Type : Type of API (Eg. Public, simple entity)
8 -- Purpose : This API creates picklist headers and lines for spares.
9 -- It calls the auto_detail API of Oracle Inventory which
10 -- creates pick based on the picking rules
11 --
12 -- Modification History
13 -- Date Userid Comments
14 -- --------- ------ ------------------------------------------
15 -- 12/27/99 phegde Created
16 --
17 -- Note :
18 -- End of comments
19
20 Gl_ORG_ID NUMBER := FND_PROFILE.VALUE('ORG_ID');
21 G_PRODUCT_ORGANIZATION NUMBER := FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID');
22
23 G_DELIVERY_NUMBER VARCHAR2(30) ;
24 G_WAYBILL VARCHAR2(30) ;
25 G_RECEIVED_QTY NUMBER ;
26 G_RECEIVED_QTY_UOM VARCHAR2(30);
27 G_STATUS_MEANING VARCHAR2(240);
28 G_RECEIVED_DATE DATE;
29 g_contact_name varchar2(240);
30
31 G_LAST_UPDATE_DATE DATE;
32 G_TASK_ASSIGNMENT_ID NUMBER;
33 G_RESOURCE_NAME VARCHAR2(2000);
34 G_SCHED_TRAVEL_DISTANCE NUMBER;
35 G_SCHED_TRAVEL_DURATION NUMBER;
36 G_ACTUAL_TRAVEL_DISTANCE NUMBER;
37 G_ACTUAL_TRAVEL_DURATION NUMBER;
38 G_MINUTES VARCHAR2(30);
39 G_RESOURCE_CODE VARCHAR2(2000);
40
41 PROCEDURE CSP_ASSIGN_GLOBAL_ORG_ID (P_ORG_ID NUMBER);
42 function CSP_GLOBAL_ORG_ID return number;
43 function CSP_PRODUCT_ORGANIZATION return number;
44
45 PROCEDURE create_pick( p_api_version_number IN NUMBER
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 ,p_order_by IN NUMBER
50 ,p_org_id IN NUMBER
51 ,p_move_order_header_id IN NUMBER
52 ,p_from_subinventory IN VARCHAR2
53 ,p_to_subinventory IN VARCHAR2
54 ,p_date_required IN DATE
55 ,p_created_by IN NUMBER
56 ,p_move_order_type IN NUMBER := 3
57 );
58
59
60 Procedure Confirm_Pick (
61 -- Start of Comments
62 -- Procedure : Confirm_Pick
63 -- Purpose : This procedure inserts the record into the csp_picklist_serial_lots tables based on the
64 -- msnt or the mtlt record associated with the picklist.
65 --
66 -- History :
67 -- UserID Date Comments
68 -- ----------- -------- --------------------------
69 -- klou 02/01/2000 Created.
70 --
71 -- NOTES:
72 --
73 --End of Comments
74 P_Api_Version_Number IN NUMBER
75 ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
76 ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
77 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
78 ,p_picklist_header_id IN NUMBER
79 ,p_organization_id IN NUMBER
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85
86 Procedure Save_Pick (
87 P_Api_Version_Number IN NUMBER
88 ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
89 ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
90 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
91 ,p_picklist_header_id IN NUMBER
92 ,p_organization_id IN NUMBER
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 );
97
98 Procedure Update_Misc_MMTT (
99 P_Api_Version_Number IN NUMBER
100 ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
101 ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
102 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE
103 ,p_transaction_temp_id IN NUMBER
104 ,p_organization_id IN NUMBER
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 );
109
110 Procedure Issue_Savepoint(p_Savepoint Varchar2);
111 Procedure Issue_Rollback(p_Savepoint Varchar2);
112 Procedure Issue_Commit;
113 Function Calculate_Min_Max(p_Subinventory Varchar2,
114 p_Organization_Id Number,
115 p_Edq_factor Number,
116 p_Service_Level Number,
117 p_Item_Cost Number,
118 p_Awu Number,
119 p_Lead_time Number,
120 p_Standard_Deviation Number,
121 p_Safety_Stock_Flag Varchar2,
122 p_Asl_Flag Varchar2) RETURN NUMBER ;
123
124 Function get_min_quantity(p_Subinventory Varchar2,
125 p_Organization_Id Number,
126 p_Edq_factor Number,
127 p_Service_Level Number,
128 p_Item_Cost Number,
129 p_Awu Number,
130 p_Lead_time Number,
131 p_Standard_Deviation Number,
132 p_Safety_Stock_Flag Varchar2,
133 p_Asl_Flag Varchar2) RETURN NUMBER;
134
135 Function get_max_quantity(p_Subinventory Varchar2,
136 p_Organization_Id Number,
137 p_Edq_factor Number,
138 p_Service_Level Number,
139 p_Item_Cost Number,
140 p_Awu Number,
141 p_Lead_time Number,
142 p_Standard_Deviation Number,
143 p_Safety_Stock_Flag Varchar2,
144 p_Asl_Flag Varchar2) RETURN NUMBER;
145
146 Function Get_SAFETY_FACTOR(p_Subinventory Varchar2,
147 p_Organization_Id Number,
148 p_Edq_factor Number,
149 p_Service_Level Number,
150 p_Item_Cost Number,
151 p_Awu Number,
152 p_Lead_time Number,
153 p_Standard_Deviation Number,
154 p_Safety_Stock_Flag Varchar2,
155 p_Asl_Flag Varchar2) RETURN NUMBER;
156
157 Function Get_SAFETY_STOCK(p_Subinventory Varchar2,
158 p_Organization_Id Number,
159 p_Edq_factor Number,
160 p_Service_Level Number,
161 p_Item_Cost Number,
162 p_Awu Number,
163 p_Lead_time Number,
164 p_Standard_Deviation Number,
165 p_Safety_Stock_Flag Varchar2,
166 p_Asl_Flag Varchar2) RETURN NUMBER;
167 Function Get_Service_Level RETURN NUMBER;
168 Function Get_Edq_Factor RETURN NUMBER;
169 Function Get_Asl_Flag RETURN Varchar2;
170 Function Get_Safety_Stock_Flag RETURN Varchar2;
171 Function get_rs_cust_sequence return number;
172
173 -- returns an object name (uses the JTF_OBJECTS table and dynamic PL/SQL)
174 FUNCTION get_object_name
175 ( p_object_type_code in varchar2
176 , p_object_id in number
177 ) return varchar2;
178
179 -- returns constant from fnd_api package
180 FUNCTION get_ret_sts_success return varchar2;
181
182 -- returns constant from fnd_api package
183 FUNCTION get_ret_sts_error return varchar2;
184
185 -- returns constant from fnd_api package
186 FUNCTION get_ret_sts_unexp_error return varchar2;
187
188 FUNCTION get_true return varchar2;
189
190 FUNCTION get_false return varchar2;
191
192 FUNCTION get_assignment(p_task_id NUMBER) return date;
193
194 FUNCTION get_order_status(
195 p_order_line_id NUMBER,
196 p_flow_status_code VARCHAR2) return varchar2;
197
198 FUNCTION get_attribute_value(p_attribute_name VARCHAR2) return VARCHAR2;
199 FUNCTION get_received_qty RETURN NUMBER;
200 FUNCTION get_adjusted_date(p_source_tz_id NUMBER,
201 p_dest_tz_id NUMBER,
202 p_source_day_time DATE) RETURN DATE;
203
204 FUNCTION get_object_Type_meaning(p_object_type_code varchar2) return varchar2;
205 FUNCTION get_contact_name RETURN varchar2;
206 Function get_contact_info(p_incident_id NUMBER) return varchar2 ;
207 FUNCTION get_line_status_meaning(p_line_id NUMBER,
208 p_booked_flag VARCHAR2,
209 p_flow_status_code VARCHAR2,
210 p_lookup_type VARCHAR2 DEFAULT 'LINE_FLOW_STATUS') RETURN VARCHAR2;
211 END; -- Package spec