DBA Data[Home] [Help]

APPS.INV_STATUS_PKG dependencies on INV_MATERIAL_STATUS_PKG

Line 813: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

809:
810: l_status_rec.pending_status := p_pending_status; --ERES Deferred
811:
812: -- update the status history
813: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
814: end if;
815: IF (l_debug = 1) THEN
816: mdebug('p_loc_status_id: '||p_loc_status_id);
817: END IF;

Line 868: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

864:
865: l_status_rec.pending_status := p_pending_status; --ERES Deferred
866:
867: -- update the status history
868: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
869: end if;
870: IF (l_debug = 1) THEN
871: mdebug('p_lot_status_id: '||p_lot_status_id);
872: END IF;

Line 936: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

932: l_status_rec.initial_status_flag := 'N';
933: l_status_rec.from_mobile_apps_flag := p_update_from_mobile;
934: l_status_rec.pending_status := p_pending_status; --ERES Deferred
935:
936: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
937: END LOOP;
938: end if;
939: IF (l_debug = 1) THEN
940: mdebug('p_serial_status_id: '||p_serial_status_id);

Line 995: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

991: l_status_rec.from_mobile_apps_flag := p_update_from_mobile;
992: -- update the status history
993: l_status_rec.pending_status := p_pending_status; --ERES Deferred
994:
995: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
996:
997: end if;
998:
999: ------Start of changes for # 6633612---------------

Line 1224: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

1220: l_status_rec.locator_id := j.locator_id;
1221: l_status_rec.lpn_id := j.lpn_id;
1222: l_status_rec.lot_number := j.lot_number;
1223: l_status_rec.primary_onhand := j.primary_onhand;
1224: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
1225: END LOOP;
1226: end if ;
1227: END LOOP;
1228:

Line 1249: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);

1245: l_status_rec.lpn_id := j.lpn_id;
1246: l_status_rec.lot_number := j.lot_number;
1247: l_status_rec.primary_onhand := j.primary_onhand;
1248: l_count := l_count + 1;
1249: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
1250:
1251: END LOOP;
1252:
1253: end if;