127: l_status_rec.status_id := l_locator_status;
128: l_status_rec.zone_code := p_sub_code;
129: l_status_rec.locator_id := p_locator_id;
130: l_status_rec.creation_date := SYSDATE;
131: l_status_rec.created_by := fnd_global.user_id;
132: l_status_rec.last_update_date := SYSDATE;
133: l_status_rec.last_update_login := fnd_global.user_id;
134: l_status_rec.initial_status_flag := 'Y';
135: l_status_rec.from_mobile_apps_flag := 'Y';
129: l_status_rec.locator_id := p_locator_id;
130: l_status_rec.creation_date := SYSDATE;
131: l_status_rec.created_by := fnd_global.user_id;
132: l_status_rec.last_update_date := SYSDATE;
133: l_status_rec.last_update_login := fnd_global.user_id;
134: l_status_rec.initial_status_flag := 'Y';
135: l_status_rec.from_mobile_apps_flag := 'Y';
136: IF (l_debug = 1) THEN
137: DEBUG('before inserting status history');
151: --Bug 8649041, stamping the WHO columns correctly.
152: --Bug 7143077 The creation date and created by should not be null for dynamic locators
153:
154: UPDATE mtl_item_locations
155: SET created_by = NVL(created_by, fnd_global.user_id)
156: , creation_date = NVL(creation_date, SYSDATE)
157: , last_updated_by = fnd_global.user_id
158: , last_update_login = fnd_global.login_id
159: , last_update_date = SYSDATE
153:
154: UPDATE mtl_item_locations
155: SET created_by = NVL(created_by, fnd_global.user_id)
156: , creation_date = NVL(creation_date, SYSDATE)
157: , last_updated_by = fnd_global.user_id
158: , last_update_login = fnd_global.login_id
159: , last_update_date = SYSDATE
160: , subinventory_code = p_sub_code
161: , status_id = l_locator_status
154: UPDATE mtl_item_locations
155: SET created_by = NVL(created_by, fnd_global.user_id)
156: , creation_date = NVL(creation_date, SYSDATE)
157: , last_updated_by = fnd_global.user_id
158: , last_update_login = fnd_global.login_id
159: , last_update_date = SYSDATE
160: , subinventory_code = p_sub_code
161: , status_id = l_locator_status
162: , inventory_location_type = l_loc_type
1311: l_status_rec.status_id := l_sub_default_status;
1312: l_status_rec.zone_code := p_sub_code;
1313: l_status_rec.locator_id := x_location_id;
1314: l_status_rec.creation_date := SYSDATE;
1315: l_status_rec.created_by := fnd_global.user_id;
1316: l_status_rec.last_update_date := SYSDATE;
1317: l_status_rec.last_update_login := fnd_global.user_id;
1318: l_status_rec.initial_status_flag := 'Y';
1319: l_status_rec.from_mobile_apps_flag := 'Y';
1313: l_status_rec.locator_id := x_location_id;
1314: l_status_rec.creation_date := SYSDATE;
1315: l_status_rec.created_by := fnd_global.user_id;
1316: l_status_rec.last_update_date := SYSDATE;
1317: l_status_rec.last_update_login := fnd_global.user_id;
1318: l_status_rec.initial_status_flag := 'Y';
1319: l_status_rec.from_mobile_apps_flag := 'Y';
1320: inv_material_status_pkg.insert_status_history(l_status_rec);
1321: -- If a new locator is created, call label printing API