APPS.WIP_LOT_NUMBER_DEFAULT dependencies on MTL_SYSTEM_ITEMS

Line 11: -- Made this API as autonomous to commit the update to mtl_system_items

7: P_Lot_Number IN VARCHAR2,
8: P_Job_Name IN VARCHAR2,
9: P_Default_Flag IN NUMBER) return VARCHAR2 IS
10: -- Fixed bug 5201815
11: -- Made this API as autonomous to commit the update to mtl_system_items
12:
13: Pragma AUTONOMOUS_TRANSACTION;
14:
15: x_lot_control_code NUMBER;

Line 39: MTL_SYSTEM_ITEMS MSI,

35: MP.AUTO_LOT_ALPHA_PREFIX,
36: MP.LOT_NUMBER_ZERO_PADDING,
37: MP.LOT_NUMBER_LENGTH
38: FROM
39: MTL_SYSTEM_ITEMS MSI,
40: WIP_PARAMETERS WP,
41: MTL_PARAMETERS MP
42: WHERE MP.ORGANIZATION_ID = P_Organization_Id
43: AND WP.ORGANIZATION_ID = P_Organization_Id

Line 135: UPDATE MTL_SYSTEM_ITEMS

131: -- End fix for bug 4768625
132:
133: /** Fix for bug 2923750 -- modification ends **/
134:
135: UPDATE MTL_SYSTEM_ITEMS
136: SET Start_Auto_Lot_Number =
137: decode(Start_Auto_Lot_Number,NULL,NULL,
138: new_auto_lot_number), /** Bug 2923750 **/
139: Last_Update_Date =SYSDATE,