[Home] [Help]
PACKAGE: APPS.CSP_PICK_UTILS
Source
1 PACKAGE CSP_PICK_UTILS AUTHID CURRENT_USER AS
2 /* $Header: cspgtpus.pls 120.2 2006/10/18 20:25:22 hhaugeru noship $ */
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_contact_name varchar2(240);
29
30 PROCEDURE CSP_ASSIGN_GLOBAL_ORG_ID (P_ORG_ID NUMBER);
31 function CSP_GLOBAL_ORG_ID return number;
32 function CSP_PRODUCT_ORGANIZATION return number;
33
34 PROCEDURE create_pick( p_api_version_number IN NUMBER
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 ,p_order_by IN NUMBER
39 ,p_org_id IN NUMBER
40 ,p_move_order_header_id IN NUMBER
41 ,p_from_subinventory IN VARCHAR2
42 ,p_to_subinventory IN VARCHAR2
43 ,p_date_required IN DATE
44 ,p_created_by IN NUMBER
45 ,p_move_order_type IN NUMBER := 3
46 );
47
48
49 Procedure Confirm_Pick (
50 -- Start of Comments
51 -- Procedure : Confirm_Pick
52 -- Purpose : This procedure inserts the record into the csp_picklist_serial_lots tables based on the
53 -- msnt or the mtlt record associated with the picklist.
54 --
55 -- History :
56 -- UserID Date Comments
57 -- ----------- -------- --------------------------
58 -- klou 02/01/2000 Created.
59 --
60 -- NOTES:
61 --
62 --End of Comments
63 P_Api_Version_Number IN NUMBER
64 ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
65 ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
66 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
67 ,p_picklist_header_id IN NUMBER
68 ,p_organization_id IN NUMBER
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74
75 Procedure Save_Pick (
76 P_Api_Version_Number IN NUMBER
77 ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
78 ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
79 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
80 ,p_picklist_header_id IN NUMBER
81 ,p_organization_id IN NUMBER
82 ,x_return_status OUT NOCOPY VARCHAR2
83 ,x_msg_count OUT NOCOPY NUMBER
84 ,x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 Procedure Update_Misc_MMTT (
88 P_Api_Version_Number IN NUMBER
89 ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
90 ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
91 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE
92 ,p_transaction_temp_id IN NUMBER
93 ,p_organization_id IN NUMBER
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 Procedure Issue_Savepoint(p_Savepoint Varchar2);
100 Procedure Issue_Rollback(p_Savepoint Varchar2);
101 Procedure Issue_Commit;
102 Function Calculate_Min_Max(p_Subinventory Varchar2,
103 p_Organization_Id Number,
104 p_Edq_factor Number,
105 p_Service_Level Number,
106 p_Item_Cost Number,
107 p_Awu Number,
108 p_Lead_time Number,
109 p_Standard_Deviation Number,
110 p_Safety_Stock_Flag Varchar2,
111 p_Asl_Flag Varchar2) RETURN NUMBER ;
112
113 Function get_min_quantity(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_max_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_SAFETY_FACTOR(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_STOCK(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 Function Get_Service_Level RETURN NUMBER;
157 Function Get_Edq_Factor RETURN NUMBER;
158 Function Get_Asl_Flag RETURN Varchar2;
159 Function Get_Safety_Stock_Flag RETURN Varchar2;
160 Function get_rs_cust_sequence return number;
161
162 -- returns an object name (uses the JTF_OBJECTS table and dynamic PL/SQL)
163 FUNCTION get_object_name
164 ( p_object_type_code in varchar2
165 , p_object_id in number
166 ) return varchar2;
167
168 -- returns constant from fnd_api package
169 FUNCTION get_ret_sts_success return varchar2;
170
171 -- returns constant from fnd_api package
172 FUNCTION get_ret_sts_error return varchar2;
173
174 -- returns constant from fnd_api package
175 FUNCTION get_ret_sts_unexp_error return varchar2;
176
177 FUNCTION get_true return varchar2;
178
179 FUNCTION get_false return varchar2;
180
181 FUNCTION get_order_status(
182 p_order_line_id NUMBER,
183 p_flow_status_code VARCHAR2) return varchar2;
184
185 FUNCTION get_attribute_value(p_attribute_name VARCHAR2) return VARCHAR2;
186 FUNCTION get_received_qty RETURN NUMBER;
187 FUNCTION get_adjusted_date(p_source_tz_id NUMBER,
188 p_dest_tz_id NUMBER,
189 p_source_day_time DATE) RETURN DATE;
190
191 FUNCTION get_object_Type_meaning(p_object_type_code varchar2) return varchar2;
192 FUNCTION get_contact_name RETURN varchar2;
193 Function get_contact_info(p_incident_id NUMBER) return varchar2 ;
194 END; -- Package spec