DBA Data[Home] [Help]

APPS.INV_STATUS_PKG dependencies on INV_MATERIAL_STATUS_PKG

Line 396: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

392: -- Bug# 1695432 added initial_status_flag and from_mobile_apps_flag
393: l_status_rec.initial_status_flag := 'N';
394: l_status_rec.from_mobile_apps_flag := p_update_from_mobile;
395: -- update the status history
396: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
397: end if;
398: IF (l_debug = 1) THEN
399: mdebug('p_loc_status_id: '||p_loc_status_id);
400: END IF;

Line 418: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

414: -- Bug# 1695432 added initial_status_flag and from_mobile_apps_flag
415: l_status_rec.initial_status_flag := 'N';
416: l_status_rec.from_mobile_apps_flag := p_update_from_mobile;
417: -- update the status history
418: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
419: end if;
420: IF (l_debug = 1) THEN
421: mdebug('p_lot_status_id: '||p_lot_status_id);
422: END IF;

Line 447: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

443: l_status_rec.lot_number := cc.lot_number;
444: -- Bug# 1695432 added initial_status_flag and from_mobile_apps_flag
445: l_status_rec.initial_status_flag := 'N';
446: l_status_rec.from_mobile_apps_flag := p_update_from_mobile;
447: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
448: END LOOP;
449: end if;
450: IF (l_debug = 1) THEN
451: mdebug('p_serial_status_id: '||p_serial_status_id);

Line 472: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

468: -- Bug# 1695432 added initial_status_flag and from_mobile_apps_flag
469: l_status_rec.initial_status_flag := 'N';
470: l_status_rec.from_mobile_apps_flag := p_update_from_mobile;
471: -- update the status history
472: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
473:
474: end if;
475:
476: ------Start of changes for # 6633612---------------

Line 667: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

663: l_status_rec.initial_status_flag := 'N';
664: l_status_rec.from_mobile_apps_flag := p_update_from_mobile;
665: -- Bug 6798024
666: l_count := l_count + 1;
667: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
668: END LOOP;
669:
670: -- Bug 6798024 : If insert history was not called from inside the lot loop then call it from here
671: if (l_count = 0) then

Line 672: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

668: END LOOP;
669:
670: -- Bug 6798024 : If insert history was not called from inside the lot loop then call it from here
671: if (l_count = 0) then
672: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
673: end if;
674: EXCEPTION WHEN OTHERS THEN
675: mdebug(' IN OTHERS EXCEPTION '||sqlerrm);
676: FND_MESSAGE.SET_NAME('FND','FLEX-HASH DEADLOCK');