439: v_item_id := pr_new.inventory_item_id;
440: v_new_trans_qty := pr_new.transaction_quantity;
441: v_new_adjust_qty := pr_new.quantity_adjusted;
442: v_debug := 'Y';
443: ln_last_updated_by := fnd_global.user_id; /* added by aiyer for the bug 4764510 */
444: ln_created_by := ln_last_updated_by; /* added by aiyer for the bug 4764510 */
445: ln_last_update_login := fnd_global.login_id;/* added by aiyer for the bug 4764510 */
446: /* --Ramananda for File.Sql.35 */
447:
441: v_new_adjust_qty := pr_new.quantity_adjusted;
442: v_debug := 'Y';
443: ln_last_updated_by := fnd_global.user_id; /* added by aiyer for the bug 4764510 */
444: ln_created_by := ln_last_updated_by; /* added by aiyer for the bug 4764510 */
445: ln_last_update_login := fnd_global.login_id;/* added by aiyer for the bug 4764510 */
446: /* --Ramananda for File.Sql.35 */
447:
448: /* Bug 5413264. Added by Lakshmi Gopalsami
449: Commented the following call as this check is already done in trigger