DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on INV_MATERIAL_STATUS_GRP

Line 1309: l_sub_return := inv_material_status_grp.is_trx_allowed(

1305: OPEN c_sub_status;
1306: FETCH c_sub_status INTO l_sub_status;
1307: IF c_sub_status%FOUND AND l_sub_status IS NOT NULL THEN
1308: --check if txn type allowed with given sub status
1309: l_sub_return := inv_material_status_grp.is_trx_allowed(
1310: p_status_id => l_sub_status
1311: ,p_transaction_type_id => p_transaction_type_id
1312: ,x_return_status => l_return_status
1313: ,x_msg_count => l_msg_count

Line 1347: l_loc_return := inv_material_status_grp.is_trx_allowed(

1343: OPEN c_loc_status;
1344: FETCH c_loc_status INTO l_loc_status;
1345: IF c_loc_status%FOUND AND l_loc_status IS NOT NULL THEN
1346: --check if txn type allowed with given locator status
1347: l_loc_return := inv_material_status_grp.is_trx_allowed(
1348: p_status_id => l_loc_status
1349: ,p_transaction_type_id => p_transaction_type_id
1350: ,x_return_status => l_return_status
1351: ,x_msg_count => l_msg_count

Line 1375: inv_material_status_grp.get_lot_serial_status_control(

1371: print_debug('check sub_lot_loc_trx_allowed l_loc_return '||l_loc_return);
1372: END IF;
1373:
1374: --if item is lot status controlled, check if txn type is allowed
1375: inv_material_status_grp.get_lot_serial_status_control(
1376: p_organization_id => p_organization_id
1377: ,p_inventory_item_id => p_inventory_item_id
1378: ,x_return_status => l_return_status
1379: ,x_msg_count => l_msg_count

Line 1402: l_lot_return := inv_material_status_grp.is_trx_allowed(

1398: ELSE
1399: OPEN c_lot_status;
1400: FETCH c_lot_status INTO l_lot_status;
1401: IF c_lot_status%FOUND AND l_lot_status IS NOT NULL THEN
1402: l_lot_return := inv_material_status_grp.is_trx_allowed(
1403: p_status_id => l_lot_status
1404: ,p_transaction_type_id => p_transaction_type_id
1405: ,x_return_status => l_return_status
1406: ,x_msg_count => l_msg_count

Line 1484: inv_material_status_grp.get_lot_serial_status_control(

1480: --if item is serial status controlled, check if txn type is allowed
1481: g_organization_id := p_organization_id;
1482: g_inventory_item_id := p_inventory_item_id;
1483:
1484: inv_material_status_grp.get_lot_serial_status_control(
1485: p_organization_id => p_organization_id
1486: ,p_inventory_item_id => p_inventory_item_id
1487: ,x_return_status => l_return_status
1488: ,x_msg_count => l_msg_count

Line 1510: g_serial_return := inv_material_status_grp.is_trx_allowed(

1506: ELSE
1507: g_serial_status := p_serial_status;
1508: g_transaction_type_id := p_transaction_type_id;
1509:
1510: g_serial_return := inv_material_status_grp.is_trx_allowed(
1511: p_status_id => p_serial_status
1512: ,p_transaction_type_id => p_transaction_type_id
1513: ,x_return_status => l_return_status
1514: ,x_msg_count => l_msg_count

Line 4297: l_status_return := inv_material_status_grp.is_trx_allowed(

4293: IF ( l_debug = 1 ) THEN
4294: print_debug('Value of l_status_id:'||l_status_id, 1);
4295: END IF;
4296:
4297: l_status_return := inv_material_status_grp.is_trx_allowed(
4298: p_status_id => l_status_id
4299: ,p_transaction_type_id => p_transaction_type_id
4300: ,x_return_status => l_status_return ,x_msg_count => l_msg_count
4301: ,x_msg_data => l_msg_data);