112: -- convert missing value in the input record
113: -- to null or proper default value .
114:
115: PROCEDURE Initialize_status_rec(px_status_rec
116: IN OUT NOCOPY INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type )
117: IS
118: BEGIN
119: if px_status_rec.organization_id = fnd_api.g_miss_num THEN
120: px_status_rec.organization_id := NULL;
239:
240: END Initialize_status_rec;
241:
242: PROCEDURE Insert_status_history(p_status_rec
243: IN INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type )
244: IS
245: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;
246: l_msg_count NUMBER;
247: l_msg_data VARCHAR2(2000);
241:
242: PROCEDURE Insert_status_history(p_status_rec
243: IN INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type )
244: IS
245: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;
246: l_msg_count NUMBER;
247: l_msg_data VARCHAR2(2000);
248: l_label_status varchar2(300);
249: l_return_status varchar2(1);