1053: inv_trohdr_util.delete_row(p_header_id => l_trohdr_rec.header_id);
1054: ELSE
1055: -- Get Who Information
1056: l_trohdr_rec.last_update_date := SYSDATE;
1057: l_trohdr_rec.last_updated_by := fnd_global.user_id;
1058: l_trohdr_rec.last_update_login := fnd_global.login_id;
1059:
1060: IF l_trohdr_rec.operation = inv_globals.g_opr_update THEN
1061: inv_trohdr_util.update_row(l_trohdr_rec);
1054: ELSE
1055: -- Get Who Information
1056: l_trohdr_rec.last_update_date := SYSDATE;
1057: l_trohdr_rec.last_updated_by := fnd_global.user_id;
1058: l_trohdr_rec.last_update_login := fnd_global.login_id;
1059:
1060: IF l_trohdr_rec.operation = inv_globals.g_opr_update THEN
1061: inv_trohdr_util.update_row(l_trohdr_rec);
1062: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_create THEN
1060: IF l_trohdr_rec.operation = inv_globals.g_opr_update THEN
1061: inv_trohdr_util.update_row(l_trohdr_rec);
1062: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_create THEN
1063: l_trohdr_rec.creation_date := SYSDATE;
1064: l_trohdr_rec.created_by := fnd_global.user_id;
1065: inv_trohdr_util.insert_row(l_trohdr_rec);
1066: END IF;
1067: END IF;
1068: END IF;
1420:
1421: l_trolin_rec.creation_date := l_old_trolin_rec.creation_date;
1422: l_trolin_rec.created_by := l_old_trolin_rec.created_by;
1423: l_trolin_rec.last_update_date := SYSDATE;
1424: l_trolin_rec.last_updated_by := fnd_global.user_id;
1425: l_trolin_rec.last_update_login := fnd_global.login_id;
1426: IF (l_debug = 1) THEN
1427: DEBUG(l_trolin_rec.quantity, 'Inv_Transfer_Order_PVT.Trolins');
1428: DEBUG(l_old_trolin_rec.quantity, 'Inv_Transfer_Order_PVT.Trolins');
1421: l_trolin_rec.creation_date := l_old_trolin_rec.creation_date;
1422: l_trolin_rec.created_by := l_old_trolin_rec.created_by;
1423: l_trolin_rec.last_update_date := SYSDATE;
1424: l_trolin_rec.last_updated_by := fnd_global.user_id;
1425: l_trolin_rec.last_update_login := fnd_global.login_id;
1426: IF (l_debug = 1) THEN
1427: DEBUG(l_trolin_rec.quantity, 'Inv_Transfer_Order_PVT.Trolins');
1428: DEBUG(l_old_trolin_rec.quantity, 'Inv_Transfer_Order_PVT.Trolins');
1429: DEBUG(l_trolin_rec.quantity_detailed, 'Inv_Transfer_Order_PVT.Trolins');
1488: DEBUG('after update row', 'Inv_Transfer_Order_PVT.Trolins');
1489: END IF;
1490: ELSIF l_trolin_rec.operation = inv_globals.g_opr_create THEN
1491: l_trolin_rec.creation_date := SYSDATE;
1492: l_trolin_rec.created_by := fnd_global.user_id;
1493: l_trolin_rec.last_update_date := SYSDATE;
1494: l_trolin_rec.last_updated_by := fnd_global.user_id;
1495: l_trolin_rec.last_update_login := fnd_global.login_id;
1496: IF (l_debug = 1) THEN
1490: ELSIF l_trolin_rec.operation = inv_globals.g_opr_create THEN
1491: l_trolin_rec.creation_date := SYSDATE;
1492: l_trolin_rec.created_by := fnd_global.user_id;
1493: l_trolin_rec.last_update_date := SYSDATE;
1494: l_trolin_rec.last_updated_by := fnd_global.user_id;
1495: l_trolin_rec.last_update_login := fnd_global.login_id;
1496: IF (l_debug = 1) THEN
1497: DEBUG('create row', 'Inv_Transfer_Order_PVT.Trolins');
1498: END IF;
1491: l_trolin_rec.creation_date := SYSDATE;
1492: l_trolin_rec.created_by := fnd_global.user_id;
1493: l_trolin_rec.last_update_date := SYSDATE;
1494: l_trolin_rec.last_updated_by := fnd_global.user_id;
1495: l_trolin_rec.last_update_login := fnd_global.login_id;
1496: IF (l_debug = 1) THEN
1497: DEBUG('create row', 'Inv_Transfer_Order_PVT.Trolins');
1498: END IF;
1499: /*Bug#5764123. Added the below line to convert the MISSING data
4400: /*UPDATE WSH_DELIVERY_DETAILS
4401: SET CONTAINER_NAME=l_new_container_name,
4402: lpn_id=NULL,
4403: last_update_date=sysdate,
4404: last_updated_by=fnd_global.user_id,
4405: last_update_login=fnd_global.login_id
4406: WHERE container_name = l_container_name ;
4407: */
4408: /*
4401: SET CONTAINER_NAME=l_new_container_name,
4402: lpn_id=NULL,
4403: last_update_date=sysdate,
4404: last_updated_by=fnd_global.user_id,
4405: last_update_login=fnd_global.login_id
4406: WHERE container_name = l_container_name ;
4407: */
4408: /*
4409: IF (l_debug = 1) THEN