195: END IF;
196: IF (p_status_rec.created_by = FND_API.G_MISS_NUM)
197: OR TRIM(p_status_rec.created_by) IS NULL
198: THEN
199: l_created_by := fnd_global.user_id;
200: ELSE
201: l_created_by := p_status_rec.created_by ;
202: END IF;
203: IF (p_status_rec.last_update_date = FND_API.G_MISS_DATE)
209: END IF;
210: IF (p_status_rec.last_update_login = FND_API.G_MISS_NUM)
211: OR TRIM(p_status_rec.last_update_login) IS NULL
212: THEN
213: l_last_update_login := fnd_global.login_id;
214: ELSE
215: l_last_update_login := p_status_rec.last_update_login;
216: END IF;
217: IF (p_status_rec.last_updated_by = FND_API.G_MISS_NUM)
216: END IF;
217: IF (p_status_rec.last_updated_by = FND_API.G_MISS_NUM)
218: OR TRIM(p_status_rec.last_updated_by) IS NULL
219: THEN
220: l_last_updated_by := fnd_global.user_id;
221: ELSE
222: l_last_updated_by := p_status_rec.last_updated_by ;
223: END IF;
224:
836:
837: IF p_status_rec.last_update_login = FND_API.G_MISS_NUM
838: OR TRIM(p_status_rec.last_update_login) IS NULL
839: THEN
840: l_last_update_login := fnd_global.login_id;
841: ELSE
842: l_last_update_login := p_status_rec.last_update_login;
843: END IF;
844:
844:
845: IF p_status_rec.last_updated_by = FND_API.G_MISS_NUM
846: OR TRIM(p_status_rec.last_updated_by) IS NULL
847: THEN
848: l_last_updated_by := fnd_global.user_id;
849: ELSE
850: l_last_updated_by := p_status_rec.last_updated_by;
851: END IF;
852: